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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data
Дата
Msg-id 20180703015036.GG2159@paquier.xyz
обсуждение исходный текст
Ответ на Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data  (Carter Thaxton <carter.thaxton@gmail.com>)
Ответы Re: Add --include-table-data-where option to pg_dump, to export onlya subset of table data  (Carter Thaxton <carter.thaxton@gmail.com>)
Список pgsql-hackers
On Mon, Jul 02, 2018 at 03:11:46PM -0700, Carter Thaxton wrote:
> Also, there may be some misunderstanding about "foo:bar" above.  That's an
> example of using a namespaced table, where "bar" is a table in the
> namespace "foo".  Normally, assuming your table is named "bar" in the
> default namespace, you would just say something like:
>
>   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 :)
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Old small commitfest items
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Protect syscache from bloating with negative cache entries