Property Name | Value
--- | ---
allProceduresAreCallable | true
allTablesAreSelectable | true
dataDefinitionCausesTransactionCommit | false
dataDefinitionIgnoredInTransactions | false
doesMaxRowSizeIncludeBlobs | false
getCatalogSeparator | .
getCatalogTerm | database
getDatabaseMajorVersion | 8
getDatabaseMinorVersion | 0
getDatabaseProductName | PostgreSQL
getDatabaseProductVersion | 8.0.3
getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED
getDriverMajorVersion | 8
getDriverMinorVersion | 0
getDriverName | PostgreSQL Native Driver
getDriverVersion | PostgreSQL 8.0 JDBC3 with SSL (build 311)
getExtraNameCharacters |
getIdentifierQuoteString | "
getJDBCMajorVersion | 3
getJDBCMinorVersion | 0
getMaxBinaryLiteralLength | 0
getMaxCatalogNameLength | 63
getMaxCharLiteralLength | 0
getMaxColumnNameLength | 63
getMaxColumnsInGroupBy | 0
getMaxColumnsInIndex | 32
getMaxColumnsInOrderBy | 0
getMaxColumnsInSelect | 0
getMaxColumnsInTable | 1600
getMaxConnections | 8192
getMaxCursorNameLength | 63
getMaxIndexLength | 0
getMaxProcedureNameLength | 63
getMaxRowSize | 1073741824
getMaxSchemaNameLength | 63
getMaxStatementLength | 0
getMaxStatements | 1
getMaxTableNameLength | 63
getMaxTablesInSelect | 0
getMaxUserNameLength | 63
getProcedureTerm | function
getResultSetHoldability | 1
getSchemaTerm | schema
getSearchStringEscape | \\
getSQLStateType | 2
getURL | jdbc:postgresql://localhost:5432/dbcopy
getUserName | dbcopy
isCatalogAtStart | true
isReadOnly | false
locatorsUpdateCopy | true
nullPlusNonNullIsNull | true
nullsAreSortedAtEnd | false
nullsAreSortedAtStart | false
nullsAreSortedHigh | true
nullsAreSortedLow | false
storesLowerCaseIdentifiers | true
storesLowerCaseQuotedIdentifiers | false
storesMixedCaseIdentifiers | false
storesMixedCaseQuotedIdentifiers | false
storesUpperCaseIdentifiers | false
storesUpperCaseQuotedIdentifiers | false
supportsAlterTableWithAddColumn | true
supportsAlterTableWithDropColumn | true
supportsANSI92EntryLevelSQL | true
supportsANSI92FullSQL | false
supportsANSI92IntermediateSQL | false
supportsBatchUpdates | true
supportsCatalogsInDataManipulation | false
supportsCatalogsInIndexDefinitions | false
supportsCatalogsInPrivilegeDefinitions | false
supportsCatalogsInProcedureCalls | false
supportsCatalogsInTableDefinitions | false
supportsColumnAliasing | true
supportsConvert | false
supportsCoreSQLGrammar | false
supportsCorrelatedSubqueries | true
supportsDataDefinitionAndDataManipulationTransactions | true
supportsDataManipulationTransactionsOnly | false
supportsDifferentTableCorrelationNames | false
supportsExpressionsInOrderBy | true
supportsExtendedSQLGrammar | false
supportsFullOuterJoins | true
supportsGetGeneratedKeys | false
supportsGroupBy | true
supportsGroupByBeyondSelect | true
supportsGroupByUnrelated | true
supportsIntegrityEnhancementFacility | true
supportsLikeEscapeClause | true
supportsLimitedOuterJoins | true
supportsMinimumSQLGrammar | true
supportsMixedCaseIdentifiers | false
supportsMixedCaseQuotedIdentifiers | true
supportsMultipleOpenResults | false
supportsMultipleResultSets | false
supportsMultipleTransactions | true
supportsNamedParameters | false
supportsNonNullableColumns | true
supportsOpenCursorsAcrossCommit | false
supportsOpenCursorsAcrossRollback | false
supportsOpenStatementsAcrossCommit | true
supportsOpenStatementsAcrossRollback | true
supportsOrderByUnrelated | true
supportsOuterJoins | true
supportsPositionedDelete | false
supportsPositionedUpdate | false
supportsSavepoints | true
supportsSchemasInDataManipulation | true
supportsSchemasInIndexDefinitions | true
supportsSchemasInPrivilegeDefinitions | true
supportsSchemasInProcedureCalls | true
supportsSchemasInTableDefinitions | true
supportsSelectForUpdate | true
supportsStatementPooling | false
supportsStoredProcedures | false
supportsSubqueriesInComparisons | true
supportsSubqueriesInExists | true
supportsSubqueriesInIns | true
supportsSubqueriesInQuantifieds | true
supportsTableCorrelationNames | true
supportsTransactions | true
supportsUnion | true
supportsUnionAll | true
usesLocalFilePerTable | false
usesLocalFiles | false