Skip site navigation (1) Skip section navigation (2)

Re: View column defaults in pgAdminIII

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: btober(at)seaworthysys(dot)com, pgadmin-support(at)postgresql(dot)org
Subject: Re: View column defaults in pgAdminIII
Date: 2003-10-13 16:13:51
Message-ID: 3F8ACF3F.8070202@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Dave Page wrote:

>Hi, 
>
>  
>
>>-----Original Message-----
>>From: btober(at)seaworthysys(dot)com [mailto:btober(at)seaworthysys(dot)com] 
>>Sent: 13 October 2003 14:13
>>To: pgadmin-support(at)postgresql(dot)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



In response to

Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-10-13 16:26:42
Subject: Re: pgAdminIII bug
Previous:From: Christopher Kings-LynneDate: 2003-10-13 15:29:46
Subject: Re: View column defaults in pgAdminIII

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group