Changing datatype of a column
От | Ilan Fait |
---|---|
Тема | Changing datatype of a column |
Дата | |
Msg-id | C9E46ACE328FD311B70200508B91AD8CA8FED8@EXCHANGE обсуждение исходный текст |
Ответы |
Re: Changing datatype of a column
Re: Changing datatype of a column |
Список | pgsql-sql |
<br /><p><font face="Arial" size="2"> Hi,</font><p><font face="Arial" size="2"> I would like toKnow if there any way (and what is the command for that) to convert a column datatype</font><br /><font face="Arial" size="2"> from int4 to numeric(11) of an existing table that have data in it?</font><br /><font face="Arial"size="2"> </font><br /><font face="Arial" size="2"> </font><br /><font face="Arial" size="2"> Thanks,</font><br /><font face="Arial" size="2"> Ilan</font><p><font face="Arial" size="2"> </font><br /><b><font color="#000000" face="Century Gothic">_________________________________________</font></b><br/><b><font color="#000000" face="Century Gothic">ILAN FAIT</font></b><br/><font color="#000000" face="Century Gothic" size="2">Tel: 972-9-9519133 Ex.247 iWeb Technologies</font><br/><font color="#000000" face="Century Gothic" size="2">Fax: 972-9-9519134 91 MedinatHa'Yehudim St.</font><br /><font color="#000000" face="Century Gothic" size="2"> Herzliya 46120 IL</font><br /><font color="#000000" face="CenturyGothic" size="2"><a href="mailto:ilan@iweb.com">mailto:ilan@iweb.com</a> www.iweb.com</font><br />
В списке pgsql-sql по дате отправления: