It looks to me like you haven't installed the postgresql driver.
Install the SQL Drivers and AWS Schema Conversion Tool on Your Local Computer
This frustrated me for a couple hours a few months ago. I found these step by step walk throughs very useful. Database Migration Step-by-Step Walkthroughs
Error loading metadata using AWS SCT against an RDS SQL Server Instanceasked 8 months ago
Error while connecting to SQL Server Express Edition from SCTasked a year ago
AWS DMS Issues | Duplicate Tables and SCT Conversion IssueAccepted Answerasked 2 years ago
AWS Schema Conversion Tool - Troubleshooting a Connection Error?
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 3 months ago
SCT connecting to MySQL over SSLasked 4 months ago
Migrate SQL Server DB (outside of AWS) to Aurora DB in AWSAccepted Answer
Does SCT support converting Oracle View to Redshift View?asked 2 months ago
Error connecting to Aurora PostgreSQL dB in .NET Core Lambda function.asked 5 months ago
Error when trying to add db instance to VS server explorerasked 3 years ago