How to change the position of a column in a table

This message was edited 1 time. Last update was at 23 Apr 2012 02:51:54

Hi All,

after adding a column to a table by using alter command, if i want change the position of that newly added column what i need to do.

Thanks & Regards,
Srinivas Davuluri

Please follow the below link.
http://wiki.postgresql.org/wiki/Alter_column_position

Thank U for your reply.

Well, i know that the way of changing column by recreating the table.
But is there any other solution for changing the position of a column.

Thanks & Regards,
Srinivas Davuluri

Well, another way is not recommended, i.e., changing the column position in system catalogs. Try moving column positioning by updating pg_attribute (attnum column) system catalog table.