Copy tables from one database to the other in PostgreSQL

Question

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?

Possible duplicate of Copy a table from one database to another in Postgres — Brian Tompsett - 汤莱恩
– Brian Tompsett - 汤莱恩, Commented Jul 21, 2017 at 19:32

user2148736 · Accepted Answer · 2013-03-13 15:53:28Z

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

edited Mar 13, 2013 at 15:53

answered Mar 13, 2013 at 13:44

user2148736

1,3214 gold badges24 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy tables from one database to the other in PostgreSQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related