Re: alter the column type - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: alter the column type
Date
Msg-id 3A7F82E7.EEC10B87@alumni.caltech.edu
Whole thread Raw
In response to alter the column type  (anson <anson_tsai@sina.com>)
List pgsql-hackers
> i would like to alter the column type which has exist in
> the table, i can't find anything about that, can anybody help me?

To effectively alter the type of a column, you must do a "create
table"/"insert into"/"create table as" combination to make an
intermediate temporary table with the correct type (of course, other
permutations of commands can give the desired result also).
                    - Thomas


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: How to modify type in table?
Next
From: Thomas Lockhart
Date:
Subject: Re: Parallel queries