Re: retrieve statement from catalogs

Andrew Sullivan <andrew@libertyrms.info>

From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-general@postgresql.org
Date: 2003-10-28T15:18:26Z
Lists: pgsql-general
On Tue, Oct 28, 2003 at 09:03:12AM +0000, Jaime Casanova wrote:
> 
> Hi everybody, can anyone tell me if there's a way to retrieve the select 
> instruction executed from the catalogs, or maybe via some structure in a 
> trigger?

You could turn on query logging and read the Postgres logs.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110