Modyifying a column's datatype

From: "Louise Cofield" <lcofield(at)box-works(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Modyifying a column's datatype
Date: 2003-09-03 19:56:26
Message-ID: 000901c37255$75d5fa50$7801a8c0@Louise
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings -

It looks to me as if there is no way to alter the datatype of a table
column, as in from timestamp to varchar. Am I right? (I will cry if
I'm right.) :-(.

It appears that I must drop and then re-create the table structure, with
my new column datatype, in order to keep the columns in the current
order - true?

Thanks for your input.

Louise

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Johnson 2003-09-03 21:13:08 Re: Modyifying a column's datatype
Previous Message David Rickard 2003-09-03 17:46:12 Configure Errors--Missing Libraries?