Re: Insert into VIEW ???

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jacek Zagorski <jaz(at)shastanetworks(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Insert into VIEW ???
Date: 2001-03-03 15:13:25
Message-ID: 3AA10A15.2AEA6C6B@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-03-03 15:32:07 Re: Temp Tables & Connection Pooling
Previous Message pgsql-sql 2001-03-03 09:33:41 Re: lo_import for storing Blobs