Database features

FeatureSupported
allProceduresAreCallabletrue
allTablesAreSelectabletrue
isReadOnlyfalse
nullsAreSortedHightrue
nullsAreSortedLowfalse
nullsAreSortedAtStartfalse
nullsAreSortedAtEndfalse
usesLocalFilesfalse
usesLocalFilePerTablefalse
supportsMixedCaseIdentifiersfalse
storesUpperCaseIdentifiersfalse
storesLowerCaseIdentifierstrue
storesMixedCaseIdentifiersfalse
supportsMixedCaseQuotedIdentifierstrue
storesUpperCaseQuotedIdentifiersfalse
storesLowerCaseQuotedIdentifiersfalse
storesMixedCaseQuotedIdentifiersfalse
supportsAlterTableWithAddColumntrue
supportsAlterTableWithDropColumntrue
nullPlusNonNullIsNulltrue
supportsConvertfalse
supportsTableCorrelationNamestrue
supportsDifferentTableCorrelationNamesfalse
supportsExpressionsInOrderBytrue
supportsOrderByUnrelatedtrue
supportsGroupBytrue
supportsGroupByUnrelatedtrue
supportsGroupByBeyondSelecttrue
supportsLikeEscapeClausetrue
supportsMultipleResultSetsfalse
supportsMultipleTransactionstrue
supportsNonNullableColumnstrue
supportsMinimumSQLGrammartrue
supportsCoreSQLGrammarfalse
supportsExtendedSQLGrammarfalse
supportsANSI92EntryLevelSQLtrue
supportsANSI92IntermediateSQLfalse
supportsANSI92FullSQLfalse
supportsIntegrityEnhancementFacilityfalse
supportsOuterJoinstrue
supportsFullOuterJoinstrue
supportsLimitedOuterJoinstrue
isCatalogAtStarttrue
supportsSchemasInDataManipulationtrue
supportsSchemasInProcedureCallstrue
supportsSchemasInTableDefinitionstrue
supportsSchemasInIndexDefinitionstrue
supportsSchemasInPrivilegeDefinitionstrue
supportsCatalogsInDataManipulationfalse
supportsCatalogsInProcedureCallsfalse
supportsCatalogsInTableDefinitionsfalse
supportsCatalogsInIndexDefinitionsfalse
supportsCatalogsInPrivilegeDefinitionsfalse
supportsPositionedDeletefalse
supportsPositionedUpdatefalse
supportsSelectForUpdatetrue
supportsStoredProceduresfalse
supportsSubqueriesInComparisonstrue
supportsSubqueriesInExiststrue
supportsSubqueriesInInstrue
supportsSubqueriesInQuantifiedstrue
supportsCorrelatedSubqueriestrue
supportsUniontrue
supportsUnionAlltrue
supportsOpenCursorsAcrossCommitfalse
supportsOpenCursorsAcrossRollbackfalse
supportsOpenStatementsAcrossCommittrue
supportsOpenStatementsAcrossRollbacktrue
doesMaxRowSizeIncludeBlobsfalse
supportsTransactionstrue
supportsTransactionIsolationLevelfalse
supportsDataDefinitionAndDataManipulationTransactionstrue
supportsDataManipulationTransactionsOnlyfalse
dataDefinitionCausesTransactionCommitfalse
dataDefinitionIgnoredInTransactionsfalse
getMaxBinaryLiteralLength0
getMaxCharLiteralLength0
getMaxColumnNameLength63
getMaxColumnsInGroupBy0
getMaxColumnsInIndex32
getMaxColumnsInOrderBy0
getMaxColumnsInSelect0
getMaxColumnsInTable1600
getMaxConnections8192
getMaxCursorNameLength63
getMaxIndexLength0
getMaxSchemaNameLength63
getMaxProcedureNameLength63
getMaxCatalogNameLength63
getMaxRowSize1073741824
getMaxStatementLength0
getMaxStatements1
getMaxTableNameLength63
getMaxTablesInSelect0
getMaxUserNameLength63
getDefaultTransactionIsolation2
getDatabaseProductNamePostgreSQL
getDatabaseProductVersion7.3.4
getURLjdbc:postgresql://foxridge/test
getUserNamerogo
getDriverNamePostgreSQL Native Driver
getIdentifierQuoteString"
getDriverVersionPostgreSQL 7.3.4 JDBC2 jdbc driver build 113
getDriverMajorVersion7
getDriverMinorVersion3
getSQLKeywordsabort,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
getSchemaTermschema
getProcedureTermfunction
getCatalogTermdatabase
getCatalogSeparator.