Getting an SQL statement inside a trigger.

From: Omar Carvajal <omar(at)carvajal(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting an SQL statement inside a trigger.
Date: 2001-08-31 18:14:27
Message-ID: 01083114142700.07085@power9.carvajal.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,
I was wondering how I can get the SQL statement that made a trigger fire.
For example: insert into customers values(1, 'joe') fires get_customer() and
that function has a variable with the value "insert into customers values(1,
'joe') ". How can I do this?

Thanks in advance,
Omar

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-31 18:17:07 Re: PostgreSQL On the Mac? OS9 or OSX?
Previous Message Mikheev, Vadim 2001-08-31 18:00:38 Re: Getting data out of database with a bad WAL file