Re: insert into a view?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Karen Hill <karen_hill22(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insert into a view?
Date: 2006-05-02 00:31:47
Message-ID: 20060502003147.GA82285@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-05-02 00:32:48 Re: insert into a view?
Previous Message Karen Hill 2006-05-02 00:23:22 insert into a view?