ALTER COLUMN - Mailing list pgsql-general

From Fran Fabrizio
Subject ALTER COLUMN
Date
Msg-id 3AF851CF.47047F87@exchange.webmd.net
Whole thread Raw
Responses Re: ALTER COLUMN  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: IpcMemoryCreate: shmget failed (Invalid argument)
Next
From: Kyle
Date:
Subject: Re: poor performance on 7.1 vs 7.0