[gdal-dev] ogr2ogr

[Bob Pawley]

I am trying to add columns to a table (which I am able to do), then add a trigger to that table in order to trigger an existing function.

My basic problem is that the ogr2ogr switch (ie: –lco Dim=2) appear to only work with an -overwrite. They don’t seem to work with an -append.

As -overwrite drops the existing table, as well as its trigger, I need to replace the trigger after the table is restored.

Does this make sense? 

Perhaps there is another way of doing this?

Bob



From: Chander Ganesan 
Sent: Tuesday, February 14, 2012 10:27 AM
To: gdal-dev at lists.osgeo.org 
Subject: Re: [gdal-dev] ogr2ogr

I'm not certain what you are trying to do, but...

Consider the SQL "UNION", "UNION ALL", "INTERSECT", or "INTERSECT ALL" statements perhaps?  They allow you to combine the results of two queries into a single result set (as a single query.)

Chander

On 2/14/12 1:24 PM, Bob Pawley wrote: 
  Is there a method of having two –sql commands in one command prompt execution.

  I have attempted 

  1. –sql “first statement ” –sql “second“

  2. –sql “first; second“

  3. sql “first “ “second“

  4. –sql “first” –overwrite –skipfailures -sql “second” (an attempt to separate the two).

  Bob

   

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev




--------------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120214/bef5b21a/attachment.html