PostgreSQL, ALTER COLUMN

ALTER COLUMN

Author	Message
Fran Fabriz #1 / 3	ALTER COLUMN 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Sun, 26 Oct 2003 04:44:48 GMT

Peter Eisentra #2 / 3	ALTER COLUMN Quote: 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. -- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Sun, 26 Oct 2003 05:39:43 GMT

Tom La #3 / 3	ALTER COLUMN Quote: > 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
Sun, 26 Oct 2003 06:13:22 GMT

Page 1 of 1

[ 3 post ]