Alter Table

From: "Kevin Holbrook" <kevin(at)templegames(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: Alter Table
Date: 1999-10-06 18:16:13
Message-ID: 37FB91ED.C43EA791@templegames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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

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

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

Thanks in advance,

-Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 1999-10-06 18:41:18 Re: [GENERAL] Foreign Key
Previous Message Mike Mascari 1999-10-06 18:04:51 Re: [GENERAL] You are really hosed.