Postgres Pro
Downloads
Home   >   mailing lists

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
List pgsql-general
Tree view 
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