Postgres Pro
Downloads
Home   >   mailing lists

Executing SQL commands via triggers without the use of procedures - Mailing list pgsql-sql

From Susan Hoddinott
Subject Executing SQL commands via triggers without the use of procedures
Date
Msg-id 001501c2def2$fe2fe9c0$1f84fea9@oemcomputer
Whole thread Raw
Responses Re: Executing SQL commands via triggers without the use of  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Executing SQL commands via triggers without the use of procedures  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: Executing SQL commands via triggers without the use of procedures  (Oleg Samoylov <olleg@telecom.mipt.ru>)
List pgsql-sql
Tree view
Hello,
 
Having scoured the relevant documentation I cannot find anything which indicates how I simply create a database trigger to insert into a second table after insert on a first table, without the use of a procedure.  As I do not want return values etc. this seems like overkill.  Is it possible to create a trigger which executes SQL directly without the need to create a procedure?  If so, what is the syntax?
 
Regards
Attachment

pgsql-sql by date:

Previous
From: Aaron Chu
Date:
Subject: Beginner needs help
Next
From: Aaron Chu
Date:
Subject: Beginner needs help