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
