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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general