Quick Links

Need to change the size of a field

From:	<suresh(at)mithi(dot)com>
To:	<pgsql-sql(at)postgresql(dot)org>
Subject:	Need to change the size of a field
Date:	2002-02-18 13:30:49
Message-ID:	NFBBKGHMBKLDMDLMGGHBEENCCNAA.suresh@mithi.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

I have a table with one of the fields as a varchar(32) field. This table has
about 100,000 records.
I want to increase the size of the varchar field to 64. How can this be done
without affecting the data already present ?
Thanx in advance.
regards
suresh

Responses

Re: Need to change the size of a field at 2002-02-18 13:56:14 from Nick Fankhauser
Re: Need to change the size of a field at 2002-02-18 14:23:54 from postgresql
Re: Need to change the size of a field at 2002-02-18 18:24:16 from Stephan Szabo

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Nick Fankhauser	2002-02-18 13:56:14	Re: Need to change the size of a field
Previous Message	Mikey	2002-02-18 12:43:00	SQL: Are the "" around table & coloumnames necessary?