Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Fran Fabrizio writes:
>> 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?
> Yes.
Dump and reload can be avoided by inserting the data into a temp table
instead. Should be at least somewhat faster.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
