Want to schedule and automate from Redshift to PostgreSQL copy data task?
Try Withdata DB Copier, a desktop tool, you can scheduled Redshift to PostgreSQL copy data task easily, just a few mouse clicks!
Let computer automate repetitive Redshift to PostgreSQL transfer data busy work, DB Copier make our life easier!
Here you can download and install DB Copier.
Schedule and automate Redshift to PostgreSQL data task
1. Select and run a task from follow list:
- Merge multiple similar Redshift tables to 1 PostgreSQL table
- Batch copy Redshift tables to PostgreSQL
- Copy Redshift query results to PostgreSQL table
- Copy Redshift table data to PostgreSQL
- Migrate Redshift to PostgreSQL
- Sync data from Redshift to PostgreSQL
- Convert Redshift To PostgreSQL
2. Save session and create .bat file.
More about Withdata DBCopier – the tool to copy Redshift data to PostgreSQL
Redshift → PostgreSQL reference
Type mapping
| Value kind | in Redshift | in PostgreSQL |
|---|---|---|
| Long text | varchar(max) | text |
| Binary | (none) | bytea |
| JSON | super | jsonb |
Dialect differences
Both Redshift and PostgreSQL are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.
| Property | in Redshift | in PostgreSQL |
|---|---|---|
| port | 5439 | 5432 |
| dates | timestamp, date | timestamp, timestamptz, date, time |
| long text | VARCHAR(MAX) | TEXT |
| binary | — | BYTEA |
Command line
| Side | Command |
|---|---|
| Redshift | UNLOAD to S3 |
| PostgreSQL | pg_dump or COPY ... TO |
| PostgreSQL (load) | COPY ... FROM |
| Redshift (load) | COPY from S3 |
No counterpart
- PostgreSQL has no equivalent for Binary - it has to be flattened or dropped.
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.