This is great info, is there a way to get the log back via a SQL call?
It would be pretty cool if there was a way to have the log go to a table instead of a file.
Tony Caduto
Michael Fuhr wrote:
ALTER USER johndoe SET log_statement TO TRUE; -- 7.x ALTER USER johndoe SET log_statement TO 'all'; -- 8.0
All new connections that johndoe makes will now have statement logging enabled.
To enable logging for a particular session, execute the appropriate "SET log_statement" statement in that session. If you have permission problems then you could wrap that operation in a function defined as SECURITY DEFINER and create the function as a database superuser.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
