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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-in-general pgsql-novice pgsql-sql pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-general by date

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

Browse pgsql-in-general by date

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

Browse pgsql-novice by date

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

Browse pgsql-sql by date

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

Browse pgsql-www by date

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