Andreas Forø Tollefsen wrote:
Hi all,
When using the pgsql2shp the gid column is not included.
I even tried typing a "select gid AS g_id" to include it as a different
column name, but this did not work.
My syntax: pgsql2shp -f pgfinal2008.shp -h localhost -u user -P pass
postgis public.pgfinal2008 "SELECT *, gid as g_id FROM pgfinal2008
Any ideas how i manage to extract the gid column from my tables?
Hi Andreas,
Have you tried looking at the -r option for pgsql2shp?
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
