Re: Change size of varchar(20) field - Mailing list pgsql-general

You can either:

a)  create table unittemp as select field1, field2, cast(room as
varchar(20)), ..., fieldn from unit;
    drop table unit;
    alter table unittemp rename to unit;

b)  pg_dump -t unit [dbname] > unit.pgsql
    edit unit.pgsql and change varchar(20) to varchar(40) and add a line to
beginning of file "drop table unit"
    pgsql [dbname] < unit.pgsql

Frank

At 12:03 PM 2/4/02 -0500, David A Dickson wrote:
>I have a tabl called 'unit' with a field 'room' of type character
>varying(20). I want to change the type to character varying(40).
>How do I do this without affecting any data in the table.
>
>Thanksâ
>
>--
>David A Dickson
>david.dickson@mail.mcgill.ca
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>