Re: Automatic insertion on insertion on another table

On Thu, Oct 24, 2002 at 05:36:52PM -0400, Owen Jacobson wrote:

> I assume the correct way to do this is through a trigger on the user table
> (AFTER INSERT) but have no experience whatsoever writing triggers.  I'm not
> necessarily asking for someone to write it for me, although that would be
> most kind, but some resources on how to write it myself would be just as
> good.

That's probably what you want (a rule might also work in this case).
The place to start is

<http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/triggers.html>

A

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