Re: View column defaults in pgAdminIII

Dave Page wrote:

>Hi, 
>
>  
>
>>-----Original Message-----
>>From: btober@seaworthysys.com [mailto:btober@seaworthysys.com] 
>>Sent: 13 October 2003 14:13
>>To: pgadmin-support@postgresql.org
>>Subject: [pgadmin-support] View column defaults in pgAdminIII
>>
>>I recently installed pgAdmin III and am happy to see the 
>>great work done by the team.
>>
>>Thank you very much for so great a software tool!
>>    
>>
>
>You're welcome, glad you like it!
>
>  
>
>>a) I'd really like the view DDL to include the CRLF's that I 
>>had put for formatting convenience in the original view 
>>creation statement, rather than have the pgAdminIII just 
>>insert them at pre-defined, generically appropriate places 
>>(which looks like before each major key word of a SELECT 
>>statement). When I want to review or modify a view 
>>definition, I often end up having to navigate with the 
>>right-arrow key through the view and inserting a CRLF before 
>>each view column, for instance.
>>    
>>
>
>Unfortunately this is not possible because PostgreSQL doesn't retain the
>original SQL entered (see the many discussions about this on the
>pgsql-hackers list for details). 
>  
>
Yes, and I had quite some fights to get this pretty-print functions into 
the backend for guys like us that don't like dozens of parentheses and a 
view definition of 10k on a single line.

>>b) Include in the view definition DDL any column defaults. 
>>When I do a pg_dump -t myview... at the server console, the 
>>output includes not only the view DDL, rules, and 
>>permissions, but also column defaults. Would be nice for the 
>>sake of completeness to see the column defaults in the 
>>pgAdminIII DDL also.
>>    
>>
>
>I'm not sure what you mean here. Views don't have column defaults, only
>the underlying relations do. How would you expect that to be expressed
>in SQL (which pg_dump didn't do when I tried it btw)?
>  
>

View columns are a bit... neglected at the moment. I took this on the 
TODO list.

Regards,
Andreas