Re: Add Column BEFORE/AFTER another column - Mailing list pgsql-general

From Matthew
Subject Re: Add Column BEFORE/AFTER another column
Date
Msg-id 46CF4B1A.8020000@voilaip.com
Whole thread Raw
In response to Re: Add Column BEFORE/AFTER another column  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Add Column BEFORE/AFTER another column  (Steve Atkins <steve@blighty.com>)
Re: Add Column BEFORE/AFTER another column  (Robert Treat <xzilla@users.sourceforge.net>)
Re: Add Column BEFORE/AFTER another column  (Erik Jones <erik@myemma.com>)
List pgsql-general
Hey Bill,

> It does not.

    Bummer.

> To get your columns in a specific order, specify the column names in
> that order in your SELECT statement.  The SQL standard doesn't provide
> for any other way to guarantee column order, and neither does Postgres.

    Yes, I realize this and we do identify our columns during select
statements, but when you look at a table using a tool like phpPGAdmin or
pgAdmin3, the columns are displayed in some defined order.  It's much
easier to see your data/columns in some logical order (ie: all the cost
columns next to each other).

Thanks,
Matthew

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Add Column BEFORE/AFTER another column
Next
From: Steve Atkins
Date:
Subject: Re: Add Column BEFORE/AFTER another column