org.sourceforge.jxdbcon.postgresql
Class PGDatabaseMetaDataV6

java.lang.Object
  |
  +--org.sourceforge.jxdbcon.AbstractDatabaseMetaData
        |
        +--org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData
              |
              +--org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaDataV6

All Implemented Interfaces:

DatabaseMetaData, PGConstants

Direct Known Subclasses:

PGDatabaseMetaDataV7

public class PGDatabaseMetaDataV6

extends PGDatabaseMetaData

PGDatabaseMetaDataV6 returns the MetaData specific to PostgreSQL version 6.

Version:

$Revision: 1.5 $

Author:

Keve Müller

Field Summary

Fields inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData

MAX_NAME, nonSQL92Keywords, nonSQL92KeywordsArray, strictSchema, tablesInfix, tablesPostfix, tablesPrefix, tableTypes, version

Fields inherited from class org.sourceforge.jxdbcon.AbstractDatabaseMetaData

CN_ATTRIBUTES, CN_BESTROWIDENTIFIER, CN_CATALOGS, CN_COLUMNPRIVILEGES, CN_COLUMNS, CN_CROSSREFERENCE, CN_EXPORTEDKEYS, CN_IMPORTEDKEYS, CN_INDEXINFO, CN_PRIMARYKEYS, CN_PROCEDURECOLUMNS, CN_PROCEDURES, CN_SCHEMAS, CN_SUPERTABLES, CN_SUPERTYPES, CN_TABLEPRIVILEGES, CN_TABLES, CN_TABLETYPES, CN_TYPEINFO, CN_UDTS, CN_VERSIONCOLUMNS, connection, CT_ATTRIBUTES, CT_BESTROWIDENTIFIER, CT_CATALOGS, CT_COLUMNPRIVILEGES, CT_COLUMNS, CT_CROSSREFERENCE, CT_EXPORTEDKEYS, CT_IMPORTEDKEYS, CT_INDEXINFO, CT_PRIMARYKEYS, CT_PROCEDURECOLUMNS, CT_PROCEDURES, CT_SCHEMAS, CT_SUPERTABLES, CT_SUPERTYPES, CT_TABLEPRIVILEGES, CT_TABLES, CT_TABLETYPES, CT_TYPEINFO, CT_UDTS, CT_VERSIONCOLUMNS, NUMERICFUNCTIONS, STRINGFUNCTIONS, SYSTEMFUNCTIONS, TIMEDATEFUNCTIONS, url

Fields inherited from interface org.sourceforge.jxdbcon.postgresql.PGConstants

AUTH_REQ_CRYPT, AUTH_REQ_KRB4, AUTH_REQ_KRB5, AUTH_REQ_MD5, AUTH_REQ_OK, AUTH_REQ_PASSWORD, AUTH_REQ_SCM, NUMERIC_DSCALE_MASK, NUMERIC_NAN, NUMERIC_NEG, NUMERIC_POS, NUMERIC_SIGN_MASK, PG_VERSION_STR, PG_VERSION_STR1, TRIGGER_TYPE_BEFORE, TRIGGER_TYPE_DELETE, TRIGGER_TYPE_INSERT, TRIGGER_TYPE_ROW, TRIGGER_TYPE_UPDATE

Fields inherited from interface java.sql.DatabaseMetaData

attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

Constructor Summary

(package private)

PGDatabaseMetaDataV6(String url, AbstractConnection connection, Object[] version)

Method Summary

ResultSet

getCatalogs() Return the databases from pg_database.

Methods inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaData

allProceduresAreCallable, getBestRowIdentifier, getCatalogTerm, getColumns, getConn, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDefaultTransactionIsolation, getIndexInfo, getMaxCatalogNameLength, getMaxProcedureNameLength, getNumericFunctions, getPrimaryKeys, getProcedureColumns, getProcedures, getProcedureTerm, getSchemaTerm, getSQLKeywords, getStringFunctions, getTablePrivileges, getTables, getTableTypes, getTimeDateFunctions, getTypeInfo, storesLowerCaseIdentifiers, storesUpperCaseIdentifiers, supportsAlterTableWithAddColumn, supportsBatchUpdates, supportsColumnAliasing, supportsDataDefinitionAndDataManipulationTransactions, supportsDataManipulationTransactionsOnly, supportsGroupBy, supportsLikeEscapeClause, supportsMultipleResultSets, supportsMultipleTransactions, supportsOpenCursorsAcrossCommit, supportsOpenCursorsAcrossRollback, supportsOpenStatementsAcrossCommit, supportsOpenStatementsAcrossRollback, supportsResultSetType, supportsStoredProcedures, supportsTransactionIsolationLevel, supportsTransactions, supportsUnion

