Postgres Pro
Downloads
Home   >   mailing lists

Re: insert into a view? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: insert into a view?
Date
Msg-id 20060502003147.GA82285@winnie.fuhr.org
Whole thread Raw
In response to insert into a view?  ("Karen Hill" <karen_hill22@yahoo.com>)
List pgsql-general
Tree view 
On Mon, May 01, 2006 at 05:23:22PM -0700, Karen Hill wrote:
> Tried it but didn't work.  It gave me a hint though to try triggers.
> Can anyone show me how to do an insert into a view using triggers?

Rules are probably what you're after; the documentation has examples.

http://www.postgresql.org/docs/8.1/interactive/rules.html
http://www.postgresql.org/docs/8.1/interactive/rules-update.html#RULES-UPDATE-VIEWS

--
Michael Fuhr

pgsql-general by date:

Previous
From: "Karen Hill"
Date:
Subject: insert into a view?
Next
From: Tom Lane
Date:
Subject: Re: insert into a view?