pg_dump and quoted identifiers

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump and quoted identifiers
Date: 2016-12-13 16:38:15
Message-ID: o2p85i$vct$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Inspired by this question:

http://dba.stackexchange.com/q/158044/1822

I tried that for myself, and it seems that pg_dump indeed can not parse quoted identifiers:

psql (9.6.1)
Type "help" for help.

postgres=# create table "Statuses" (id integer);
CREATE TABLE
postgres=# \q

-bash-4.1$ pg_dump -d postgres -t "Statuses"
pg_dump: no matching tables were found

-bash-4.1$ pg_dump -d postgres -t '"Statuses"'
pg_dump: no matching tables were found

-bash-4.1$ pg_dump -d postgres -t 'public."Statuses"'
pg_dump: no matching tables were found

Running 9.6.1 on CentOS 6 but under Windows this is the same.

Any ideas?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2016-12-13 16:40:43 Re: is this a known bug in 9.6?
Previous Message Marc Mamin 2016-12-13 16:22:37 Re: is this a known bug in 9.6?