"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > 2008/7/22 Rajesh Kumar Mallah <mallah.rajesh@xxxxxxxxx>: >> any hit on performance is not desired. >> is it possible to alter logging behaviour just for the >> psql session ? > Set log_statement='ddl' in your postgresql.conf and pgsql will log all > ddl that hits the database. It won't log other stuff, just the ddl. I think the OP didn't want *all* sessions doing this but just selected sessions; so ALTER USER ... SET log_statement, or possibly ALTER DATABASE ... SET, would perhaps serve better. regards, tom lane
