Home > mailing lists

pg_dump : no tables were found. - Mailing list pgsql-admin

From	Piyush Lenka
Subject	pg_dump : no tables were found.
Date	March 6, 2012 04:20:45
Msg-id	CAFOD=KDDo4GWB43JvJ4S+ht_V0oGr0gQNRg6=X_FmyDRrZ1q0Q@mail.gmail.com Whole thread Raw
Responses	Re: pg_dump : no tables were found.
List	pgsql-admin

Hi,

I m trying to take backup of data of a particular table using pg_dump.

I used double quotes for table name but output is :

pg_dump : no tables were found.

Command used :

-h localhost -p 5432 -U postgres -W -F p -a -t '"TestTable"' -f DbBackup/BackupTableActions.sql TestDataBase

This problem only shows when there is a upper case character in my table name.

Please Help

Thanks & Regards

Piyush

From: davidh
Date: 06 March 2012, 04:20:17
Subject: Re: Restoring selected records from backup file

From: Julien Rouhaud
Date: 06 March 2012, 06:44:54
Subject: Re: pg_dump : no tables were found.