Re: [GENERAL] pg_dump and quoted identifiers

Поиск
Список
Период
Сортировка
От Marc Mamin
Тема Re: [GENERAL] pg_dump and quoted identifiers
Дата
Msg-id B6F6FD62F2624C4C9916AC0175D56D88593075C2@jenmbs01.ad.intershop.net
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_dump and quoted identifiers  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
________________________________________
Von: pgsql-general-owner@postgresql.org [pgsql-general-owner@postgresql.org]" im Auftrag von "Thomas Kellerer
[spam_eater@gmx.net]
Gesendet: Donnerstag, 15. Dezember 2016 17:15
An: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] pg_dump and quoted identifiers

Tom Lane schrieb am 15.12.2016 um 16:20:
>> Still doesn't work:
>>   -bash-4.1$ pg_dump -d postgres -t "\"Statuses\""
>>   pg_dump: no matching tables were found
>
> Hmm.  It might shed some light if you put "echo" in front of that
> to see what gets printed:
>
> $ echo pg_dump -d postgres -t "\"Statuses\""
> pg_dump -d postgres -t "Statuses"

Hello,

Have you checked if the problem is limited to pg_dump ?
Maybe you're facing a trivial mistake, like a space in the table name at creation time or a wrong database...
psql -d postgres -c "select * from \"Statuses\" "

regards,
Marc Mamin

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

Предыдущее
От: Richard Brosnahan
Дата:
Сообщение: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install