Re: Updatable Views - DEFAULT doesn't inherit from table??? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Updatable Views - DEFAULT doesn't inherit from table???
Date
Msg-id 49393A81.3030702@archonet.com
Whole thread Raw
In response to Re: Updatable Views - DEFAULT doesn't inherit from table???  (Csaba Együd <csegyud@gmail.com>)
Responses Re: Updatable Views - DEFAULT doesn't inherit from table???
List pgsql-general
Csaba Együd wrote:
> Thx for your reply. Is there any possible way to generate an sql to
> "copy" these defaults to the view.

Nothing pre-packaged that I know of. You could probably do something
copying values about in pg_attribute and pg_constraint, but that'd be an
"at your own risk" sort of activity I suspect.

For simpler defaults etc. you could probably get what you need from
information_schema.columns

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: in transaction - safest way to kill
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Updatable Views - DEFAULT doesn't inherit from table???