Re: increase the column size - Mailing list pgsql-general

From Michael Fuhr
Subject Re: increase the column size
Date
Msg-id 20041130061310.GA87797@winnie.fuhr.org
Whole thread Raw
In response to increase the column size  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
List 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/

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: RSS date still broken
Next
From: Kris Jurka
Date:
Subject: Re: [JDBC] Invalid Character Data Problem