News for hackers. Stuff that matters.

A comment on My experience with exporting Postgres RDS partitioned tables to S3. Parent comment

Re:My experience with exporting Postgres RDS partitioned tab... by iknownothow on Sunday May 15, 2022 @05:16PM (#31391211)
As far I can tell, exporting query results from Postgres RDS to S3 uses Postgres's Copy and only supports CSV and Text [1]. Can you provide a link for parquet exports?

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postg...

[ Parent | on HN ]
Re:My experience with exporting Postgres RDS partitioned tab... by vanpythonista on Sunday May 15, 2022 @05:21PM (#31391266)
You can use a RDS Snapshot to export to S3 in Parquet format: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
[ Parent | on HN ]