change datatypes

From: Marco Kärger <m(dot)kaerger(at)vitrado(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: change datatypes
Date: 2002-11-27 08:45:06
Message-ID: 3DE48612.7050408@vitrado.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi there,

i want to change the datatype within one colum for example column 'text'
which is 'varchar' to 'int(4)' i didnt find anything about that in the
manuals.

i tried something like that:

ALTER table io ALTER COLUMN wort RENAME TO wort int(4);

but it didnt work! i hope you can help me!

thx marco

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-11-27 13:16:22 pg_restore error: function plpgsql_call_handler already exists with same argument types
Previous Message Rajesh Kumar Mallah. 2002-11-27 05:22:33 Re: pg_dump 7.3rc1 with 7.2 server.