From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: full featured alter table? |
Date: | 2003-06-16 05:45:57 |
Message-ID: | 20030616054557.GZ40542@flake.decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Jun 14, 2003 at 10:59:08AM -0500, Bruno Wolff III wrote:
> On Sat, Jun 14, 2003 at 10:31:02 -0500,
> "Jim C. Nasby" <jim(at)nasby(dot)net> wrote:
> >
> > The one thing we don't have that I think would be useful is a way to
> > re-order the columns in a table. Maybe it's just me, but I tend to want
> > column to appear in a specific order, and the only way you can
> > accomplish this today is by re-creating the entire table.
>
> You can specify the order that columns are output now. The real underlying
> order should really be up to postgres to decide based on what is most
> efficient.
Actually, I was talking about the underlying order, because (at least
the last time I asked about this), pgsql doesn't do any intelligent
ordering under the covers. Because of that, I'd like to be able to order
based on the optimal ordering I was given (fixed width before variable,
then not null before null).
Of course it would certainly be best if pgsql would automagically
optimize internal storage order for me.
--
Jim C. Nasby (aka Decibel!) jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2003-06-16 05:55:39 | Re: RE : full featured alter table? |
Previous Message | Christopher Kings-Lynne | 2003-06-16 05:18:36 | Re: [GENERAL] MySQL gets $19.5 MM |