Package org.springframework.data.relational.core.dialect

Class PostgresDialect

java.lang.Object

org.springframework.data.relational.core.dialect.AbstractDialect

org.springframework.data.relational.core.dialect.PostgresDialect

All Implemented Interfaces:

Dialect

Direct Known Subclasses:

JdbcPostgresDialect, PostgresDialect

public class PostgresDialect
extends AbstractDialect

An SQL dialect for Postgres.

Since:

1.1

Author:

Mark Paluch, Myeonghyeon Lee, Jens Schauder, Nikita Konev, Mikhail Polivakha

Field Summary

Fields

Modifier and Type	Field	Description
static final PostgresDialect	INSTANCE	Deprecated, for removal: This API element is subject to removal in a future version. use either the org.springframework.data.r2dbc.dialect.PostgresDialect or org.springframework.data.jdbc.core.dialect.JdbcPostgresDialect.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	PostgresDialect()

Method Summary

Modifier and Type	Method	Description
ArrayColumns	getArraySupport()	Returns the array support object that describes how array-typed columns should be handled by this dialect.
Collection<Object>	getConverters()	Return a collection of converters for this dialect.
SimpleFunction	getExistsFunction()	Provide a SQL function that is suitable for implementing an exists-query.
IdentifierProcessing	getIdentifierProcessing()	Returns the handling of table- and column names (identifiers) used for processing SqlIdentifier when converting them to SQL snippets or parameter names.
IdGeneration	getIdGeneration()	Returns the IdGeneration used for generating identifiers.
UpsertRenderContext	getUpsertRenderContext()	Returns an UpsertRenderContext for single-statement upsert.
LimitClause	limit()	Return the LimitClause used by this dialect.
LockClause	lock()	Return the LockClause used by this dialect.
Set<Class<?>>	simpleTypes()	Return the Set of types considered store native types that can be handeled by the driver.

Methods inherited from class org.springframework.data.relational.core.dialect.AbstractDialect

getAfterFromTable, getAfterOrderBy, getSelectContext

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.springframework.data.relational.core.dialect.Dialect

getInsertRenderContext, getLikeEscaper, getName, orderByNullHandling, supportsSingleQueryLoading

Field Details

INSTANCE

@Deprecated(forRemoval=true)
public static final PostgresDialect INSTANCE

Deprecated, for removal: This API element is subject to removal in a future version.

use either the org.springframework.data.r2dbc.dialect.PostgresDialect or org.springframework.data.jdbc.core.dialect.JdbcPostgresDialect.

Singleton instance.

Constructor Details

PostgresDialect

protected PostgresDialect()

Method Details

getIdentifierProcessing

public IdentifierProcessing getIdentifierProcessing()

Description copied from interface: Dialect

Returns the handling of table- and column names (identifiers) used for processing SqlIdentifier when converting them to SQL snippets or parameter names.

Returns:

the IdentifierProcessing. Guaranteed to be not null.

getIdGeneration

public IdGeneration getIdGeneration()

Description copied from interface: Dialect

Returns the IdGeneration used for generating identifiers.

Returns:

the IdGeneration used for generating identifiers.

lock

public LockClause lock()

Description copied from interface: Dialect

Return the LockClause used by this dialect.

Returns:

the LockClause used by this dialect.

getArraySupport

public ArrayColumns getArraySupport()

Description copied from interface: Dialect

Returns the array support object that describes how array-typed columns should be handled by this dialect.

Returns:

the array support object that describes how array-typed columns should be handled by this dialect.

getConverters

public Collection<Object> getConverters()

Description copied from interface: Dialect

Return a collection of converters for this dialect.

Returns:

a collection of converters for this dialect.

simpleTypes

public Set<Class<?>> simpleTypes()

Description copied from interface: Dialect

Return the Set of types considered store native types that can be handeled by the driver.

Returns:

never null.

getExistsFunction

public SimpleFunction getExistsFunction()

Description copied from interface: Dialect

Provide a SQL function that is suitable for implementing an exists-query. The default is `COUNT(1)`, but for some databases a LEAST(COUNT(1), 1) might be required, which doesn't get accepted by other databases.

limit

public LimitClause limit()

Description copied from interface: Dialect

Return the LimitClause used by this dialect.

Returns:

the LimitClause used by this dialect.

getUpsertRenderContext

public UpsertRenderContext getUpsertRenderContext()

Description copied from interface: Dialect

Returns an UpsertRenderContext for single-statement upsert.

Returns:

the upsert render context, defaults to standard MERGE.