Re: pg_dump : no tables were found.

[Julien Rouhaud <rjuju123@xxxxxxxxx>]

On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <lenka.piyush@xxxxxxxxx> wrote:

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

Hi
You can try -t '"TestTable"' or -t \"TestTable\"