The PostgreSQL81Dialect type exposes the following members.

Properties

  NameDescription
AddColumnString
(Inherited from PostgreSQLDialect.)
BindLimitParametersFirst
Does the LIMIT clause come at the start of the SELECT statement rather than at the end?
(Inherited from Dialect.)
BindLimitParametersInReverseOrder (Inherited from PostgreSQLDialect.)
CascadeConstraintsString (Inherited from PostgreSQLDialect.)
CloseQuote
The closing quote for a quoted identifier.
(Inherited from Dialect.)
DefaultProperties
Retrieve a set of default Hibernate properties for this database.
(Inherited from Dialect.)
DropConstraints
(Inherited from PostgreSQLDialect.)
ForUpdateNowaitString (Overrides Dialect..::.ForUpdateNowaitString.)
ForUpdateOfColumns (Inherited from Dialect.)
ForUpdateString
Retrieves the FOR UPDATE syntax specific to this dialect
(Inherited from Dialect.)
Functions
Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!
(Inherited from Dialect.)
HasAlterTable
Does this dialect support the ALTER TABLE syntax?
(Inherited from Dialect.)
HasDataTypeInIdentityColumn
PostgreSQL doesn't have type in identity column.
(Overrides Dialect..::.HasDataTypeInIdentityColumn.)
IdentityColumnString
PostgreSQL supports serial and serial4 type for 4 bytes integer auto increment column. bigserial or serial8 can be used for 8 bytes integer auto increment column. This dialect uses serial
(Overrides Dialect..::.IdentityColumnString.)
IdentityInsertString
The keyword used to insert a generated value into an identity column (or null)
(Inherited from Dialect.)
LowercaseFunction
The name of the SQL function that transforms a string to lowercase
(Inherited from Dialect.)
MaxAliasLength (Inherited from Dialect.)
MultipleQueriesSeparator
How we seperate the queries when we use multiply queries.
(Inherited from Dialect.)
NoColumnsInsertString
The sql syntax to insert a row without specifying any column in PostgreSQL is INSERT INTO table DEFAULT VALUES;
(Overrides Dialect..::.NoColumnsInsertString.)
NullColumnString
The keyword used to specify a nullable column
(Inherited from Dialect.)
OpenQuote
The opening quote for a quoted identifier.
(Inherited from Dialect.)
QualifyIndexName
Do we need to qualify index names with the schema name?
(Inherited from Dialect.)
SupportsIdentityColumns
PostgreSQL supports Identity column using the "SERIAL" type.
(Overrides Dialect..::.SupportsIdentityColumns.)
SupportsIfExistsAfterTableName
Does the dialect support the syntax 'drop table NAME if exists'
(Inherited from Dialect.)
SupportsIfExistsBeforeTableName
Does the dialect support the syntax 'drop table if exists NAME'
(Inherited from Dialect.)
SupportsLimit (Inherited from PostgreSQLDialect.)
SupportsLimitOffset
Does this Dialect support an offset?
(Inherited from Dialect.)
SupportsSequences (Inherited from PostgreSQLDialect.)
SupportsSubSelects
Does this dialect support subselects?
(Inherited from Dialect.)
SupportsUnique
Does this dialect support the UNIQUE column syntax?
(Inherited from Dialect.)
SupportsVariableLimit
Can parameters be used for a statement containing a LIMIT?
(Inherited from Dialect.)
TimestampResolutionInTicks
Gives the best resolution that the database can use for storing date/time values, in ticks.
(Inherited from Dialect.)
UseMaxForLimit
Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?
(Inherited from Dialect.)

See Also