alter table question

From: Medi Montaseri <medi(at)cybershell(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: alter table question
Date: 2002-03-02 08:43:08
Message-ID: 3C80909C.3AAC3D8F@cybershell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I alter a column's data type in PG?

If PG does not support such a change, what is a typical or clever
way of doing that?

I had to drop-create table a couple of times, but that does not
feel right. I know informix allows you to do that.

Thanks

--
-------------------------------------------------------------------------
Medi Montaseri medi(at)CyberShell(dot)com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message W. Luijk 2002-03-02 10:41:58 Which administration software to use
Previous Message thiemo 2002-03-02 08:27:03 ERD or UML tool