Re: Location of a new column

On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote:
>
> On Thu, 8 Apr 2004, Terry Hampton wrote:
>
> >     I thought this was answered before, but I
> >     could not find anything in my saved email.
> >
> >     I need to ALTER a table to add a new column.
> >     I want the new column to be between two existing
> >     columns,  however.     Didn't I see mention of
> >     an "AFTER" parameter that specified the location
> >     in the table where the new column should be
> >     placed ?    Maybe not ..........     How then,
> >     can I specify the location within the table,   of
> >     new column ?
>
> AFAIK, you can't using add column. It currently does no more than the
> SQL92/99 spec requires in that respect (which is put the column at the
> end).
>
> About all you can do to put it somewhere else is a sequence with a new
> table, copying data and renaming (and fixing constraints).
>

IIRC this option is available in 7.5. At least I seem to remember some
(Chris K-L) posting a patch and it getting committed. You could check
the developers docs to verify I suppose.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL