TIL — Postgres v15 features

All roles in Postgres inherit from the Public role and, therefore, can create objects on the public schema. This is no longer the case with Postgres v15.

It removes the default CREATE privilege, which is a good security measure. Now, we no longer have to run the below.

REVOKE CREATE ON SCHEMA "public" FROM PUBLIC;