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?
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
Disclosure: I work for EnterpriseDB (EDB)