Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group