Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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,


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

pgsql-novice by date

Next:From: ghaverlaDate: 2000-08-31 19:04:19
Subject: Re: Vacuum DB
Previous:From: Sokel, JohnDate: 2000-08-31 18:31:11
Subject: Vacuum DB

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group