Amazon Aurora with PostgreSQL compatibility now supports importing of data stored in a Amazon Simple Storage Service (S3) bucket into a PostgreSQL table. A new extension aws_s3 has been added to perform the import operation. You can import any data format that is supported by the PostgreSQL COPY command, using the ARN role association method or using Amazon S3 credentials.
Import from Amazon S3 is supported with Aurora PostgreSQL version 2.3, compatible with PostgreSQL 10.7. To learn more, please visit the documentation page.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. To learn more about Amazon Aurora with PostgreSQL compatibility, please visit our product page.
from Recent Announcements https://aws.amazon.com/about-aws/whats-new/2019/06/amazon-aurora-with-postgresql-compatibility-supports-data-import-from-amazon-s3/