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,753
  • 72
  • 57
  • 129
f.ashouri
  • 5,409
  • 13
  • 44
  • 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,283
  • 4
  • 24
  • 39