Thread: Logging for psql only

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

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