Re: BUG #4547: sort columns in \d

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "Ferdinand Gassauer" <gassauer(at)kde(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4547: sort columns in \d
Date: 2008-11-23 19:11:44
Message-ID: 26502.1227467504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> On Sun, Nov 23, 2008 at 12:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> this patch fixes this and makes the output of \d much more usable.
>>
>> Calling this a "bug" isn't a good way to start a discussion about it.

> specially because this *fix* will lead to confusions about the order
> of columns in INSERT statements,

And "SELECT *" statements. I don't necessarily object to having some
way to list the columns alphabetically, but it shouldn't be the only
way, and probably not even the default.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Shaun Crampton 2008-11-23 20:25:54 pg_dumpall restore fails
Previous Message Ferdinand Gassauer 2008-11-23 19:10:35 Re: BUG #4547: sort columns in \d