ALTER COLUMN

From: Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ALTER COLUMN
Date: 2001-05-08 20:06:39
Message-ID: 3AF851CF.47047F87@exchange.webmd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


What's the best way to alter a column definition after the fact (i.e.
int8-->int4). Is the answer dump, drop table, make new table with new
definition and same name, import data?

Thanks,
Fran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-08 20:11:17 Re: Pl/PgSQL improvements
Previous Message Simon Crute 2001-05-08 19:32:00 Problems on inserting with DBD::Pg