ERROR 1: COPY STATEMENT FAILED
ERROR: numeric field overflow
DETAIL: A field with precision 13, scale 11 must round to an absolute value less than 10^2.
CONTEXT: COPY ccbc_roads, line 2, column length :"222.05900000000"

ogr2ogr.exe -f PostgreSQL PG:"dbname=postgis host=localhost user=postgres password=mypassword active_schema=ccbc_data" "roads.shp" -overwrite -a_srs "EPSG:27700" -lco GEOMETRY_NAME=geom -nln "ccbc_roads" -nlt PROMOTE_TO_MULTI --config PG_USE_COPY YES

ogr2ogr.exe -f PostgreSQL PG:"dbname=postgis host=localhost user=username password=mypassword postgres active_schema=ccbc_data" "M:dataroads.shp" -sql "select roads_id, form_of_wa, oneway, cat, class, route_numb, proper_nam, locality, place FROM roads" -overwrite -a_srs "EPSG:27700" -nln "ccbc_roads" -lco GEOMETRY_NAME=geom --config PG_USE_COPY YES