[postgis-users] pgsql2shp - No GID variable

[Andreas Forø Tollefsen]

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?

Andreas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101026/c2a32829/attachment.html>