Re: changeing type of column

From: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
To: "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: changeing type of column
Date: 2002-04-02 19:06:51
Message-ID: Pine.LNX.4.44.0204022205560.9089-100000@oper.metu.edu.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi Yuri,

On Tue, 2 Apr 2002, Yuri A. Kabaenkov wrote:

> 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 ?

Just dump the database, edit the dump file, change the table definitions
in the dump file and reload the database...

Best regards,

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
devrimg(at)tr(dot)net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-02 19:08:54 Re: Why are selects so slow on large tables, even when
Previous Message Bill Gribble 2002-04-02 18:54:13 How to handle sequences and replication?