Re: pg_dump and quoted identifiers

2016-12-13 17:38 GMT+01:00 Thomas Kellerer <spam_eater(at)gmx(dot)net>:

> 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?
>

pg_dump -t '"Statuses"' postgres

Regards

Pavel

>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>