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

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: [ADMIN] pg_dump : no tables were found.
Дата
Msg-id CAOBaU_YibH_fnGAUixNEo2NkmD2CjiCAt=Ez3uLSjNXL28U6VQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump : no tables were found.  (Piyush Lenka <lenka.piyush@gmail.com>)
Список pgsql-novice
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <lenka.piyush@gmail.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\"

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Wood
Дата:
Сообщение: Re: running COPY with remote DB and local file
Следующее
От: "VARTAK, SATISH CTR DFAS"
Дата:
Сообщение: Re: postgreSQL odbc driver for Sun Solaris