On Sat, 2023-04-15 at 12:06 +0200, Alexander Farber wrote: > I am seeking for a general advice if it would be a good idea for a PostgreSQL/PostGIS using application to add a third schema. > > I am using postgis/postgis Docker image which comes with "public" schema. > > Then I have loaded OpenStreetMap data into the database and have created "osm_schema" for that: > > And now I need one more table, for the new mapping feature in my application, which would reference the osm_id column in the planet_osm_roads. > > I have not used database schemas at all until yet, I am looking for an advice if I should add a third schema here, just for my application? I would add another schema. The "public" schema for the extensions, "osm_schema" for the OpenStreetMap data, and a third schema for your table. Perhaps you want to add additional objects later. Yours, Laurenz Albe
