2

There are a number of cases where the EXTENSION for postGIS is created iwth a schema qualifier.

CREATE SCHEMA postgis;
CREATE EXTENSION PostGIS WITH SCHEMA postgis;

why is that? what are the tradeoffs in using the schema?

1 Answer 1

2

A schema is like a namespace in programming. It lets you have different things with the same name.

For example, you might have a function foo() in your public schema. If PostGIS has a function foo() as well, that wouldn't work without name qualification.

1
  • I understand clearly now. This avoids potential duplication of functions, particularly as one may NOT be aware of them, as can be reasonably expected. Need to avoid duplication of PostGIS installation now!
    – Jerome
    Commented Aug 19, 2015 at 8:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.