Peter Eisentraut <peter_e(at)gmx(dot)net> 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