Re: how to execute pgsql2shp exe in sql

[Adrian Klaver]

On 7/14/19 8:54 PM, sunpeng wrote:
Could I use the following in psql or in a sql :
"D:\PostgreSQL\9.6\bin\pgsql2shp ...."

It's a command line program. See the docs:

https://postgis.net/docs/using_postgis_dbmanagement.html

4.5.2. Using the Dumper

The pgsql2shp table dumper connects directly to the database and 
converts a table (possibly defined by a query) into a shape file. The 
basic syntax is:
...

thanks
peng


--
Adrian Klaver
adrian.kla...@aklaver.com