PostgreSQLDatabaseMetaData
class in package klyn.databases.sql.postgresql

    public class PostgreSQLDatabaseMetaData implements DatabaseMetaData:

PostgreSQLDatabaseMetaData
All Implemented Interfaces: DatabaseMetaData

PostgreSQL database metadata.

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | connection `connection as Connection:` | No summary.
public readonly property | driverName `driverName as String:` | No summary.
public readonly property | driverVersion `driverVersion as String:` | No summary.
public readonly property | productName `productName as String:` | No summary.
public readonly property | productVersion `productVersion as String:` | No summary.
public readonly property | readOnly `readOnly as Boolean:` | No summary.
public readonly property | supportsBatchUpdates `supportsBatchUpdates as Boolean:` | No summary.
public readonly property | supportsNamedParameters `supportsNamedParameters as Boolean:` | No summary.
public readonly property | supportsPreparedStatements `supportsPreparedStatements as Boolean:` | No summary.
public readonly property | supportsSavepoints `supportsSavepoints as Boolean:` | No summary.
public readonly property | supportsStoredProcedures `supportsStoredProcedures as Boolean:` | No summary.
public readonly property | supportsTransactions `supportsTransactions as Boolean:` | No summary.
public readonly property | url `url as String:` | No summary.
public readonly property | userName `userName as String:` | No summary.

Inherited Properties
property Inherited Properties from DatabaseMetaData: connection, driverName, driverVersion, productName, productVersion, readOnly, supportsBatchUpdates, supportsNamedParameters, supportsPreparedStatements, supportsSavepoints, supportsStoredProcedures, supportsTransactions, url, userName
Constructors

Modifier and Type | Member | Description
--- | --- | ---
public | PostgreSQLDatabaseMetaData `PostgreSQLDatabaseMetaData(connection as PostgreSQLConnection):` | No summary.

Methods

