Hi Rich,
Thanks for testing this. I think a pipeline works well here:
gdal vector pipeline read tl_2024_us_state.shp ! select
"STUSPS,NAME,_ogr_geometry_" ! geom set-type --multi ! write "PG:$PGCONN"
--lco GEOMETRY_NAME=geom
Dan
On Fri, Apr 25, 2025 at 7:35 PM Richard Greenwood via gdal-dev <
I'm playing with the (very cool) new gdal command line tool. I started with
a simple task of copying a shapefile into postgres. I only want two columns
from the shapefile and I need to cast it to a MultiLineString. My old
ogr2ogr command:
*ogr2ogr PG:"$PGCONN" shapefiles -sql "select STREET_NAM, TY
