Transferring data from one database to another (Postgres)

Question

I have 2 exactly same databases on 2 different machines(with different data that is), and I want to transfer contents of one table to the table from the other database, how do I do that from PgAdmin? I'm new to PostgreSQL Database, I'd do that easily with mysql phpmyadmin just export sql and I'd get text file with bunch of insert into statements, is there equivalent with PgAdmin ?

Milen A. Radev · Accepted Answer · 2010-05-10 13:44:40Z

3

Yes, backup using "PLAIN" format (SQL statements) and then (when connected to the other DB) open the file and run it.

Or you could select "COMPRESS" format in the "backup" dialogue, and then you could use the restore dialogue.

Also there's an equivalent of phpMyAdmin for Postgres, called "phppgadmin". Select the table in question and then use the "Export" tab.

edited May 10, 2010 at 13:44

answered May 10, 2010 at 13:39

Milen A. Radev

63.2k22 gold badges111 silver badges112 bronze badges

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

1 Comment

Kuberchaun Over a year ago

This of course assumes there are no data clashing and/or remapping of value issues to deal with.

Collectives™ on Stack Overflow

Transferring data from one database to another (Postgres)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related