Re: ALTER COLUMN - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: ALTER COLUMN
Date
Msg-id Pine.LNX.4.30.0105082321420.759-100000@peter.localdomain
Whole thread Raw
In response to ALTER COLUMN  (Fran Fabrizio <ffabrizio@exchange.webmd.net>)
Responses Re: ALTER COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select off of a view going slowly
Next
From: Tom Lane
Date:
Subject: Re: poor performance on 7.1 vs 7.0