Обсуждение: Insert into VIEW ???

Поиск
Список
Период
Сортировка

Insert into VIEW ???

От
Jacek Zagorski
Дата:
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 ???

От
Richard Huxton
Дата:
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