I can not found tables of pg_catalog schema in Yellowfin datasouce and view.

Yuu Asakawa shared this idea 1 year ago
Idea Logged

I can not found tables of pg_catalog schema in Yellowfin datasouce and view.

Why is it?


How can I use tables of pg_catalog schema in Yellowfin Drag and Drop View builder?

Comments (2)

photo
1

Hi Yuu,


Thanks for your post.


pg_catalog is a System schema. Please go to Postgres and check whether it has any tables in there.

I have tested here and couldn't find any tables in pg_catalog.


You don't have to use system schema, is there any valid reason to use pg_catalog?


Let me know if you have any questions.


Regards,


Mahe

photo
1

Hi Yuu,


Hope you are doing well.

Sorry for delay in reply.

I thought I have replied back to you, but when I was looking at my tickets, I came across this ticket, still sitting in my inbox.


I remember speaking to Steve Joynt, before his leaving Yellowfin, and he advised we should not be able to access the pg_catalog as this is system related tables.

Then I said we are able to access the pg_catalog Schema but not the tables, then he advised some needs to review the code.


I have raised this as an enhancement request.


Please let me know if you have any questions or concerns.


Regards,


Mahe