Re: [GENERAL] Alter Table

From: tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff)
To: "Kevin Holbrook" <kevin(at)templegames(dot)com>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] Alter Table
Date: 1999-10-07 06:31:31
Message-ID: 87vh8j3cn0.fsf@tolikus.hq.aaanet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "KH" == Kevin Holbrook <kevin(at)templegames(dot)com> writes:

KH> Hello,
KH> Anybody know any easy way to ALTER the column type of a column in an
KH> existing table without dumping it?

KH> Something akin to : ALTER TABLE tableOne CHANGE fieldOne
KH> VARCHAR(100).

KH> I have a limited varchar field that I want to change to TEXT.
KH> I am using 6.4.

I think there is NO way to change the type of existing column :(

--
Anatoly K. Lasareff Email: tolik(at)icomm(dot)ru

In response to

  • Alter Table at 1999-10-06 18:16:13 from Kevin Holbrook

Browse pgsql-general by date

  From Date Subject
Next Message Zakkr 1999-10-07 06:32:04 Re: [GENERAL] Many BLOb;s
Previous Message The Hermit Hacker 1999-10-07 05:52:50 Re: [GENERAL] Re: PostgreSQL vs Mysql comparison