How to create a backup of a single table in a postgres database?

postgresql backup pg-dump
Elitmiar picture Elitmiar · Sep 10, 2010 · Viewed 224.4k times · Source

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Answer

Frank Heikens picture Frank Heikens · Sep 10, 2010

Use --table to tell pg_dump what table it has to backup:

pg_dump --host localhost --port 5432 --username postgres --format plain --verbose --file "<abstract_file_path>" --table public.tablename dbname

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
postgresql where does the output of pg_dump go

I am trying to backup a db of postgresql and I want to use pg_dump command. I tried : psql -U postgres postgres-# pg_dump test > backup.sql But I don't know where the output file goes. Any help …

Read More
"permission denied" for pg_dump output file

i used below command to backup my database sudo -u user_name pg_dump dbName -f /home ..../someWhere/db.sql but it gives me this : pg_dump: [archiver] could not open output file "/home ..../someWhere/db.sql": Permission denied after …

Read More