Alter Table - Mailing list pgsql-general

From Kevin Holbrook
Subject Alter Table
Date
Msg-id 37FB91ED.C43EA791@templegames.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: [GENERAL] You are really hosed.
Next
From: Mike Mascari
Date:
Subject: Re: [GENERAL] Foreign Key