From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com>, "'Van Ingen, Lane'" <lvaningen(at)ESNCC(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: column order |
Date: | 2005-02-15 17:22:34 |
Message-ID: | E1D16PU-00045x-4z@lerami.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
operationsengineer1(at)yahoo(dot)com wrote:
> does the column order within a table matter? i had to delete a
> column when making a foreign key b/c int4[] didn't allow the
> reference. i deleted int4[] and recreated the table with int4 and
> everything was fine - except my column order within my table was
> different. does this make a difference beyond losing some visual and
> organizational appeal?
>
> can pgadmin3 rearrange the order of the columns?
>
> tia...
>
It shouldn't matter. The only place it might matter is if you are doing a
select * from table
And the code that is reading the results cares about the column order.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Blavos | 2005-02-16 00:44:06 | Failure to Start Postmaster/postgres |
Previous Message | operationsengineer1 | 2005-02-15 17:16:41 | column order |