Re: Changing column data type on an existing table - Mailing list pgsql-general

From David Fetter
Subject Re: Changing column data type on an existing table
Date
Msg-id 20050513191547.GE20111@fetter.org
Whole thread Raw
In response to Changing column data type on an existing table  (Joe Audette <joe_audette@yahoo.com>)
List pgsql-general
On Fri, May 13, 2005 at 10:34:34AM -0700, Joe Audette wrote:
> Hi,
>
> I have an app that I released with a particular field
> as varchar 255.

If you're using PostgreSQL 8, there is an option to ALTER TABLE that
does this.  The docs on ALTER TABLE including man alter_table have
examples :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: WHERE
Next
From: Russell Smith
Date:
Subject: Re: pgplsh on postgresql 8.0.2