Re: how to execute pgsql2shp exe in sql

2019-07-14 Thread 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 t

Re: how to execute pgsql2shp exe in sql

2019-07-14 Thread Ron
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.