Re: Logging for psql only - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Logging for psql only
Date
Msg-id 200303060310.h263Adx04272@candle.pha.pa.us
Whole thread Raw
In response to Re: Logging for psql only  (Oleg Samoylov <olleg@telecom.mipt.ru>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: P G
Date:
Subject: Where are the current install instructions?
Next
From: Bruce Momjian
Date:
Subject: Re: uppercase = lowercase