Re: column order

operationsengineer1@yahoo.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749