[gdal-dev] ogr2ogr giving postgres source a specific ogr layer name

andrew terry andrew.terry at centremaps.co.uk
Tue Feb 5 04:24:34 PST 2019


Apologies - i see -nln works both when using sql or just calling a table


andrew terry wrote
> Hi,
> 
> Is it possible to give postgres -sql output a specific ogr layer name.
> 
> As i understand it - In order to create DXF blocks, i need my postgres
> table
> (and therefore ogr layer name) to be called blocks.
> 
> Is there a way to force the ogr layer name being used.
> 
> I tried -sql "SELECT * FROM (SELECT * FROM public.table) blocks" without
> success
> 
> I don't want to use a view table as i'm hoping to use a function on some
> occassions
> 
> Andy
> 
> 
> 
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> _______________________________________________
> gdal-dev mailing list

> gdal-dev at .osgeo

> https://lists.osgeo.org/mailman/listinfo/gdal-dev





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html


More information about the gdal-dev mailing list