how to execute pgsql2shp exe in sql

On 7/14/19 10:54 PM, sunpeng wrote:

Could I use the following in psql or in a sql :
"D:\PostgreSQL\9.6\bin\pgsql2shp ...."

This *should* work, though you might have to fiddle with the quotes:

yourdb=> \! "D:\PostgreSQL\9.6\bin\pgsql2shp ...."

--
Angular momentum makes the world go 'round.

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