Re: ALTER Table

Shridhar Daithankar wrote:

> Alex wrote:
>
>> is it possible to add a column to a table at a specific place ?
>> Reading the man pages i could not figure that out.
>
>
> Why do you want to add it at specific location? What does it achieve?

I miss the same feature too, this is my reason:
is just to keep clean your schema, I have in my revision control system
all tables with fields grouped for tipology:

CREATE TABLE a(

   G1  as INTEGER,
   ...
   Gn  as INTEGER,
   H1  as INTEGER,
   ...
   Hm  as INTEGER
);

when I add let me say Gn+1 in my RCS I have:

CREATE TABLE a(

   G1   as INTEGER,
   ...
   Gn   as INTEGER,
   Gn+1 as INTEGER,
   H1   as INTEGER,
   ...
   Hm   as INTEGER
);

and will be nice to have in my fourther dumps
the same structure, just to do a DIFF betwen two schemas
without become crazy!


I hope I was clear enough.


Regards
Gaetano Mendola