Postgres Pro
Downloads
Home   >   mailing lists

Thread: how to execute pgsql2shp exe in sql

how to execute pgsql2shp exe in sql

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

thanks
peng

Re: how to execute pgsql2shp exe in sql

From
Ron
Date:
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.

Re: how to execute pgsql2shp exe in sql

From
Adrian Klaver
Date:
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