Hi !
Or you can take a dump -c, edit the dump file's appropriate CREATE statement
for your table and column and just read the data back in.
BR,
aarni
---------- Forwarded Message ----------
Subject: Re: [NOVICE] data type change
Date: Mon, 6 Jan 2003 13:48:16 +0100
From: Alberto Bolchini <alberto@melloni49.it>
To: postgresql novice <pgsql-novice@postgresql.org>
Cc: renzo rizzato <renzorizzato@iol.it>
<quote who="renzo rizzato">
> does anybody know if any sql instruction exists to allow
> change of a column data type? In my case I need to convert a
> money type into numeric without any success.
AFAIK you cannot in Postgresql. I suggest you recreate the table with the
correct column datatypes (i.e. rename the table, create the new table and
populate it with values from the original table.) Watch out for triggers and
procedures.
Regards,
Alberto.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
-------------------------------------------------------