[postgis-users] Help: How do I change data type to character to numeric?

[Marc Jansen]

Hey Zia,

hope this helps:

Try to chhange the columns data-type (Be sure to have a backup):

ALTER TABLE table_name ALTER COLUMN column_name TYPE new_type

see e.g.: http://www.postgresql.org/docs/8.0/static/sql-altertable.html

If you are experiencing problems, the USING- Part in that documentation 
might be of interest.

Regards,

Marc


Zia Ahmed schrieb:
> I am new in postgis. I ogr2ogr to import my dbase file to my data 
> base. After importation, data type of some of the column has changed 
> to numeric to character .  How do I change data type to character to 
> numeric again in pgAdminIII environment?
>
> Thanks
>
> Zia
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>