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
thirdschema.
>
> 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
inthe 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,
justfor 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