Re: pretty print viewdefs

decibel wrote:
> On Aug 26, 2009, at 9:02 AM, Andrew Dunstan wrote:
>> The tiny patch attached fixes a long-standing peeve of mine (and at 
>> least one of my clients'), namely that the target list printed in 
>> viewdefs are unreadable.
>>
>> example output now looks like this:
>>
>>    regression=# select pg_get_viewdef('shoe',true);
>>                    pg_get_viewdef                   
>> -----------------------------------------------
>>      SELECT
>>         sh.shoename,
>>         sh.sh_avail,
>
>
> Did we kill the idea of trying to retain the original view definition? 
> Granted, that doesn't really help for SELECT *...
>

That has nothing at all to do with the issue. The question is not about 
whether to keep the original, it's about how to format the reconstructed 
query.

cheers

andrew