[PATCH] Better logging of COPY queries if log_statement='all'

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема [PATCH] Better logging of COPY queries if log_statement='all'
Дата
Msg-id 20161017135753.GA6204@e733.localdomain
обсуждение исходный текст
Ответы Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Hello.

Sometimes it's useful to log content of files used in COPY ... TO ... and
COPY ... FROM ... queries. Unfortunately PostgreSQL doesn't allow to do
it, even if log_statement='all'. Suggested patch fixes this.

Log example:

```
LOG:  statement: create table test (k int, v text);
LOG:  statement: insert into test values (111, 'aaa'), (222, 'bbb');
LOG:  statement: copy test to '/tmp/copy.txt';
LOG:  statement: 111    aaa
LOG:  statement: 222    bbb
LOG:  statement: delete from test;
LOG:  statement: copy test from '/tmp/copy.txt';
LOG:  statement: 111    aaa
LOG:  statement: 222    bbb
```
--
Best regards,
Aleksander Alekseev

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: postgres_fdw super user checks
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [PATCH] Better logging of COPY queries if log_statement='all'