From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Modyifying a column's datatype |
Date: | 2003-09-03 21:13:08 |
Message-ID: | 1062623588.7341.411.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 2003-09-03 at 14:56, Louise Cofield wrote:
> 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.) L.
>
> 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?
There are references to this all throughout the archives.
begin;
alter table foo add column bar varchar;
update foo set bar = cast(sniffle as varchar);
alter table foo drop column sniffle;
alter table foo rename column bar to sniffle;
commit;
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
PETA - People Eating Tasty Animals
From | Date | Subject | |
---|---|---|---|
Next Message | Girish Bajaj | 2003-09-03 21:56:30 | Lock and read next |
Previous Message | Louise Cofield | 2003-09-03 19:56:26 | Modyifying a column's datatype |