view column defaults not displayed - Mailing list pgadmin-support

From A.M.
Subject view column defaults not displayed
Date
Msg-id 8C97310B-1FBA-48B4-BC4C-CEB06B4700CF@themactionfaction.com
Whole thread Raw
Responses Re: view column defaults not displayed  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Hello,

I am using ALTER VIEW x ALTER COLUMN  y SET DEFAULT defaultclause, but the defaults do not seem to appear in the
pgadmingenerated 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

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: large objects permission issue
Next
From: Guillaume Lelarge
Date:
Subject: Re: view column defaults not displayed