Postgres Pro
Downloads
Home   >   mailing lists

Re: How to make an INSERT INTO to a view? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: How to make an INSERT INTO to a view?
Date
Msg-id 20090730195713.GA21457@a-kretschmer.de
Whole thread Raw
In response to How to make an INSERT INTO to a view?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
In response to Andre Lopes :
> Hi,
>  
> I'am new to PostGre... I need to insert to a view. For security measures the
> users will be only able to insert to views.
>  
> How can I do that? INSERT INTO a view in PostGreSQL

You have to create a rule.

http://www.postgresql.org/docs/8.3/static/rules-update.html


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: How to make an INSERT INTO to a view?
Next
From: Jeff Davis
Date:
Subject: Re: How to make an INSERT INTO to a view?