Re: view with insert rule

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: view with insert rule
Date: 2012-12-30 20:26:38
Message-ID: 15391.1356899198@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Hammers 2012-12-31 00:06:42 Re: rights for schema
Previous Message Philipp Kraus 2012-12-30 20:20:08 view with insert rule