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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
