PGSQL2SHP Commnad switch column type

المشرف العام

Administrator
طاقم الإدارة
I work with Postgis. I have table

CREATE TABLE centerline( gid serial NOT NULL, l_from integer, l_to integer, r_add_pre character varying(15), r_to integer ... }Export this table with PGSQL2SHP command

command is

pgsql2shp -f centerline.shp -h localhost -u redsky ....and when I imported it back with command

shp2pgsql -i -s 4326 centerline.shpit generates table

CREATE TABLE centerline ( gid serial NOT NULL, l_from double precision, l_to double precision, r_add_pre character varying(15), r_to double precision ... }I do not want double type. Can Anybody help me?



أكثر...
 
أعلى