what to log in csvlogs

On 5/10/20 11:27 AM, Mary Johnson wrote:

Hi,

Can you please let me know if we can control what to log when log
destination is 'csvlog'?

No, it is set to the fields described here:

https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG

What is in those fields is determined by the settings mentioned in the
link above.

Also, can we control when to log to display only select queries of a few
specific tables?

Not with the built in logger.
Other folks maybe able to point you at third party software that can do
this.

Thanks,
mary

--
Adrian Klaver
adrian.klaver@aklaver.com

Fra: Mary Johnson <mary.johnson1812@gmail.com>
Sendt: 10. maj 2020 20:27
Til: pgsql-general@postgresql.org
Emne: what to log in csvlogs

Hi,

Can you please let me know if we can control what to log when log destination is 'csvlog'?
Also, can we control when to log to display only select queries of a few specific tables?

Thanks,
Mary

The Pgaudit extension will let you audit specific actions to specific tables.

Regard Niels Jespersen