[lug] Postgres Alter table

[Calvin Dodge]

Calvin Dodge wrote:
> 
> alter table TABLENAME rename OLDCOLUMN to tempcolumn;
> alter table TABLENAME add column OLDCOLUMN float4;
> update TABLENAME set OLDCOLUMN=column;

That last line should be "update TABLENAME set OLDCOLUMN=tempcolumn;"

Calvin

-- 
Calvin Dodge
Certified Linux Bigot (tm)
http://www.caldodge.fpcc.net