From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | decibel <decibel(at)decibel(dot)org> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pretty print viewdefs |
Date: | 2009-08-26 18:47:32 |
Message-ID: | 4A958344.4060108@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-08-26 19:14:27 | Re: 8.5 release timetable, again |
Previous Message | Tom Lane | 2009-08-26 18:46:43 | Re: 8.5 release timetable, again |