Hi All,
Where can i find more information on "user actions", i.e. say a user logins in and does some querying via sql and then uses perl/c/c++ language to do some more querying. So how does postgresql keep track of "user actions" in a sequential order?
PostgreSQL doesn't really distinguish between querying from psql and via Perl/C/etc. It's all just SQL coming in from the client.
You can control what information is logged with the various settings in postgresql.conf
http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)