sql-psi icon indicating copy to clipboard operation
sql-psi copied to clipboard

Add option to specify system tables

Open hfhbd opened this issue 1 year ago • 0 comments

Each database has unique system tables containing system information. At the moment sql-psi does not know about these tables so referrencing to these tables fails with No table found with name.

Sample: DB2 requires a FROM clause, so you have to use the SYSIBM.SYSDUMMY1 for simple selects: SELECT TIME_STAMP FROM SYSIBM.SYSDUMMY1. Oracle provides a similar dual table.

Same use case for system catalog with PostgreSQL: https://www.postgresql.org/docs/current/catalogs.html

hfhbd avatar Sep 19 '22 13:09 hfhbd