Re: Insert into VIEW ??? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Insert into VIEW ???
Date
Msg-id 3AA10A15.2AEA6C6B@archonet.com
Whole thread Raw
In response to Insert into VIEW ???  (Jacek Zagorski <jaz@shastanetworks.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "pgsql-sql"
Date:
Subject: Re: lo_import for storing Blobs
Next
From: Richard Huxton
Date:
Subject: Re: Temp Tables & Connection Pooling