Methods inherited from class org.sourceforge.jxdbcon.AbstractDatabaseMetaData

allTablesAreSelectable, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, getAttributes, getCatalogSeparator, getColumnPrivileges, getConnection, getCrossReference, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExportedKeys, getExtraNameCharacters, getIdentifierQuoteString, getImportedKeys, getJDBCMajorVersion, getJDBCMinorVersion, getMaxBinaryLiteralLength, getMaxCharLiteralLength, getMaxColumnNameLength, getMaxColumnsInGroupBy, getMaxColumnsInIndex, getMaxColumnsInOrderBy, getMaxColumnsInSelect, getMaxColumnsInTable, getMaxConnections, getMaxCursorNameLength, getMaxIndexLength, getMaxRowSize, getMaxSchemaNameLength, getMaxStatementLength, getMaxStatements, getMaxTableNameLength, getMaxTablesInSelect, getMaxUserNameLength, getResultSetHoldability, getResultSetHoldability, getSchemas, getSearchStringEscape, getSQLStateType, getSuperTables, getSuperTypes, getSystemFunctions, getUDTs, getURL, getUserName, getVersionColumns, insertsAreDetected, isCatalogAtStart, isReadOnly, locatorsUpdateCopy, nullPlusNonNullIsNull, nullsAreSortedAtEnd, nullsAreSortedAtStart, nullsAreSortedHigh, nullsAreSortedLow, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, storesLowerCaseQuotedIdentifiers, storesMixedCaseIdentifiers, storesMixedCaseQuotedIdentifiers, storesUpperCaseQuotedIdentifiers, supportsAlterTableWithDropColumn, supportsANSI92EntryLevelSQL, supportsANSI92FullSQL, supportsANSI92IntermediateSQL, supportsCatalogsInDataManipulation, supportsCatalogsInIndexDefinitions, supportsCatalogsInPrivilegeDefinitions, supportsCatalogsInProcedureCalls, supportsCatalogsInTableDefinitions, supportsConvert, supportsConvert, supportsCoreSQLGrammar, supportsCorrelatedSubqueries, supportsDifferentTableCorrelationNames, supportsExpressionsInOrderBy, supportsExtendedSQLGrammar, supportsFullOuterJoins, supportsGetGeneratedKeys, supportsGroupByBeyondSelect, supportsGroupByUnrelated, supportsIntegrityEnhancementFacility, supportsLimitedOuterJoins, supportsMinimumSQLGrammar, supportsMixedCaseIdentifiers, supportsMixedCaseQuotedIdentifiers, supportsMultipleOpenResults, supportsNamedParameters, supportsNonNullableColumns, supportsOrderByUnrelated, supportsOuterJoins, supportsPositionedDelete, supportsPositionedUpdate, supportsResultSetConcurrency, supportsResultSetHoldability, supportsSavepoints, supportsSchemasInDataManipulation, supportsSchemasInIndexDefinitions, supportsSchemasInPrivilegeDefinitions, supportsSchemasInProcedureCalls, supportsSchemasInTableDefinitions, supportsSelectForUpdate, supportsStatementPooling, supportsSubqueriesInComparisons, supportsSubqueriesInExists, supportsSubqueriesInIns, supportsSubqueriesInQuantifieds, supportsTableCorrelationNames, supportsUnionAll, toString, updatesAreDetected, usesLocalFilePerTable, usesLocalFiles

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

PGDatabaseMetaDataV6

PGDatabaseMetaDataV6(String url,
                     AbstractConnection connection,
                     Object[] version)

Method Detail

getCatalogs

public ResultSet getCatalogs()
                      throws SQLException

Return the databases from pg_database.

Specified by:

getCatalogs in interface DatabaseMetaData

Specified by:

getCatalogs in class PGDatabaseMetaData

Returns:

SELECT datname AS TABLE_CAT FROM pg_database

SQLException