| Modifier and Type | Class and Description |
|---|---|
| private static class | |
| private static interface |
| Modifier and Type | Field and Description |
|---|---|
| protected final PostgreSQLDriverKind | |
| private static final ViolatedConstraintNameExtractor | EXTRACTOR
Constraint-name extractor for Postgres constraint violation exceptions.
|
| protected static final DatabaseVersion | |
| private final PostgreSQLDialect. | |
| private final ParameterMarkerStrategy | |
| private final UniqueDelegate |
| Access | Constructor and Description |
|---|---|
| public | |
| public | |
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| public String | addSqlHintOrComment(String sql, QueryOptions queryOptions, boolean commentsEnabled)
Overrides org. |
| public void | appendBinaryLiteral(SqlAppender appender, byte[] bytes)
Overrides org. SqlAppender.
|
| public void | appendBooleanValueString(SqlAppender
The appender, boolean SqlAppender to append the literal expression toThe boolean value bool)Overrides org. SqlAppender.
|
| public void | appendDatetimeFormat(SqlAppender appender, String format)
Overrides org. java. to
whatever pattern language is understood by the
native datetime formatting function for this
database (often the to_char() function).
|
| public void | appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. java.
value to the given SqlAppender.
|
| public void | appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. Date
value to the given SqlAppender.
|
| public void | appendDateTimeLiteral(SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. Calendar
value to the given SqlAppender.
|
| public void | augmentRecognizedTableTypes(List<String> tableTypesList)
Overrides org. |
| public IdentifierHelper | buildIdentifierHelper(IdentifierHelperBuilder
A partially-configured builder, DatabaseMetaData IdentifierHelperBuilder.Access to the metadata returned from the driver if needed and if available dbMetaData)Warning it may be Overrides org. IdentifierHelper indicated by this dialect for handling identifier conversions.
|
| public SQLExceptionConversionDelegate | buildSQLExceptionConversionDelegate()
Overrides org. SQLExceptionConversionDelegate for interpreting
dialect-specific error or
SQLState codes.
|
| public boolean | Returns: true, but only because we can "batch" truncateOverrides org. truncate table
statement accept multiple tables?
|
| protected String | castType(int
The JDBC type code representing the target type sqlTypeCode)Overrides org. cast( ...
|
| protected String | columnType(int
a SQL sqlTypeCode)type codeOverrides org. Types or SqlTypes.
|
| protected void | contributePostgreSQLTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Allow for extension points to override this only |
| public void | contributeTypes(TypeContributions
Callback to contribute the types typeContributions, ServiceRegistry The service registry serviceRegistry)Overrides org. Dialect to contribute types.
|
| public MutationOperation | createOptionalTableUpdateOperation(EntityMutationTarget mutationTarget, OptionalTableUpdate optionalTableUpdate, SessionFactoryImplementor factory)
Overrides org.
Deprecated
as a consequence of
Create a SessionFactoryImplementor being deprecated.
MutationOperation for a updating an optional table
|
| public String | currentTime()
Overrides org. current_time function, which
maps to the Java type java. which is a time with
no time zone.
|
| public String | currentTimestamp()
Overrides org. current_timestamp function,
which maps to the Java type java. which is
a datetime with no time zone.
|
| public String | currentTimestampWithTimeZone()
Overrides org. offset_datetime function, which maps
to the Java type java. which is a datetime
with a time zone.
|
| public Replacer | |
| private static PostgreSQLDialect. | |
| protected void | extractField(StringBuilder pattern, TemporalUnit unit, TemporalType fromTimestamp, TemporalType toTimestamp, TemporalUnit toUnit)
Deprecated
|
| public String | extractPattern(TemporalUnit
the first argument unit)Overrides org. extract() function returns TemporalUnit#DAY_OF_WEEK
numbered from 0 to 6.
|
| public AggregateSupport | getAggregateSupport()
Overrides org. SqlTypes#STRUCT.
|
| public String | getAlterColumnTypeString(String
the name of the column columnName, String the new type of the column columnType, String the full column definition columnDefinition)Overrides org. alter table command which modifies a
column type, or null if column types cannot be modified.
|
| public CallableStatementSupport | getCallableStatementSupport()
Overrides org. CallableStatementSupport for this database.
|
| public String | getCascadeConstraintsString()
Overrides org. drop table operation
should be cascaded to its constraints, typically
" cascade" where the leading space is required, or
the empty string if there is no such keyword in this dialect.
|
| public String | getCaseInsensitiveLike()
Overrides org. LIKE
comparisons.
|
| public String[] | getCreateEnumTypeCommand(String name, String[] values)
Overrides org. |
| public String | getCurrentSchemaCommand()
Overrides org. |
| public String | getCurrentTimestampSelectString()
Overrides org. |
| public int | getDefaultIntervalSecondScale()
Overrides org. SqlTypes. type code for the given column
Usually 9 (nanosecond) or 6 (microseconds). |
| public boolean | getDefaultNonContextualLobCreation()
Overrides org. |
| public int | getDefaultStatementBatchSize()
Overrides org. |
| public String[] | |
| public String | getEnumTypeDeclaration(String name, String[]
the enumerated values of the type values)Overrides org. enum column type,
return the type declaration for the given enumeration of values.
|
| public SqmMultiTableInsertStrategy | getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Overrides org.
Deprecated
as a consequence of
The RuntimeModelCreationContext being deprecated.
SqmMultiTableInsertStrategy to use when not specified by
org..
|
| public SqmMultiTableMutationStrategy | getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Overrides org.
Deprecated
as a consequence of
The RuntimeModelCreationContext being deprecated.
SqmMultiTableMutationStrategy to use when not specified by
org..
|
| public String | getForUpdateNowaitString()
Overrides org. FOR UPDATE NOWAIT syntax specific to this dialect.
|
| public String | getForUpdateNowaitString(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list NOWAIT fragment appropriate
for this dialect, given the aliases of the columns to be write locked.
|
| public String | getForUpdateSkipLockedString()
Overrides org. FOR UPDATE SKIP LOCKED syntax specific to this dialect.
|
| public String | getForUpdateSkipLockedString(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list SKIP LOCKED fragment appropriate
for this dialect, given the aliases of the columns to be write locked.
|
| public String | getForUpdateString(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list fragment appropriate
for this dialect, given the aliases of the columns to be write
locked.
|
| public String | getForUpdateString(String
The columns to be locked. aliases, LockOptions the lock options to apply lockOptions)Overrides org. FOR UPDATE OF or FOR SHARE OF fragment
appropriate for this dialect, given the aliases of the columns
to be locked.
|
| public long | getFractionalSecondPrecisionInNanos()
Overrides org. microsecond is the smallest unit for an interval,
and the highest precision for a timestamp, so we could
use it as the "native" precision, but it's more convenient to use
whole seconds (with the fractional part), since we want to use
extract(epoch from ...) in our emulation of
timestampdiff().
|
| public FunctionalDependencyAnalysisSupport | getFunctionalDependencyAnalysisSupport()
Overrides org. GROUP BY and ORDER BY clauses.
|
| public SelectItemReferenceStrategy | getGroupBySelectItemReferenceStrategy()
Overrides org. group by clause.
|
| public IdentityColumnSupport | getIdentityColumnSupport()
Overrides org. IdentityColumnSupport for this dialect.
|
| public LimitHandler | getLimitHandler()
Overrides org. LimitHandler that implements pagination support for
Query#setMaxResults(int) and Query#setFirstResult(int).
|
| public int | getMaxIdentifierLength()
Overrides org. |
| public int | getMaxVarbinaryLength()
Overrides org. java.-like type.
|
| public int | getMaxVarcharCapacity()
Overrides org. java.-like
column.
|
| public int | getMaxVarcharLength()
Overrides org. java.-like type.
|
| protected DatabaseVersion | getMinimumSupportedVersion()
Overrides org. |
| public NameQualifierSupport | |
| public NationalizationSupport | getNationalizationSupport()
Overrides org. |
| public String | getNativeIdentifierGeneratorStrategy()
Overrides org. |
| public ParameterMarkerStrategy | getNativeParameterMarkerStrategy()
Overrides org. |
| public String | getNoColumnsInsertString()
Overrides org. (), but sometimes default values.
|
| public String | getQueryHintString(String
The query to which to apply the hint. sql, String The hints to apply hints)
Apply a hint to the given SQL query.
|
| public String | getQuerySequencesString()
Overrides org. select command used retrieve the names of all sequences.
|
| public String | getReadLockString(int
in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire READ locks for this dialect.
|
| public String | getReadLockString(String
The columns to be read locked. aliases, int in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire READ locks for this dialect, given the aliases of
the columns to be read locked.
|
| public ResultSet | getResultSet(CallableStatement
The callable statement. ps)Overrides org. registerResultSetOutParameter, extract the
ResultSet from the OUT parameter.
|
| public ResultSet | getResultSet(CallableStatement
The callable statement. statement, int The bind position at which to register the output param. position)Overrides org. registerResultSetOutParameter, extract the
ResultSet from the positional OUT parameter.
|
| public ResultSet | getResultSet(CallableStatement
The callable statement. statement, String The parameter name (for drivers which support named parameters). name)Overrides org. registerResultSetOutParameter, extract the
ResultSet from the named OUT parameter.
|
| public String | getSelectClauseNullString(int
The sqlType, TypeConfiguration Types type code.The type configuration typeConfiguration)Overrides org. select
clause.
|
| public SequenceSupport | getSequenceSupport()
Overrides org. SequenceSupport for this dialect.
|
| public SqlAstTranslatorFactory | getSqlAstTranslatorFactory()
Overrides org. SqlAstTranslatorFactory specific to this dialect, or null
to use the standard translator.
|
| public TimeZoneSupport | getTimeZoneSupport()
Overrides org. Types#TIMESTAMP_WITH_TIMEZONE.
|
| public UniqueDelegate | getUniqueDelegate()
Overrides org. UniqueDelegate supported by this dialect
|
| public ViolatedConstraintNameExtractor | getViolatedConstraintNameExtractor()
Overrides org. Implements org. ViolatedConstraintNameExtractor for extracting the name of
a violated constraint from a SQLException.
|
| public String | getWriteLockString(int
in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire pessimistic WRITE locks for this dialect.
|
| public String | getWriteLockString(String
The columns to be read locked. aliases, int in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire WRITE locks for this dialect, given the aliases of
the columns to be write locked.
|
| public RowLockStrategy | getWriteRowLockStrategy()
Overrides org. |
| public void | initializeFunctionRegistry(FunctionContributions functionContributions)
Overrides org. |
| private static String | |
| public boolean | isCurrentTimestampSelectStringCallable()
Overrides org. getCurrentTimestampSelectString
treated as callable?
|
| public boolean | qualifyIndexName()
Do we need to qualify index names with the schema name?
|
| public String | quoteCollation(String collation)
Overrides org. |
| protected void | registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Overrides org. getMaxVarcharLength(), getMaxNVarcharLength(),
and getMaxVarbinaryLength().
|
| public int | registerResultSetOutParameter(CallableStatement
The callable statement. statement, int The bind position at which to register the output param. col)Overrides org. ResultSet
by position, either an OUT parameter, or a
REF_CURSOR parameter as defined in Java 8.
|
| public boolean | requiresParensForTupleDistinctCounts()
Overrides org. supportsTupleDistinctCounts() is true, does this dialect
require the tuple to be delimited with parentheses?
|
| protected Integer | resolveSqlTypeCode(String columnTypeName, TypeConfiguration typeConfiguration)
Overrides org. SqlTypes type code for the given column
type name as reported by the database, or null
if it can't be resolved.
|
| public JdbcType | resolveSqlTypeDescriptor(String
the column type name columnTypeName, int the jdbcTypeCode, int type codethe precision or 0 precision, int the scale or 0 scale, JdbcTypeRegistry jdbcTypeRegistry)Overrides org. JdbcType to a column of a JDBC
result set based on the column type name, JDBC type code,
precision, and scale.
|
| public String | rowId(String
the name specified by
rowId)org.,
which is ignored if getRowIdColumnString
is not overriddenOverrides org. rowid-like pseudo-column which
acts as a high-performance row locator, or null if
this dialect has no such pseudo-column.
|
| public int | rowIdSqlType()
Overrides org. rowid-like pseudo-column
which acts as a high-performance row locator.
|
| public boolean | supportsAlterColumnType()
Overrides org. |
| public boolean | supportsCaseInsensitiveLike()
Overrides org. LIKE comparisons?
|
| public boolean | supportsCommentOn()
Does this dialect support commenting on tables and columns?
|
| public boolean | supportsCurrentTimestampSelection()
Overrides org. |
| public boolean | supportsDistinctFromPredicate()
Overrides org. distinct from predicate?
|
| public boolean | supportsFetchClause(FetchClauseType
The fetch clause type type)Overrides org. FETCH clause type.
|
| public boolean | supportsIfExistsAfterAlterTable()
Overrides org. alter table, can the phrase if exists be
applied?
|
| public boolean | supportsIfExistsBeforeConstraintName()
Overrides org. alter table statement,
can the phrase if exists be applied before the constraint
name?
|
| public boolean | supportsIfExistsBeforeTableName()
Overrides org. if exists be
applied before the table name?
|
| public boolean | supportsIfExistsBeforeTypeName()
Overrides org. if exists be
applied before the type name?
|
| public boolean | supportsInsertReturning()
Overrides org. insert statement, using native SQL syntax?
|
| public boolean | supportsIsTrue()
Overrides org. is true and is false
operators?
|
| public boolean | supportsJdbcConnectionLobCreation(DatabaseMetaData
JDBC databaseMetaData)DatabaseMetaData which can be used
if LOB creation is supported only starting from
a given driver versionOverrides org. Connection supports creating LOBs via
Connection#createBlob(), Connection#createNClob(), or
Connection#createClob().
|
| public boolean | supportsLateral()
Overrides org. lateral keyword or a
proprietary alternative?
|
| public boolean | supportsLobValueChangePropagation()
Overrides org. |
| public boolean | supportsMaterializedLobAccess()
Overrides org. PreparedStatement#setBytes(int, byte[]),
PreparedStatement#setNString(int, String), or
PreparedStatement#setString(int, String) APIs.
|
| protected boolean | |
| public boolean | supportsNonQueryWithCTE()
Overrides org. |
| public boolean | supportsNoWait()
Overrides org. NO_WAIT timeout.
|
| public boolean | supportsOffsetInSubquery()
Overrides org. offset in subqueries?
|
| public boolean | supportsOuterJoinForUpdate()
Overrides org. FOR UPDATE in conjunction with
outer-joined rows?
|
| public boolean | supportsPartitionBy()
Overrides org. partition by?
|
| public boolean | supportsRecursiveCTE()
Overrides org. |
| public boolean | supportsSkipLocked()
Overrides org. SKIP_LOCKED timeout.
|
| public boolean | supportsStandardArrays()
Overrides org. integer array.
|
| public boolean | supportsTemporalLiteralOffset()
Overrides org. |
| public boolean | supportsTupleCounts()
Overrides org. count(a,b)?
|
| public boolean | supportsUnboundedLobLocatorMaterialization()
Overrides org. |
| public boolean | supportsValuesList()
Overrides org. values lists of form
VALUES (1), (2), (3)?
|
| public boolean | supportsWait()
Overrides org. WAIT timeout.
|
| public boolean | supportsWindowFunctions()
Overrides org. row_number() over (..)?
|
| public String | timestampaddPattern(TemporalUnit
The unit to add to the temporal unit, TemporalType The type of the temporal temporalType, IntervalType The type of interval to add or null if it's not a native interval intervalType)Overrides org. timestampadd() function call.
|
| public String | timestampdiffPattern(TemporalUnit
the first argument unit, TemporalType true if the first argument is
a timestamp, false if a date fromTemporalType, TemporalType true if the second argument is toTemporalType)Overrides org. timestampdiff() function call.
|
| public String | translateExtractField(TemporalUnit unit)
Overrides org. extract() function,
or of this dialect's equivalent
function.
|
| public boolean | useInputStreamToInsertBlob()
Overrides org. PreparedStatement#setBinaryStream).
|
| private static MutationOperation | usingMerge(EntityMutationTarget mutationTarget, OptionalTableUpdate optionalTableUpdate, SessionFactoryImplementor factory)
Deprecated
as a consequence of
SessionFactoryImplementor being deprecated.
|
| private static MutationOperation | withoutMerge(EntityMutationTarget mutationTarget, OptionalTableUpdate optionalTableUpdate, SessionFactoryImplementor factory)
Deprecated
as a consequence of
SessionFactoryImplementor being deprecated.
|
| private String |