[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] increase the column size
From:       Michael Fuhr <mike () fuhr ! org>
Date:       2004-11-30 6:13:10
Message-ID: 20041130061310.GA87797 () winnie ! fuhr ! org
[Download RAW message or body]

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/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html
[prev in list] [next in list] [prev in thread] [next in thread]