Re: changing field length

Ok. so for now I want to return to where I started. so I renamed the
table and regenerated my original table with the fields in the order
that I like. I cannot just do a
insert into table select * from other_table;
because the fields are in a different order.
Can I do this by listing the fields in my insert in the order in which I
want them placed?
Thanks
Jodi

Bruno Wolff III wrote:

>On Wed, Aug 20, 2003 at 10:49:08 -0400,
> Jodi Kanter <jkanter(at)virginia(dot)edu> wrote:
>
>>can I now make this field not null?
>>
>>is it possible to move a field up in a table? now that I have done this
>>
>
>Currently, not without recreating the table. There was some discussion
>about that a few months ago, but nothing is happening in 7.4 on that
>front. Maybe in 7.5 there will be a way to change the column order,
>but don't count on it.
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>