The PostgreSQL82Dialect type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() | 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 | (Inherited from PostgreSQL81Dialect.) |
![]() | 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.
(Inherited from PostgreSQL81Dialect.) |
![]() | 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
(Inherited from PostgreSQL81Dialect.) |
![]() | 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;
(Inherited from PostgreSQL81Dialect.) |
![]() | 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.
(Inherited from PostgreSQL81Dialect.) |
![]() | SupportsIfExistsAfterTableName |
Does the dialect support the syntax 'drop table NAME if exists'
(Inherited from Dialect.) |
![]() | SupportsIfExistsBeforeTableName | (Overrides Dialect..::.SupportsIfExistsBeforeTableName.) |
![]() | 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.) |