Converting an existing table? - Mailing list pgsql-sql

From Zot O'Connor
Subject Converting an existing table?
Date
Msg-id 37E2ACC7.E2513AD9@zotconsulting.com
Whole thread Raw
Responses Re: [SQL] Converting an existing table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I need to change the type on an existing table.  From money to something
else.

What is the best way under postgres?

I could do a query and put it in a new field and then rename the old
field, and then rename the new field.

I then have the old (renamed) field hanging around.  Is there a cleaner
way of doing this?

I also need to change the length of a variable length field.

-- 
Zot O'Connor

www.ZotConsulting.com
www.WhiteKnightHackers.com


pgsql-sql by date:

Previous
From: nathan
Date:
Subject: Select statements on a table that has null fields
Next
From: sniper7107@yahoo.com
Date:
Subject: ¸ÞÀϹ߼۱âÀÔ´Ï´Ù ½Ã°£´ç20¸¸°³¸¦ ¹ß¼ÛÇÒ¼öÀÕ½¿´Ï´Ù