Re: how to execute pgsql2shp exe in sql - Mailing list pgsql-general

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.klaver@aklaver.com