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(dot)klaver(at)aklaver(dot)com