Copy a table from one database to another in Postgres

by

Extract the table and pipe it directly to the target database:

pg_dump -t table_to_copy source_db | psql target_db

Note: If the other database already has the table set up, you should use the -a flag to import data only, else you may see weird errors like “Out of memory”:

pg_dump -a -t table_to_copy source_db | psql target_db

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. What is the format for the PostgreSQL connection string / URL?
  8. Go and IN clause in Postgres
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. PostgreSQL function returning multiple result sets
  13. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  14. Can’t connect the postgreSQL with psycopg2
  15. Difference between GiST and GIN index
  16. Test for null in function with varying parameters
  17. PostgreSQL: Why psql can’t connect to server?
  18. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  19. Can I use return value of INSERT…RETURNING in another INSERT?
  20. Changing a postgres containers server port in Docker Compose
  21. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  22. no pg_hba.conf entry for host
  23. PostgreSQL – disabling constraints
  24. PostgreSQL authentication method 10 not supported
  25. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  26. input file appears to be a text format dump. Please use psql
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment