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

List:       postgresql-sql
Subject:    Re: [SQL] [ADMIN] pg_dump : no tables were found.
From:       Julien Rouhaud <rjuju123 () gmail ! com>
Date:       2012-03-06 10:44:38
Message-ID: CAOBaU_YibH_fnGAUixNEo2NkmD2CjiCAt=Ez3uLSjNXL28U6VQ () mail ! gmail ! com
[Download RAW message or body]

On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <lenka.piyush@gmail.com> 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\"

[Attachment #3 (text/html)]

<div class="gmail_quote">On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <span \
dir="ltr">&lt;<a href="mailto:lenka.piyush@gmail.com">lenka.piyush@gmail.com</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> <div>Hi,</div><div><br></div><div>I m trying to take \
backup of data of a particular table using pg_dump.</div><div>I used double quotes \
for table name but output is : </div><div>pg_dump : no tables were \
found.</div><div><br>

</div><div>Command used : </div>-h localhost -p 5432 -U postgres -W -F p -a -t \
&#39;&quot;TestTable&quot;&#39; -f DbBackup/BackupTableActions.sql \
TestDataBase<div><br></div><div>This problem only shows when there is a upper case \
character in my table name.</div>

<div>Please Help</div><div><br></div><div>Thanks &amp; Regards \
</div><div>Piyush</div> </blockquote></div><br>Hi<br>You can try -t \
&#39;&quot;TestTable&quot;&#39; or -t \&quot;TestTable\&quot;<br>



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