Postgres Pro
Downloads
Home   >   mailing lists

Re: view with insert rule - Mailing list pgsql-general

From Tom Lane
Subject Re: view with insert rule
Date
Msg-id 15391.1356899198@sss.pgh.pa.us
Whole thread Raw
In response to view with insert rule  (Philipp Kraus <philipp.kraus@flashpixx.de>)
List pgsql-general
Tree view 
Philipp Kraus <philipp.kraus@flashpixx.de> writes:
> Can I create a view, that can be used like a table, so on insert statements the default values are set?

Sure.  Just use ALTER VIEW SET DEFAULT to attach default values to the
columns of the view.

            regards, tom lane

pgsql-general by date:

Previous
From: Philipp Kraus
Date:
Subject: view with insert rule
Next
From: Christian Hammers
Date:
Subject: Re: rights for schema