Cannot send result directly to database about ogr2ogr HOT 8 CLOSED

I think you are on to something, there was a commit that came in earlier to alias PostgreSQL to use PGDump instead, but it appears both are supported and PostgreSQL should not be aliased.

http://www.gdal.org/drv_pg.html
http://www.gdal.org/drv_pgdump.html

from ogr2ogr.

Are you referring to this commit https://github.com/ChrisCarto/ogr2ogr/commit/801ec8fa781974f47c55b5a65432dc4c0bb4fa11 ?

from ogr2ogr.

Yes, that's a pretty simple change. The problem comes is which one should be default for ".sql" files. I imagine pgdump? But maybe not?

from ogr2ogr.

I made some minor changes to the drivers file and it worked for me

modified ogr2ogr / lib / drivers.json

From:

{
"format": "PGDump",
"aliases": ["PostgreSQL"],
"output": "sql"
},

To:

 {
    "format": "PGDump",
    "aliases": ["PGDump"],
    "output": "sql"
  },{
    "format": "PostgreSQL",
    "aliases": ["PostgreSQL"],
    "output": "sql"
  },

Example:

var ogr = ogr2ogr(layerPath)
                    .format('PostgreSQL')
                    .skipfailures()
                    .project('EPSG:4326', 'EPSG:4326')
                    .destination('PG:host=localhost user=postgres dbname=sandbox password=postgres')
                    .timeout(30000)
                    .stream();
        ogr.on('error', function(message) {
            console.log(message);
        });
        var ogr = ogr2ogr(layerPath)
                    .format('PGDump')
                    .skipfailures()
                    .project('EPSG:4326', 'EPSG:4326')
                    .destination('uploads/test2.sql')
                    .timeout(30000)
                    .stream();
        ogr.on('error', function(message) {
            console.log(message);

from ogr2ogr.

this is fixed now in 0.4.1

from ogr2ogr.

Marc,

I was recently looking at your humane.js and was wondering how I would
implement this in a nodejs + expressjs + jade setup. I am working on
something similar to ogre and would love to have info responses to the
user, like no features found display as a humane.log('No Features Found').
I did a few searches, but little came up for results on the subject.

Respectfully,
Dan

On Fri, Oct 17, 2014 at 10:31 PM, Marc Harter [email protected]
wrote:

Closed #8 #8.

Reply to this email directly or view it on GitHub
#8 (comment).

Daniel Berry
512.962.4518 - Cell number
217.434.4101 - Skype number

from ogr2ogr.

@BerryDaniel I have used connect-flash in the past, and have a little jade snippet in my layout that checks for flash messages and displays them in a div and then a little js that checks that div and pops them up. It probably could be streamlined more too.

from ogr2ogr.

Do you have an example you are willing to share. Seems like a decent
approach.

On Wed, Oct 22, 2014 at 9:59 AM, Marc Harter [email protected]
wrote:

@BerryDaniel https://github.com/BerryDaniel I have used connect-flash
in the past, and have a little jade snippet in my layout that checks for
flash messages and displays them in a div and then a little js that checks
that div and pops them up. It probably could be streamlined more too.

Reply to this email directly or view it on GitHub
#8 (comment).

Daniel Berry
512.962.4518 - Cell number
217.434.4101 - Skype number

from ogr2ogr.