Re: Nu-B\Column:Alter type - Mailing list pgsql-novice

John-paul,

>  How do I change a column from date type to text?

This functionality is not supported in version 7.2 or earlier.  You
 will have to drop and re-create the table:

1. CREATE TABLE temp1 AS
    SELECT * FROM bad_table;
2. DROP TABLE bad_table;
3. CREATE TABLE bad_table;
4. INSERT INTO bad_table SELECT * FROM temp1;
5. DROP TABLE temp1

-Josh Berkus