[GIS] Where to type pgsql2shp command

pgsql2shppostgispostgresql

How to convert post gis database into shapefile, I found that I need to use pgsql2shp command on postgis database query , But how to use it and where to use it. Do I have to use it in the postgre sql database command line or in the normal command line?

Best Answer

The PostgreSQL Manual explains how to add the path to binaries to the PATH environment variable. This procedure depends on your OS distribution and how you installed PostgreSQL and/or PostGIS.

Otherwise, if you want to run a program like shp2pgsql without adding it to PATH, the path to the binary needs to be specified:

/usr/local/pgsql/bin/shp2pgsql example.shp public.example > example.sql

Related Solutions

PostGIS – Solving Errors When Using pgsql2shp for Shapefile Export

PostGIS 2.0 doesn't have the function zmflag(geometry). It is now known as st_zmflag(geometry). I'm betting that the version of pgsql2shp is from a prior version of PostGIS. You can check with

pgsql2shp -?

At the top of the output, it should list the release version. Something like...

RELEASE: 2.1.0SVN (r10420)

PostGIS – Diagnosing and Resolving pgsql2shp Error with PostgreSQL Queries

There's probably an issue with escaping double quotes in your final command. To bypass that you could create a view in your Postgres database and give it a simple name. Something like:

CREATE VIEW v_export AS
  SELECT * FROM planning."dm_planning-apps" 
    WHERE "dm_planning-apps"."Modified_Reference" ILIKE '%np%';

Then from the command line you could use

"C:\Program Files\PostgreSQL\9.1\bin\pgsql2shp.exe" -f "D:\path\shapefile.shp" -h localhost -p 5432 -u postgres -P xxxx mapdata v_export

It's kind of a cheat, but it should work.

Best Answer

Related Solutions

PostGIS – Solving Errors When Using pgsql2shp for Shapefile Export

PostGIS – Diagnosing and Resolving pgsql2shp Error with PostgreSQL Queries

Related Question