Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data

Поиск
Список
Период
Сортировка
От Carter Thaxton
Тема Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data
Дата
Msg-id CAGiT_HNKeWDK9YFUMS1vct5XSchM+kK=Fa+bJ8c8WTpeFpJFDg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения
 
>   pg_dump --where "bar:created_at >= 2018-05-01'"

I am wondering how this works at parsing if the table name, or one of
the columns includes a colon character :)

The proposed patch will handle quoted identifiers.  E.g. the following will work just fine:

  pg_dump --where 'table:"column:with:colons" = 5'

Note the use of single quotes in the shell, and then double quotes in the WHERE clause.  There are also many other options for quoting in the shell, of course.


 
> Please don't top-post on the PostgreSQL lists. See <http://idallen.com/topposting.html>

Sorry.  Thanks for the reminder.

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Copy function for logical replication slots
Следующее
От: Amit Langote
Дата:
Сообщение: Re: pgsql: Clarify use of temporary tables within partition trees