Re: Changing column data type on an existing table

From: David Fetter <david(at)fetter(dot)org>
To: Joe Audette <joe_audette(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing column data type on an existing table
Date: 2005-05-13 19:15:47
Message-ID: 20050513191547.GE20111@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Russell Smith 2005-05-14 01:07:32 Re: pgplsh on postgresql 8.0.2
Previous Message Dann Corbit 2005-05-13 19:12:30 Re: WHERE