If you want to log everything via psql, you can use "SET log_statement
TO on" inside .psqlrc and that will show all psql commands in the server
logs, or you can use per-user settings using ALTER USER, all in 7.3.
---------------------------------------------------------------------------
Oleg Samoylov wrote:
> Al Sutton wrote:
> > Does anyone have a solution to the following situation;
> >
> > I have an application which uses postgresql as its database, I also have te=
> > chnicians who need to made occasional data changes using psql, is there any=
> > way to log the changes made by the technicians without logging the SQL sta=
> > tements from the application?
> >
> > Al.
>
> At http://gborg.postgresql.org you can find one or two data change
> logging function working per user.
>
> --
> Olleg Samoylov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073