Quick Links

Converting an existing table?

From:	"Zot O'Connor" <zot(at)zotconsulting(dot)com>
To:	postgres sql <pgsql-sql(at)hub(dot)org>
Subject:	Converting an existing table?
Date:	1999-09-17 21:04:07
Message-ID:	37E2ACC7.E2513AD9@zotconsulting.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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

	From	Date	Subject
Next Message	sniper7107	1999-09-18 03:26:52	20
Previous Message	nathan	1999-09-17 20:07:43	Select statements on a table that has null fields