0

I have a number of tables in a database in the server side in PostgreSQL. I want to have them all in another database. Is it possible?

Brian Tompsett - 汤莱恩
  • 5,438
  • 68
  • 55
  • 126
f.ashouri
  • 5,277
  • 13
  • 41
  • 52
  • http://stackoverflow.com/questions/3195125/copy-a-table-from-one-database-to-another-in-postgres – bob Mar 13 '13 at 13:42
  • Possible duplicate of [Copy a table from one database to another in Postgres](https://stackoverflow.com/questions/3195125/copy-a-table-from-one-database-to-another-in-postgres) – Brian Tompsett - 汤莱恩 Jul 21 '17 at 19:32

1 Answers1

1

Use PostgreSQL pg_dump utility with -t table option to define tables that should be dumped and restore them in a another database. For more information see PostgreSQL pg_dump documentation page

user2148736
  • 1,233
  • 3
  • 21
  • 39