Postgres Pro
Downloads
Home   >   mailing lists

change datatypes - Mailing list pgsql-admin

From Marco Kärger
Subject change datatypes
Date
Msg-id 3DE48612.7050408@vitrado.de
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: pg_dump 7.3rc1 with 7.2 server.
Next
From: "Nick Fankhauser"
Date:
Subject: pg_restore error: function plpgsql_call_handler already exists with same argument types