Feature | Supported |
---|
allProceduresAreCallable | true |
allTablesAreSelectable | true |
isReadOnly | false |
nullsAreSortedHigh | true |
nullsAreSortedLow | false |
nullsAreSortedAtStart | false |
nullsAreSortedAtEnd | false |
usesLocalFiles | false |
usesLocalFilePerTable | false |
supportsMixedCaseIdentifiers | false |
storesUpperCaseIdentifiers | false |
storesLowerCaseIdentifiers | true |
storesMixedCaseIdentifiers | false |
supportsMixedCaseQuotedIdentifiers | true |
storesUpperCaseQuotedIdentifiers | false |
storesLowerCaseQuotedIdentifiers | false |
storesMixedCaseQuotedIdentifiers | false |
supportsAlterTableWithAddColumn | true |
supportsAlterTableWithDropColumn | true |
nullPlusNonNullIsNull | true |
supportsConvert | false |
supportsTableCorrelationNames | true |
supportsDifferentTableCorrelationNames | false |
supportsExpressionsInOrderBy | true |
supportsOrderByUnrelated | true |
supportsGroupBy | true |
supportsGroupByUnrelated | true |
supportsGroupByBeyondSelect | true |
supportsLikeEscapeClause | true |
supportsMultipleResultSets | false |
supportsMultipleTransactions | true |
supportsNonNullableColumns | true |
supportsMinimumSQLGrammar | true |
supportsCoreSQLGrammar | false |
supportsExtendedSQLGrammar | false |
supportsANSI92EntryLevelSQL | true |
supportsANSI92IntermediateSQL | false |
supportsANSI92FullSQL | false |
supportsIntegrityEnhancementFacility | false |
supportsOuterJoins | true |
supportsFullOuterJoins | true |
supportsLimitedOuterJoins | true |
isCatalogAtStart | true |
supportsSchemasInDataManipulation | true |
supportsSchemasInProcedureCalls | true |
supportsSchemasInTableDefinitions | true |
supportsSchemasInIndexDefinitions | true |
supportsSchemasInPrivilegeDefinitions | true |
supportsCatalogsInDataManipulation | false |
supportsCatalogsInProcedureCalls | false |
supportsCatalogsInTableDefinitions | false |
supportsCatalogsInIndexDefinitions | false |
supportsCatalogsInPrivilegeDefinitions | false |
supportsPositionedDelete | false |
supportsPositionedUpdate | false |
supportsSelectForUpdate | true |
supportsStoredProcedures | false |
supportsSubqueriesInComparisons | true |
supportsSubqueriesInExists | true |
supportsSubqueriesInIns | true |
supportsSubqueriesInQuantifieds | true |
supportsCorrelatedSubqueries | true |
supportsUnion | true |
supportsUnionAll | true |
supportsOpenCursorsAcrossCommit | false |
supportsOpenCursorsAcrossRollback | false |
supportsOpenStatementsAcrossCommit | true |
supportsOpenStatementsAcrossRollback | true |
doesMaxRowSizeIncludeBlobs | false |
supportsTransactions | true |
supportsTransactionIsolationLevel | false |
supportsDataDefinitionAndDataManipulationTransactions | true |
supportsDataManipulationTransactionsOnly | false |
dataDefinitionCausesTransactionCommit | false |
dataDefinitionIgnoredInTransactions | false |
getMaxBinaryLiteralLength | 0 |
getMaxCharLiteralLength | 0 |
getMaxColumnNameLength | 63 |
getMaxColumnsInGroupBy | 0 |
getMaxColumnsInIndex | 32 |
getMaxColumnsInOrderBy | 0 |
getMaxColumnsInSelect | 0 |
getMaxColumnsInTable | 1600 |
getMaxConnections | 8192 |
getMaxCursorNameLength | 63 |
getMaxIndexLength | 0 |
getMaxSchemaNameLength | 63 |
getMaxProcedureNameLength | 63 |
getMaxCatalogNameLength | 63 |
getMaxRowSize | 1073741824 |
getMaxStatementLength | 0 |
getMaxStatements | 1 |
getMaxTableNameLength | 63 |
getMaxTablesInSelect | 0 |
getMaxUserNameLength | 63 |
getDefaultTransactionIsolation | 2 |
getDatabaseProductName | PostgreSQL |
getDatabaseProductVersion | 7.3.4 |
getURL | jdbc:postgresql://foxridge/test |
getUserName | rogo |
getDriverName | PostgreSQL Native Driver |
getIdentifierQuoteString | " |
getDriverVersion | PostgreSQL 7.3.4 JDBC2 jdbc driver build 113 |
getDriverMajorVersion | 7 |
getDriverMinorVersion | 3 |
getSQLKeywords | abort,acl,add,aggregate,append,archive,arch_store,backward,binary,change,cluster,copy,database,delimiter,delimiters,do,extend,explain,forward,heavy,index,inherits,isnull,light,listen,load,merge,nothing,notify,notnull,oids,purge,rename,replace,retrieve,returns,rule,recipe,setof,stdin,stdout,store,vacuum,verbose,version |
getNumericFunctions | |
getStringFunctions | |
getSystemFunctions | |
getTimeDateFunctions | |
getSearchStringEscape | \ |
getExtraNameCharacters | |
getSchemaTerm | schema |
getProcedureTerm | function |
getCatalogTerm | database |
getCatalogSeparator | . |
  |   |
  |   |
  |   |
  |   |