Re: [gdal-dev] Add timestamp field with value to table during ogr2ogr operation

2017-10-29 Thread Even Rouault
On dimanche 29 octobre 2017 09:58:06 CET Bo Victor Thomsen wrote: > To the list - > > I'm converting shapefiles to postgres tables using ogr2ogr. As usual > with ogr2ogr, it works very well. > > Now I want to automatically add an extra column "created" with the > current timestamp during the ogr2

[gdal-dev] Add timestamp field with value to table during ogr2ogr operation

2017-10-29 Thread Bo Victor Thomsen
To the list - I'm converting shapefiles to postgres tables using ogr2ogr. As usual with ogr2ogr, it works very well. Now I want to automatically add an extra column "created" with the current timestamp during the ogr2ogr operation. Something like this: ogr2ogr .  -sql "SELECT *, CURREN