postgresql - Copy a table from one database to another in Postgres - Stack Overflow

PHOTO EMBED

Thu Mar 24 2022 09:24:34 GMT+0000 (UTC)

Saved by @jacopo #sql

pg_dump -a -t table_to_copy source_db | psql target_db
content_copyCOPY

https://stackoverflow.com/questions/3195125/copy-a-table-from-one-database-to-another-in-postgres