PostgreSQLDatabaseMetaData

classin packageklyn.databases.sql.postgresql

public class PostgreSQLDatabaseMetaData implements DatabaseMetaData, TargetedDatabaseMetaData

All Implemented Interfaces: DatabaseMetaData, TargetedDatabaseMetaData

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.

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	targetedColumns `targetedColumns( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedImportedKeys `targetedImportedKeys( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedIndexes `targetedIndexes( catalog as String, schema as String, tableNames as IList<String>, unique as Boolean ) as ResultSet throws SQLException`	No summary.
public	targetedPrimaryKeys `targetedPrimaryKeys( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedTables `targetedTables( catalog as String, schema as String, tableNames as IList<String>, types as IList<String> ) 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.