Postgres Command Line tool for Import/Exporting data/ddl

Question

For Postgres is there any sort of command line utilities that allow a database to be "dumped to a file" and that allow that same database dump to be imported?

I know this can be done through PGAdmin, but I need to be able to do this on the cmd line.

If anyone want Export/Import for whole DB then look at Export and Import of PostgresSQL using pgAdmin III — Somnath Muluk
– Somnath Muluk, Commented Aug 26, 2016 at 13:32

Kenaniah · Accepted Answer · 2010-02-22 20:47:13Z

6

Yeah, take a look into pg_dump and pg_restore

http://www.postgresql.org/docs/current/static/app-pgdump.html

http://www.postgresql.org/docs/current/static/app-pgrestore.html

answered Feb 22, 2010 at 20:47

Kenaniah

5,20126 silver badges28 bronze badges

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

2 Comments

ericn Over a year ago

Thanks but you could have given a simple example (one line of code for pg_dump and another for pg_restore), that would have been much more helpful

Pentux Over a year ago

pg_restore -U postgres -W -d dvdrental /tmp/dvdrental.tar -U is username -W is password (not put password in this line, it will appear a promt) -d is database and finally specify path of file

Joshua D. Drake · Accepted Answer · 2010-02-25 18:08:07Z

1

Correct, the way to do this is the pg_dump, pg_dumpall and pg_restore commands. In fact, I think pg_admin actually calls those commands itself. It doesn't actually have backup/restore built in but is just a wrapper.

answered Feb 25, 2010 at 18:08

Joshua D. Drake

1,0125 silver badges6 bronze badges

Collectives™ on Stack Overflow

Postgres Command Line tool for Import/Exporting data/ddl

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related