Are we going to continue to see all interactive document comments posted
to the www list?
---------------------------------------------------------------------------
nobody wrote:
> Author: Alex French <alexfrench@gmail.com>
> ----
> Note that pg does not support changing the type of a column. Instead, use something like the code below to change,
say,a varchar(32) into varchar(64) (assuming the collumn is called abc):
>
> BEGIN;
> ALTER TABLE mytable ADD COLUMN abc_new varchar(64);
> UPDATE mytable SET abc_new = abc;
> ALTER TABLE mytable RENAME abc TO abc_old;
> ALTER TABLE mytable RENAME abc_new TO abc;
> COMMIT;
>
> If you're chaning the type of the column radically, you need to do more fancy type casting, but that's the theory.
> ----
> Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/ddl-alter.html
> Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1966
> Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1966
> Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1966
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
