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.

Answer 1

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

Answer 2

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.