Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing datatype of a column - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Changing datatype of a column
Date
Msg-id Pine.LNX.4.30.0106261643340.724-100000@peter.localdomain
Whole thread Raw
In response to Changing datatype of a column  (Ilan Fait <ilan@iweb.com>)
List pgsql-sql
Tree view 
Ilan Fait writes:

>               I would like to Know if there any way (and what is the command
> for that)  to convert a column datatype
>               from int4 to numeric(11)  of an existing table that have data
> in it?

No, you have to recreate the table.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems using a rule with the WHERE clause
Next
From: Tom Lane
Date:
Subject: Re: loosing connection after function call