By using AWS re:Post, you agree to the Terms of Use

How can I migrate a jsonb column from postgres on RDS to S3?


I have a table in a Postgres on RDS db with a jsonb column. I want to move this data to an S3 bucket and use federated queries to access this data. How can I do this?

1 Answers


Thanks for posting to AWS re:Post. I wanted to share my two cents on the matter here.

In this case you can use DMS - JSONB is supported as a source in PostGreSQL engines.

[] Using a PostgreSQL database as an AWS DMS source - Source data types for PostgreSQL -

Then, you can refer->

[] Using Amazon S3 as a target for AWS Database Migration Service -

Hope this helps.

answered a month ago
  • I still don't follow how to query the IR in postgres after moving to s3.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions