Result of \d public.results in psql: Table "public.results" Column | Type | Modifiers ----------+---------------+----------- the_geom | geometry | reg | character(16) |
2010/8/27 Mark Cave-Ayland <mark.cave-ayl...@siriusit.co.uk>: > Denis Rykov wrote: > >> Hello, Regina. There is information about my system: >> >> 1) RCSID: $Id: pgsql2shp-core.h 5646 2010-05-27 13:19:12Z pramsey $ >> RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 >> 2) pgsql2shp -f $dir_output/bounds/bnd-a-osm-buf.shp -U pgsql -d osm >> public.results >> 3) PostgreSQL 8.4 >> 4) 2.0 r5830 >> 5) FreeBSD 8.1 >> >> I get the following error: "Error executing main scan query: ERROR: >> column "gid" does not exist >> LINE 1: ... -1), 'NDR') AS _geoX FROM "public"."results" ORDER BY "gid"" > > That's probably my bug (although the other apparent bug is that I forgot to > set the svn id property on pgsql2shp-core.h too). > > What does the output of "\d public.results" look like in psql? > > > 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 > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
