[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    [SQL] pg_dump : no tables were found.
From:       Piyush Lenka <lenka.piyush () gmail ! com>
Date:       2012-03-06 6:34:39
Message-ID: CAFOD=KDDo4GWB43JvJ4S+ht_V0oGr0gQNRg6=X_FmyDRrZ1q0Q () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div>Hi,</div><div><br></div><div>I m trying to take backup of data of a pa=
rticular table using pg_dump.</div><div>I used double quotes for table name=
 but output is :=A0</div><div>pg_dump : no tables were found.</div><div><br=
>
</div><div>Command used :=A0</div>-h localhost -p 5432 -U postgres -W -F p =
-a -t &#39;&quot;TestTable&quot;&#39; -f DbBackup/BackupTableActions.sql Te=
stDataBase<div><br></div><div>This problem only shows when there is a upper=
 case=A0character=A0in my table name.</div>
<div>Please Help</div><div><br></div><div>Thanks &amp; Regards=A0</div><div=
>Piyush</div>


[prev in list] [next in list] [prev in thread] [next in thread]