Re: Loggingt psql meta-commands - Mailing list pgsql-general

From John R Pierce
Subject Re: Loggingt psql meta-commands
Date
Msg-id 5669D533.10607@hogranch.com
Whole thread Raw
In response to Loggingt psql meta-commands  (oleg yusim <olegyusim@gmail.com>)
Responses Re: Loggingt psql meta-commands  (oleg yusim <olegyusim@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Loggingt psql meta-commands
Next
From: oleg yusim
Date:
Subject: Re: Loggingt psql meta-commands