Modifier and Type | Member | Description
--- | --- | ---
public | catalogs `catalogs() as ResultSet throws SQLException:` | Reads SQL metadata.
public | columns `columns(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", columnPattern as String = "%") as ResultSet throws SQLException:` | No summary.
public | dataDefinitionCausesTransactionCommit `dataDefinitionCausesTransactionCommit() as Boolean:` | No summary.
public | dataDefinitionIgnoredInTransactions `dataDefinitionIgnoredInTransactions() as Boolean:` | No summary.
public | dateTimeFunctions `dateTimeFunctions() as String:` | No summary.
public | defaultTransactionIsolation `defaultTransactionIsolation() as TransactionIsolation:` | No summary.
public | deletesAreDetected `deletesAreDetected(type as ResultSetType) as Boolean:` | No summary.
public | doesMaxRowSizeIncludeBlobs `doesMaxRowSizeIncludeBlobs() as Boolean:` | No summary.
public | driverMajorVersion `driverMajorVersion() as Int:` | No summary.
public | driverMinorVersion `driverMinorVersion() as Int:` | No summary.
public | exportedKeys `exportedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | No summary.
public | functions `functions(catalog as String = "", schemaPattern as String = "", functionPattern as String = "%") as ResultSet throws SQLException:` | No summary.
public | getAttributes `getAttributes(catalog as String = "", schemaPattern as String = "", typeNamePattern as String = "", attributeNamePattern as String = "") as ResultSet throws SQLException:` | No summary.
public | getIndexInfo `getIndexInfo(catalog as String = "", schema as String = "", table as String = "", unique as Boolean = false, approximate as Boolean = true) as ResultSet throws SQLException:` | No summary.
public | getProcedureColumns `getProcedureColumns(procedurePattern as String = "%") as ResultSet throws SQLException:` | Reads SQL metadata.
public | getSuperTables `getSuperTables(catalog as String = "", schemaPattern as String = "", tableNamePattern as String = "") as ResultSet throws SQLException:` | No summary.
public | getSuperTypes `getSuperTypes(catalog as String = "", schemaPattern as String = "", typeNamePattern as String = "") as ResultSet throws SQLException:` | No summary.
public | getUDTs `getUDTs(catalog as String = "", schemaPattern as String = "", typeNamePattern as String = "", types as ArrayList<Int> = null) as ResultSet throws SQLException:` | No summary.
public | identifierQuoteString `identifierQuoteString() as String:` | No summary.
public | importedKeys `importedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | No summary.
public | indexes `indexes(catalog as String = "", schema as String = "", tableName as String = "", unique as Boolean = false) as ResultSet throws SQLException:` | Returns portable index metadata.
public | insertsAreDetected `insertsAreDetected(type as ResultSetType) as Boolean:` | No summary.
public | maxBinaryLiteralLength `maxBinaryLiteralLength() as Int:` | No summary.
public | maxCatalogNameLength `maxCatalogNameLength() as Int:` | No summary.
public | maxCharLiteralLength `maxCharLiteralLength() as Int:` | No summary.
public | maxColumnsInGroupBy `maxColumnsInGroupBy() as Int:` | No summary.
public | maxColumnsInOrderBy `maxColumnsInOrderBy() as Int:` | No summary.
public | maxColumnsInSelect `maxColumnsInSelect() as Int:` | No summary.
public | maxColumnsInTable `maxColumnsInTable() as Int:` | No summary.
public | maxConnections `maxConnections() as Int:` | No summary.
public | maxCursorNameLength `maxCursorNameLength() as Int:` | No summary.
public | maxIndexLength `maxIndexLength() as Int:` | No summary.
public | maxProcedureNameLength `maxProcedureNameLength() as Int:` | No summary.
public | maxRowSize `maxRowSize() as Int:` | No summary.
public | maxSchemaNameLength `maxSchemaNameLength() as Int:` | No summary.
public | maxStatementLength `maxStatementLength() as Int:` | No summary.
public | maxStatements `maxStatements() as Int:` | No summary.
public | maxTableNameLength `maxTableNameLength() as Int:` | No summary.
public | maxTables `maxTables() as Int:` | No summary.
public | maxUserNameLength `maxUserNameLength() as Int:` | No summary.
public | nullPlusNonNullIsNull `nullPlusNonNullIsNull() as Boolean:` | No summary.
public | numericFunctions `numericFunctions() as String:` | No summary.
public | othersDeletesAreVisible `othersDeletesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | othersInsertsAreVisible `othersInsertsAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | othersUpdatesAreVisible `othersUpdatesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownDeletesAreVisible `ownDeletesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownInsertsAreVisible `ownInsertsAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownUpdatesAreVisible `ownUpdatesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | primaryKeys `primaryKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | No summary.
public | procedures `procedures(catalog as String = "", schemaPattern as String = "", procedurePattern as String = "%") as ResultSet throws SQLException:` | No summary.
public | schemas `schemas() as ResultSet throws SQLException:` | No summary.
public | searchStringEscape `searchStringEscape() as String:` | No summary.
public | sqlKeywords `sqlKeywords() as String:` | No summary.
public | storesLowerCaseIdentifiers `storesLowerCaseIdentifiers() as Boolean:` | No summary.
public | storesLowerCaseQuotedIdentifiers `storesLowerCaseQuotedIdentifiers() as Boolean:` | No summary.
public | storesMixedCaseIdentifiers `storesMixedCaseIdentifiers() as Boolean:` | No summary.
public | storesMixedCaseQuotedIdentifiers `storesMixedCaseQuotedIdentifiers() as Boolean:` | No summary.
public | storesUpperCaseIdentifiers `storesUpperCaseIdentifiers() as Boolean:` | No summary.
public | storesUpperCaseQuotedIdentifiers `storesUpperCaseQuotedIdentifiers() as Boolean:` | No summary.
public | stringFunctions `stringFunctions() as String:` | No summary.
public | supportsANSI92EntryLevelSQL `supportsANSI92EntryLevelSQL() as Boolean:` | No summary.
public | supportsANSI92FullSQL `supportsANSI92FullSQL() as Boolean:` | No summary.
public | supportsANSI92IntermediateSQL `supportsANSI92IntermediateSQL() as Boolean:` | No summary.
public | supportsAlterTableWithAddColumn `supportsAlterTableWithAddColumn() as Boolean:` | No summary.
public | supportsAlterTableWithDropColumn `supportsAlterTableWithDropColumn() as Boolean:` | No summary.
public | supportsCatalogAtStart `supportsCatalogAtStart() as Boolean:` | No summary.
public | supportsCatalogsInDataManipulation `supportsCatalogsInDataManipulation() as Boolean:` | No summary.
public | supportsCatalogsInIndexDefinitions `supportsCatalogsInIndexDefinitions() as Boolean:` | No summary.
public | supportsCatalogsInPrivilegeDefinitions `supportsCatalogsInPrivilegeDefinitions() as Boolean:` | No summary.
public | supportsCatalogsInProcedureCalls `supportsCatalogsInProcedureCalls() as Boolean:` | No summary.
public | supportsCatalogsInTableDefinitions `supportsCatalogsInTableDefinitions() as Boolean:` | No summary.
public | supportsColumnAliasing `supportsColumnAliasing() as Boolean:` | No summary.
public | supportsConvert `supportsConvert() as Boolean:` | No summary.
public | supportsConvert `supportsConvert(fromType as Int, toType as Int) as Boolean:` | No summary.
public | supportsCoreSQLGrammar `supportsCoreSQLGrammar() as Boolean:` | No summary.
public | supportsCorrelatedSubqueries `supportsCorrelatedSubqueries() as Boolean:` | No summary.
public | supportsDataDefinitionAndDataManipulationTransactions `supportsDataDefinitionAndDataManipulationTransactions() as Boolean:` | No summary.
public | supportsDataManipulationTransactionsInTransactions `supportsDataManipulationTransactionsInTransactions() as Boolean:` | No summary.
public | supportsDifferentTableCorrelationNames `supportsDifferentTableCorrelationNames() as Boolean:` | No summary.
public | supportsDistinct `supportsDistinct() as Boolean:` | No summary.
public | supportsExpressionsInOrderBy `supportsExpressionsInOrderBy() as Boolean:` | No summary.
public | supportsExtendedSQLGrammar `supportsExtendedSQLGrammar() as Boolean:` | No summary.
public | supportsFullOuterJoins `supportsFullOuterJoins() as Boolean:` | No summary.
public | supportsGroupBy `supportsGroupBy() as Boolean:` | No summary.
public | supportsGroupByBeyondSelect `supportsGroupByBeyondSelect() as Boolean:` | No summary.
public | supportsGroupByUnrelated `supportsGroupByUnrelated() as Boolean:` | No summary.
public | supportsIntegrityEnhancementFacility `supportsIntegrityEnhancementFacility() as Boolean:` | No summary.
public | supportsLikeEscapeClause `supportsLikeEscapeClause() as Boolean:` | No summary.
public | supportsLimitedOuterJoins `supportsLimitedOuterJoins() as Boolean:` | No summary.
public | supportsMinimumSQLGrammar `supportsMinimumSQLGrammar() as Boolean:` | No summary.
public | supportsMixedCaseIdentifiers `supportsMixedCaseIdentifiers() as Boolean:` | No summary.
public | supportsMixedCaseQuotedIdentifiers `supportsMixedCaseQuotedIdentifiers() as Boolean:` | No summary.
public | supportsMultipleOpenResults `supportsMultipleOpenResults() as Boolean:` | No summary.
public | supportsMultipleResultSets `supportsMultipleResultSets() as Boolean:` | No summary.
public | supportsOpenCursorsAcrossCommit `supportsOpenCursorsAcrossCommit() as Boolean:` | No summary.
public | supportsOpenCursorsAcrossRollback `supportsOpenCursorsAcrossRollback() as Boolean:` | No summary.
public | supportsOpenStatementsAcrossCommit `supportsOpenStatementsAcrossCommit() as Boolean:` | No summary.
public | supportsOpenStatementsAcrossRollback `supportsOpenStatementsAcrossRollback() as Boolean:` | No summary.
public | supportsOrderBy `supportsOrderBy() as Boolean:` | No summary.
public | supportsOrderByUnrelated `supportsOrderByUnrelated() as Boolean:` | No summary.
public | supportsOuterJoins `supportsOuterJoins() as Boolean:` | No summary.
public | supportsPositionedDelete `supportsPositionedDelete() as Boolean:` | No summary.
public | supportsPositionedUpdate `supportsPositionedUpdate() as Boolean:` | No summary.
public | supportsResultSetConcurrency `supportsResultSetConcurrency(type as ResultSetType, concurrency as ResultSetConcurrency) as Boolean:` | No summary.
public | supportsResultSetType `supportsResultSetType(type as ResultSetType) as Boolean:` | No summary.
public | supportsSchemasInDataManipulation `supportsSchemasInDataManipulation() as Boolean:` | No summary.
public | supportsSchemasInIndexDefinitions `supportsSchemasInIndexDefinitions() as Boolean:` | No summary.
public | supportsSchemasInPrivilegeDefinitions `supportsSchemasInPrivilegeDefinitions() as Boolean:` | No summary.
public | supportsSchemasInProcedureCalls `supportsSchemasInProcedureCalls() as Boolean:` | No summary.
public | supportsSchemasInTableDefinitions `supportsSchemasInTableDefinitions() as Boolean:` | No summary.
public | supportsSelectForUpdate `supportsSelectForUpdate() as Boolean:` | No summary.
public | supportsSubqueriesInComparisons `supportsSubqueriesInComparisons() as Boolean:` | No summary.
public | supportsSubqueriesInExists `supportsSubqueriesInExists() as Boolean:` | No summary.
public | supportsSubqueriesInIns `supportsSubqueriesInIns() as Boolean:` | No summary.
public | supportsSubqueriesInQuantifieds `supportsSubqueriesInQuantifieds() as Boolean:` | No summary.
public | supportsTableCorrelationNames `supportsTableCorrelationNames() as Boolean:` | No summary.
public | supportsTransactionIsolationLevel `supportsTransactionIsolationLevel(level as TransactionIsolation) as Boolean:` | No summary.
public | supportsUnion `supportsUnion() as Boolean:` | No summary.
public | supportsUnionAll `supportsUnionAll() as Boolean:` | No summary.
public | systemFunctions `systemFunctions() as String:` | No summary.
public | tableTypes `tableTypes() as ResultSet throws SQLException:` | Reads SQL metadata.
public | tables `tables(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", types as ArrayList<String> = null) as ResultSet throws SQLException:` | No summary.
public | typeInfo `typeInfo() as ResultSet throws SQLException:` | Reads SQL metadata.
public | updatesAreDetected `updatesAreDetected(type as ResultSetType) as Boolean:` | No summary.
public | usesLocalFilePerTable `usesLocalFilePerTable() as Boolean:` | No summary.
public | usesLocalFiles `usesLocalFiles() as Boolean:` | No summary.

Inherited Methods
method Inherited Methods from DatabaseMetaData: catalogs, columns, exportedKeys, functions, importedKeys, indexes, primaryKeys, procedures, schemas, tableTypes, tables, typeInfo