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