2016-12-13 17:38 GMT+01:00 Thomas Kellerer <spam_ea...@gmx.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
