CODEWITHSUNDEEP
postgresqlpg-dump
StOMicha
StOMicha

Reputation: 379

PostgreSQL: pg_dump for a single table

I'm beginner with PostgreSQL and doing backups using:

sudo -u postgres pg_dumpall > /~/postgreBackup.SQL

Works fine! Now I want to backup a single table "TableName" in a scheme "SchemeName" and tried

sudo -u postgres pg_dump --table "SchemaName"."TableName" > /~/Dummy.SQL

pg_dump: no matching tables were found

How to get it working?

Upvotes: 5

Views: 15993

Answers (1)

Amjad Shahzad
Amjad Shahzad

Reputation: 822

When you have case sensitive table and schema name you have to do the proper quoting of a table name. The below command should work fine as I have successfully executed it at my end.

Please make sure you are using the correct case sensitive name of database, schema and table in this command.

./pg_dump --dbname="myDatabase" --host=localhost --port=5432 --username=postgres  --table='"MyScheme"."TableName 01"' --file=Dummy

OR

./pg_dump --dbname="myDatabase" --host=localhost --port=5432 --username=postgres  --table='"MyScheme"."TableName 01"' > ~/Dummy.SQL

Upvotes: 10

Related Questions