[postgis-users] pgsql2shp - No GID variable

[Andreas Forø Tollefsen]

Hi,

I tried that, but at first it did not seem to work when loading the
shapefile into ArcGIS.
However, it seems that i had to restart ArcGIS to make it update the
attribute table for the file.
Now -r works.

Thanks.
Andreas

2010/10/26 Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>

> 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101026/5590a3e3/attachment.html>