org.sourceforge.jxdbcon.postgresql
Class PGDatabaseMetaDataV72

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

All Implemented Interfaces:

DatabaseMetaData, PGConstants

public class PGDatabaseMetaDataV72

extends PGDatabaseMetaDataV71

PGDatabaseMetaDataV72 returns the MetaData specific to PostgreSQL version 7.2

Version:

$Revision: 1.4 $

Author:

Keve Müller

Nested Class Summary

Nested classes inherited from class org.sourceforge.jxdbcon.postgresql.PGDatabaseMetaDataV7

Field Summary

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

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)

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

Method Summary

ResultSet

getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

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

getCatalogs

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

getCrossReference, getExportedKeys, getImportedKeys

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

allProceduresAreCallable, getBestRowIdentifier, getCatalogTerm, 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, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExtraNameCharacters, getIdentifierQuoteString, 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

PGDatabaseMetaDataV72

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

Method Detail

getColumns

public ResultSet getColumns(String catalog,
                            String schemaPattern,
                            String tableNamePattern,
                            String columnNamePattern)
                     throws SQLException

Specified by:

getColumns in interface DatabaseMetaData

Overrides:

getColumns in class PGDatabaseMetaData

SQLException