Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE - Mailing list pgsql-general

On Thu, 6 Nov 2003, Marco Lazzeri wrote:

> I need, also, to move columns in tables (just like the MOVE BEFORE/MOVE
> AFTER MySQL commands). Can you help me?

I do it with select into:

begin;
select field3, field2, field4, field1 into newtable from oldtable;
drop oldtable;
alter table newtable rename to oldtable;
commit; (or rollback; if something goes wrong).