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

pg_dump : no tables were found.

From: Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com>
To: 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: pg_dump : no tables were found.
Date: 2012-03-06 06:22:39
Message-ID: CAFOD=KDDo4GWB43JvJ4S+ht_V0oGr0gQNRg6=X_FmyDRrZ1q0Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-in-generalpgsql-novicepgsql-sqlpgsql-www
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

Responses

pgsql-novice by date

Next:From: Michael WoodDate: 2012-03-06 08:14:30
Subject: Re: Slow duplicate deletes
Previous:From: VARTAK, SATISH CTR DFASDate: 2012-03-05 21:12:44
Subject: postgreSQL odbc driver for Sun Solaris

pgsql-www by date

Next:From: Julien RouhaudDate: 2012-03-06 10:44:38
Subject: Re: [ADMIN] pg_dump : no tables were found.
Previous:From: Thom BrownDate: 2012-02-24 14:17:55
Subject: Re: PostgreSQL website redesign

pgsql-admin by date

Next:From: Julien RouhaudDate: 2012-03-06 10:44:38
Subject: Re: [ADMIN] pg_dump : no tables were found.
Previous:From: Rural HunterDate: 2012-03-05 16:50:00
Subject: Re: Safe to put indexes in tablespaces on raid0 disk?

pgsql-general by date

Next:From: Simon RiggsDate: 2012-03-06 08:53:56
Subject: Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Previous:From: Toby CorkindaleDate: 2012-03-06 04:52:29
Subject: ANALYSE on top-level of partitioned tables - required?

pgsql-in-general by date

Next:From: Julien RouhaudDate: 2012-03-06 10:44:38
Subject: Re: [ADMIN] pg_dump : no tables were found.
Previous:From: deepa jainDate: 2011-05-24 07:01:52
Subject: Urgently Revert... !!!!

pgsql-sql by date

Next:From: Julien RouhaudDate: 2012-03-06 10:44:38
Subject: Re: [ADMIN] pg_dump : no tables were found.
Previous:From: Peter FaulksDate: 2012-03-04 11:29:23
Subject: Re: date arithmetic with columns

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