Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-in-generalpgsql-novicepgsql-sqlpgsql-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

pgsql-novice by date

Next:From: VARTAK, SATISH CTR DFASDate: 2012-03-06 14:00:46
Subject: Re: postgreSQL odbc driver for Sun Solaris
Previous:From: Michael WoodDate: 2012-03-06 10:00:23
Subject: Re: running COPY with remote DB and local file

pgsql-www by date

Next:From: Sergey BurladyanDate: 2012-03-06 20:23:28
Subject: www.postgresql.org/community/lists/ and attachments
Previous:From: Piyush LenkaDate: 2012-03-06 06:22:39
Subject: pg_dump : no tables were found.

pgsql-admin by date

Next:From: AndreasDate: 2012-03-06 16:03:16
Subject: I've got gaps in the log files?
Previous:From: Piyush LenkaDate: 2012-03-06 06:22:39
Subject: pg_dump : no tables were found.

pgsql-general by date

Next:From: Gavin FlowerDate: 2012-03-06 10:45:49
Subject: Re: what Linux to run
Previous:From: Simon RiggsDate: 2012-03-06 08:53:56
Subject: Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows

pgsql-in-general by date

Next:From: Chengjie QinDate: 2012-03-20 00:07:53
Subject: Initialize the User-defined Aggregate in ECPG
Previous:From: Piyush LenkaDate: 2012-03-06 06:22:39
Subject: pg_dump : no tables were found.

pgsql-sql by date

Next:From: rvergheseDate: 2012-03-06 21:00:32
Subject: map row in one table with random row in another table
Previous:From: Piyush LenkaDate: 2012-03-06 06:22:39
Subject: pg_dump : no tables were found.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group