Re: pg_dump and quoted identifiers

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]&quot; im Auftrag von &quot;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

In response to

Browse pgsql-general by date

  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