If this is a Windows-only project, you can write directly to PostgreSQL / PostGIS using the ODBC driver. And if you have shapefiles, there's a PostGIS utility called "shp2pgsql" that will import them.
On Thu, Oct 23, 2014 at 1:03 PM, Paul Meems <[email protected]> wrote: > Hi, > > At this moment we are working on getting PostGIS support for MapWinGIS. > We use the PostGIS driver from GDALv2. > > So far we can read and write layers. > We also want to implement some tests, which are also used as a show case > for other users. > > For these tests I want to create a database, import some layers, doe > something with the layers and drop the database again. > > Creating and dropping a database using ExecuteSQL() doesn't work as stated > at the driver page: > The PostgreSQL driver does not support creation of new datasets (a > database within PostgreSQL), but it does allow creation of new layers > within an existing database. > The error I'm getting is "CREATE DATABASE cannot run inside a transaction > block". > > Does anybody have an idea how to solve this? I don't want to manually > create the database. The tests are more or less running automated. I would > also like to prevent to bypass GDAL/OGR and connect to PostGIS directly to > create and drop a database. > > Any suggestions are much appreciated. > > Thanks, > > Paul > > *Paul Meems * > Release manager, configuration manager > and forum moderator of MapWindow GIS. > www.mapwindow.org > > Owner of MapWindow.nl - Support for > Dutch speaking users. > www.mapwindow.nl > > > > *The English presentations of the MapWindow GIS Conference 2014 are > online. <http://www.slideshare.net/mapwindow>* > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > -- Twitter: http://twitter.com/znmeb; Computational Journalism on a Stick http://j.mp/CompJournoStickOverview Remember, if you're traveling to Bactria, Hump Day is Tuesday and Thursday.
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
