Re: need suggestion - Mailing list pgsql-general

From Albe Laurenz
Subject Re: need suggestion
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208902024@exadv11.host.magwien.gv.at
Whole thread Raw
In response to need suggestion  (kostika gorica <kosti_31@hotmail.com>)
Responses Re: need suggestion  (kostika gorica <kosti_31@hotmail.com>)
List pgsql-general
kostika gorica wrote:
> I have an application already running, accessing the database
(postgresql
> 8.1). I need a solution, that prints (on a file, or somehow) the
queries
> being executed every time the app accesses the database.
> Is there any ON DATABASE ACCESS trigger ?!
> Any idea how that can be done?

If you set log_statement='all', all statements will be logged.
You could use the log file.

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: kostika gorica
Date:
Subject: need suggestion
Next
From: kostika gorica
Date:
Subject: Re: need suggestion