Re: pg_dump multi VALUES INSERT

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_dump multi VALUES INSERT
Дата
Msg-id 20190304032522.GI1999@paquier.xyz
обсуждение исходный текст
Ответ на Re: pg_dump multi VALUES INSERT  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
On Sat, Mar 02, 2019 at 08:01:50AM +0100, Fabien COELHO wrote:
> About the output: I'd suggest to indent one line per row, something like:
>
>   INSERT INTO foo VALUES
>     (..., ..., ..., ...),
>     (..., ..., ..., ...),
>     (..., ..., ..., ...);
>
> so as to avoid very very very very very very very very very very very very
> very very very very long lines in the output.

Note: folks sometimes manually edit the dump file generated.  So
having one row/SQL query/VALUE per line really brings a lot of value.
--
Michael

Вложения

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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] WAL logging problem in 9.4.3?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath