skip to main content
Reference : Connection Property Descriptions : SupportsCatalogs
  

SupportsCatalogs

Purpose

Enables support for catalogs. While Amazon Redshift 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

Default

false

Data Type

boolean