Hello,
I am using ALTER VIEW x ALTER COLUMN y SET DEFAULT defaultclause, but the
defaults do not seem to appear in the pgadmin generated SQL for the view. Is
this a deliberate omission? psql does display view column defaults:
test=# CREATE VIEW test.trash AS SELECT 1 AS a;
CREATE VIEW
test=# ALTER VIEW test.trash ALTER COLUMN a SET DEFAULT 5;
ALTER VIEW
test=# \d+ test.trash
View "test.trash"
Column | Type | Modifiers | Storage | Description
--------+---------+-----------+---------+-------------
a | integer | default 5 | plain |
View definition:
SELECT 1 AS a;
Cheers,
M
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
