I've used ogr2ogr to convert tables in PostgreSQL database to GeoJSON which works fine for the public schema. The question is how can I set the schema to non-public to access my tables? I've already using ACTIVE_SCHEMA option as follow but it gives me not existing relation error.
ogr2ogr -f "GeoJSON" out.json "PG:host=localhost dbname=test user=postgres ACTIVE_SCHEMA=line" -sql "select * from Road_a"
ERROR 1: ERROR: relation "road_a" does not exist LINE 1: DECLARE executeSQLCursor CURSOR for select * from Road_a