From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump and quoted identifiers |
Date: | 2016-12-15 20:37:31 |
Message-ID: | B6F6FD62F2624C4C9916AC0175D56D88593075C2@jenmbs01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
________________________________________
Von: pgsql-general-owner(at)postgresql(dot)org [pgsql-general-owner(at)postgresql(dot)org]" im Auftrag von "Thomas Kellerer [spam_eater(at)gmx(dot)net]
Gesendet: Donnerstag, 15. Dezember 2016 17:15
An: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-12-15 21:00:04 | Re: Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install |
Previous Message | Richard Brosnahan | 2016-12-15 19:51:59 | Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install |