[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

pg_dump : no tables were found.

Subject: pg_dump : no tables were found.
From: Piyush Lenka <lenka.piyush@xxxxxxxxx>
Date: Tue, 6 Mar 2012 11:52:39 +0530
Authentication-results: mr.google.com; spf=pass (google.com: domain of lenka.piyush@xxxxxxxxx designates 10.180.100.33 as permitted sender) smtp.mail=lenka.piyush@xxxxxxxxx; dkim=pass header.i=lenka.piyush@xxxxxxxxx
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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

Follow-Ups:
- Re: pg_dump : no tables were found.
  - From: Julien Rouhaud

Prev by Date: Re: Restoring selected records from backup file
Next by Date: Re: pg_dump : no tables were found.
Previous by thread: Safe to put indexes in tablespaces on raid0 disk?
Next by thread: Re: pg_dump : no tables were found.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]