Purpose

Enables support for catalogs. While PostgreSQL has the notion of catalogs (or databases), you can only select from tables that reside within the catalog you specified at connect time. Catalogs cannot be changed after connecting. Therefore, most applications behave better if you do not indicate support for catalogs.

Valid Values

true | false

Behavior

If set to true, the driver returns the database as the catalog for catalog calls, for example, getTables and getColumns.

If set to false, the driver returns NULL for the catalog in catalog calls.

Notes

The SupportsCatalogs connection property affects the following catalog methods:

  • getCatalogSeparator
  • getCatalogTerm
  • getMaxCatalogNameLength
  • isCatalogAtStart
  • supportsCatalogsInDataManipulation
  • supportsCatalogsInProcedureCalls
  • supportsCatalogsInTableDefinitions
  • supportsCatalogsInIndexDefinitions
  • supportsCatalogsInPrivilegeDefinitions

Data Source Methods

public Boolean getSupportsCatalogs()

public void setSupportsCatalogs(Boolean)

Default

true

Data Type

Boolean