Modifying tables

From: "Marc Zandvliet" <marc(at)auroraworks(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Modifying tables
Date: 2000-08-31 18:43:03
Message-ID: LJEMIBPPIBGEBAAPNFGKCEJLCAAA.marc@auroraworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

Is it possible to change the data type of a table column? The ALTER COLUMN
command doesn't seem to cover this. I thought the other alternative might be
to delete a column and then add one with the proper data-type.

Thanks for your suggestions,

Marc

p.s. thanks Tom for your last suggestion re: access conversion - it was the
CR/LF vs. LF problem.

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2000-08-31 19:04:19 Re: Vacuum DB
Previous Message Sokel, John 2000-08-31 18:31:11 Vacuum DB