Re: [ADMIN] pg_dump : no tables were found.

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\"

In response to

Browse pgsql-admin by date

  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.

Browse pgsql-general by date

  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

Browse pgsql-in-general by date

  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.

Browse pgsql-novice by date

  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

Browse pgsql-sql by date

  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.

Browse pgsql-www by date

  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.