Postgres Pro
Downloads
Home   >   mailing lists

Re: changing a column's position in table, how do you do that - Mailing list pgsql-sql

From Stewart Ben (RBAU/EQS4) *
Subject Re: changing a column's position in table, how do you do that
Date
Msg-id E253BDD7F008244585AEE87AF8F0224F116C7A74@cl-mail01.au.bosch.com
Whole thread Raw
In response to changing a column's position in table, how do you do that  (Ferindo Middleton Jr <fmiddleton@verizon.net>)
List pgsql-sql
Tree view 
Ferindo,

> Is there a way to change the position attribute of a column
> in a table?

AFAIK, there's no way to change this easily. The best way to do it would
be as follows:

BEGIN WORK;
LOCK TABLE mytable IN ACCESS EXCLUSIVE MODE;
ALTER TABLE mytable ADD COLUMN col_to_move_2 coltype;
UPDATE mytable SET col_to_move_2 = col_to_move;
ALTER TABLE mytable DROP COLUMN col_to_move;
ALTER TABLE mytable RENAME col_to_move_2 TO col_to_move;
COMMIT WORK;

Best regards,

Ben Stewart

--
Robert Bosch (Australia) Pty. Ltd.
Engineering Quality Services, Student Software Engineer (RBAU/EQS4)
Locked Bag 66 - Clayton South, VIC 3169 - AUSTRALIA
mailto:ben.stewart@au.bosch.com
http://www.bosch.com.au/

pgsql-sql by date:

Previous
From: Ferindo Middleton Jr
Date:
Subject: changing a column's position in table, how do you do that
Next
From: Chris Browne
Date:
Subject: Re: changing a column's position in table, how do you do that