Changing datatype of a column

From: Ilan Fait <ilan(at)iweb(dot)com>
To: "'Pgsql-Sql (E-mail)" <pgsql-sql(at)postgresql(dot)org>
Subject: Changing datatype of a column
Date: 2001-06-26 07:41:03
Message-ID: C9E46ACE328FD311B70200508B91AD8CA8FED8@EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

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?


Thanks,
Ilan


_________________________________________
ILAN FAIT
Tel: 972-9-9519133 Ex.247 iWeb Technologies
Fax: 972-9-9519134 91 Medinat Ha'Yehudim St.
Herzliya 46120 IL
mailto:ilan(at)iweb(dot)com www.iweb.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Sousa 2001-06-26 09:52:30 Re: Problems using a rule with the WHERE clause
Previous Message Markus Wagner 2001-06-26 05:52:48 loosing connection after function call