Thanks John, I realized that and confirmed in my logs. What I'm trying to determine now, can I only log some SELECT statements, or I should log all of them or none of them.
Oleg On Thu, Dec 10, 2015 at 1:40 PM, John R Pierce <pie...@hogranch.com> wrote: > On 12/10/2015 9:58 AM, oleg yusim wrote: > >> I'm new to PostgreSQL, working on it from the point of view of Cyber >> Security assessment. In regards to the here is my question: >> >> Is it a way to enable logging for psql prompt meta-commands, such as \du, >> \dp, \z, etc? >> > > what the other two gentlemen are trying to say is the metacommands are > shortcuts for more complex SQL queries of the pg_catalog schema, so to log > them, you would need to log all queries and filter for accesses to the > pg_catalog.... > > > > -- > john r pierce, recycling bits in santa cruz > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
