28787
DISCUSSIONS
102103
MEMBERS
3161
ARTICLES
Created on 06-09-2017 04:45 PM - edited 09-16-2022 04:44 AM
Hi,
I am using Hue (DBQuery editor) and Notebook (interpreters) to connect to an external Postgres database for running SQLs.
From the drop down of the databases/schemas, I can see the metadata such as column names for all tables in the "public" schema However when I choose a custom schema "my_schema" for example, I see the table names and I am able to RUN queries but I cannot expand or double click on TABLE names on the Left hand side to see the columns as it does for "public" schema.
Is there any extra setting or privilege that I have to set up on Postgres ?