Batch loading OS Highway GML files to a PostgreSQL (+PostGIS) database

With one line at the Command Prompt (Windows) you can load a whole directory of files into a PostgreSQL database



D:\gisdata> for /R %f in (*.gml) do ogr2ogr -f "PostgreSQL" PG:"host=1.2.3.4 port=5432 user=postgres dbname=db password=pass123" %f -append


This will append the converted GML files into PostGIS format in the DB