PostGIS to SQLite
ogr2ogr -progress -gt 65536 -f "SQLite" data.sqlite PG:'host=localhost active_schema=data user=postgres password=password dbname=data port=5432" -a_srs "EPSG:27700"
Only load a specific schema
ogr2ogr --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f "SQLite" data.sqlite -progress PG:"dbname='data' active_schema=data schemas=data host='localhost' port='5432' user='postgres' password='password'" -gt 65536 -a_srs "EPSG:27700"
Updated less than a minute ago