Re: [GENERAL] pg_dump and quoted identifiers

Thomas Kellerer <spam_eater@gmx.net> writes:
>     postgres=# create table "Statuses" (id integer);
>     CREATE TABLE

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

This is expected since those quotes are eaten by the shell.

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

These cases work for me.  Maybe your shell is doing something weird
with the quotes?

            regards, tom lane