Re: increase the column size

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: increase the column size
Date: 2004-11-30 06:13:10
Message-ID: 20041130061310.GA87797@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 30, 2004 at 11:16:39AM +0530, Nageshwar Rao wrote:

> I would like to change the column length from varchar(10) to varchar(30).How
> this can be done.

Changing a column's type is discussed in the FAQ:

http://www.postgresql.org/docs/faqs/FAQ.html#4.4

In PostgreSQL 8.0 you'll be able to use ALTER TABLE.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-11-30 06:34:46 Re: [JDBC] Invalid Character Data Problem
Previous Message Bill Harris 2004-11-30 05:49:56 Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...