Thread: Insert into VIEW ???

Insert into VIEW ???

From

Jacek Zagorski

Date:

02 March 2001, 12:01:01

Is it possible to INSERT into xyz
where xyz is a view ?
What is the proper syntax ?

Thanks Much
Jacek Zagorski
Shasta NetWorks LLC
jaz@shastanetworks.com

Re: Insert into VIEW ???

From

Richard Huxton

Date:

03 March 2001, 13:34:13

Jacek Zagorski wrote:
> 
> Is it possible to INSERT into xyz
> where xyz is a view ?
> What is the proper syntax ?
> 
> Thanks Much
> Jacek Zagorski

You'll need to set up the rules for updating - PG can't figure out what
you want automatically. There's a page on this in the programmer's guide.

- Richard Huxton