Re: problem in modifing column datatype of a table

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Durga Prasad Mohapatra" <durgamohapatra(at)fastmail(dot)fm>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem in modifing column datatype of a table
Date: 2004-11-24 15:22:43
Message-ID: 200411241622.43087.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Durga Prasad Mohapatra wrote:
> I am newbie in postgresql.I want to modify column datatype of a
> table how can i do it.
> for example there is a column with datatype varchar, i want to change
> it to text.
> How can i.

Before 8.0: Recreate the table and copy the data.
After 8.0: ALTER TABLE

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric D Nielsen 2004-11-24 15:36:32 PostGreSQL upgrade failed (Debian Packages), need advice...
Previous Message Peter Eisentraut 2004-11-24 15:21:08 Re: Moving/Using Postgres Binaries on multiple machines