From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
---|---|
To: | Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-www(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: [ADMIN] pg_dump : no tables were found. |
Date: | 2012-03-06 10:44:38 |
Message-ID: | CAOBaU_YibH_fnGAUixNEo2NkmD2CjiCAt=Ez3uLSjNXL28U6VQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-in-general pgsql-novice pgsql-sql pgsql-www |
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <lenka(dot)piyush(at)gmail(dot)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\"
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2012-03-06 16:03:16 | I've got gaps in the log files? |
Previous Message | Piyush Lenka | 2012-03-06 06:22:39 | pg_dump : no tables were found. |
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Flower | 2012-03-06 10:45:49 | Re: what Linux to run |
Previous Message | Simon Riggs | 2012-03-06 08:53:56 | Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows |
From | Date | Subject | |
---|---|---|---|
Next Message | Chengjie Qin | 2012-03-20 00:07:53 | Initialize the User-defined Aggregate in ECPG |
Previous Message | Piyush Lenka | 2012-03-06 06:22:39 | pg_dump : no tables were found. |
From | Date | Subject | |
---|---|---|---|
Next Message | VARTAK, SATISH CTR DFAS | 2012-03-06 14:00:46 | Re: postgreSQL odbc driver for Sun Solaris |
Previous Message | Michael Wood | 2012-03-06 10:00:23 | Re: running COPY with remote DB and local file |
From | Date | Subject | |
---|---|---|---|
Next Message | rverghese | 2012-03-06 21:00:32 | map row in one table with random row in another table |
Previous Message | Piyush Lenka | 2012-03-06 06:22:39 | pg_dump : no tables were found. |
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Burladyan | 2012-03-06 20:23:28 | www.postgresql.org/community/lists/ and attachments |
Previous Message | Piyush Lenka | 2012-03-06 06:22:39 | pg_dump : no tables were found. |