changeing type of column

From: "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: changeing type of column
Date: 2002-04-02 18:18:48
Message-ID: 103546202577.20020402221848@artofit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've know that there is no function to change type of column in postgresql table.
But i have a table with serial field (sequence) and many other field.
And i need to change one field from int4 to varchar.

What is the best way to do it ?

--
Best regards,
Yuri mailto:sec(at)artofit(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Gribble 2002-04-02 18:54:13 How to handle sequences and replication?
Previous Message David Esposito 2002-04-02 18:03:07 Re: Core dump on PG 7.1.3