Home

Exclude certain schemas/tables from connection (postgres)

I have naming conflicts between two schemas in the same postgres database.
x.Project and y.Project
become Project and Project1 (although, I believed these would get prefixed with [schema]_ in case of an conflict, which I could live with - but still not great)

My initial thought was that I could just create a new postgres role/user which does not have privileges on schema "y" because I'm not interested in anything under schema "y". Instead I can still see all the tables under schema "y".

So, is there no option to exclude certain schemas/tables from being scaffolded and visualized in the left side menu or something similar I can do to get rid of this naming conflict?

Comments

Sign In or Register to comment.