Re: [GENERAL] pg_dump and quoted identifiers - Mailing list pgsql-general

From Marc Mamin
Subject Re: [GENERAL] pg_dump and quoted identifiers
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D88593075C2@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Re: [GENERAL] pg_dump and quoted identifiers  (Thomas Kellerer <spam_eater@gmx.net>)
List 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 by date:

Previous
From: Richard Brosnahan
Date:
Subject: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install