Postgres Pro
Downloads
Home   >   mailing lists

alter table question - Mailing list pgsql-general

From Medi Montaseri
Subject alter table question
Date
Msg-id 3C80909C.3AAC3D8F@cybershell.com
Whole thread Raw
List pgsql-general
Tree view 
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@CyberShell.com
Unix Distributed Systems Engineer            HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: Re: UPDATE with value from another table
Next
From: thiemo
Date:
Subject: ERD or UML tool