GoLand
 
2025.1EAP
Shortcuts: Windows
Get GoLand
Because GoLand 2025.1 is still in development, this documentation may not be entirely accurate and is subject to change.
  1. Database Tools and SQL
  2. Introspection
  3. Pre-introspected objects from system catalogs

Pre-introspected objects from system catalogs

Last modified: 26 February 2025

Introspection is a process of loading the metadata of database objects and their source code.

A system catalog is a place where a relational database management system (DBMS) stores information about tables and columns, built-in functions, and other schema objects. The IDE uses data from this catalog for code completion and other coding assistance operations.

System schemas have the Enable or disable the usage of pre-introspected objects lightning icon in the schema selection dialog. If you do not select these schemas, GoLand does not introspect them and does not show them in the Database tool window. Though information about schema objects is used in coding assistance. It is possible because GoLand uses the internal data about schema objects that was introspected earlier (pre-introspected data).

To disable usage of pre-introspected data in GoLand, open data source settings by pressing ShiftEnter, click the Options tab and deselect Use pre-introspected objects for system catalogs that are not introspected.

Examples of system catalogs in different DBMS:

  • PostgreSQL: pg_catalog, information_schema

  • Microsoft SQL Server: INFORMATION_SCHEMA

  • Oracle: SYS, SYSTEM

  • MySQL, MariaDB: information_schema

  • IBM Db2 LUW: SYSCAT, SYSFUN, SYSIBM, SYSIBMADM, SYSPROC, SYSPUBLIC, SYSSTAT, SYSTOOLS

Show objects from system catalogs in coding assistance

Introspect system catalogs for a data source

By default, GoLand uses pre-introspected objects for system catalogs.

  1. In the Database tool window (View | Tool Windows | Database) , right-click a data source and select the Properties icon Properties (ShiftEnter).

  2. In the Data Sources and Drivers dialog, click the Options tab.

  3. Clear the Use pre-introspected objects for system catalogs that are not introspected checkbox.

    Introspect system catalogs for a data source

  4. Click the N of M button near the database name to open the schema selection popup window.

  5. In the schema selection popup window, select system catalogs that you want to introspect.

GoLand introspects the selected system catalogs.

Use pre-introspected data for a certain system catalog

You can still use pre-introspected objects for a certain system catalog even if you disable the usage of such objects for a data source in its settings.

  1. In the Database tool window (View | Tool Windows | Database) , right-click a data source and select the Properties icon Properties (ShiftEnter).

  2. In the Data Sources and Drivers dialog, click the Options tab.

  3. Clear the Use pre-introspected objects for system catalogs that are not introspected checkbox.

    Introspect system catalogs for a data source

  4. Click the N of M button near the database name to open the schema selection popup window.

  5. In the schema selection popup window, click the system catalog name.

  6. Clear the checkbox near system catalog name and click the Enable or disable the usage of pre-introspected objects lightning icon in the upper-right corner of the window.

GoLand uses pre-introspected data only for the system catalog that you selected.