[GENERAL] pg_dump and quoted identifiers

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема [GENERAL] pg_dump and quoted identifiers
Дата
Msg-id o2p85i$vct$1@blaine.gmane.org
обсуждение исходный текст
Ответы Re: [GENERAL] pg_dump and quoted identifiers
Re: [GENERAL] pg_dump and quoted identifiers
Список 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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Marc Mamin
Дата:
Сообщение: Re: [GENERAL] is this a known bug in 9.6?
Следующее
От: Torsten Förtsch
Дата:
Сообщение: Re: [GENERAL] is this a known bug in 9.6?