| 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 |