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

Question

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 1

Use --table to tell pg_dump what table it has to backup. On Windows :

C:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe --host localhost --port 5432 --username postgres --format plain --ignore-version --verbose --file "C:\temp\filename.backup" --table public.tablename dbname