the position doesn't really matter in any relational structure.. does it?
On 5/17/06, Emi Lu <emilu@encs.concordia.ca> wrote:
> Hello,
>
> I am trying to insert one column to a specific position in a table.
>
> In mysql, I can do:
> . create table test(id varchar(3), name varchar(12));
> . alter table test add column givename varchar(12) after id;
>
>
> I am looking for similar things in postgresql to add a new column to the
> correct position in a table.
>
> Could someone hint me please.
>
> Thanks alot!
> Ying Lu
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>