Change size of varchar(20) field

From: David A Dickson <davidd(at)saraswati(dot)wcg(dot)mcgill(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Change size of varchar(20) field
Date: 2002-02-04 17:03:36
Message-ID: Pine.LNX.4.33.0202041201380.32543-100000@blues.wcg.mcgill.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)dickson(at)mail(dot)mcgill(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frank Bax 2002-02-04 17:46:49 Re: Change size of varchar(20) field
Previous Message Jason Earl 2002-02-04 16:58:32 Re: index does not improve performance