The PostgreSQL82Dialect type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() | PostgreSQL82Dialect |
Methods
Name | Description | |
---|---|---|
![]() | AddIdentitySelectToInsert | (Inherited from PostgreSQL81Dialect.) |
![]() | AppendLockHint | (Inherited from Dialect.) |
![]() | ApplyLocksToSql | (Inherited from Dialect.) |
![]() | CreateCaseFragment |
Create an CaseFragment for this dialect
(Inherited from Dialect.) |
![]() | CreateOuterJoinFragment |
Create an JoinFragment for this dialect
(Inherited from Dialect.) |
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetAddForeignKeyConstraintString | |
![]() | GetAddPrimaryKeyConstraintString |
The syntax used to add a primary key constraint to a table
(Inherited from Dialect.) |
![]() | GetCastTypeName | (Inherited from Dialect.) |
![]() | GetCreateSequenceString | (Inherited from PostgreSQLDialect.) |
![]() | GetDropForeignKeyConstraintString |
The syntax used to drop a foreign key constraint from a table.
(Inherited from Dialect.) |
![]() | GetDropIndexConstraintString |
The syntax used to drop an index constraint from a table.
(Inherited from Dialect.) |
![]() | GetDropPrimaryKeyConstraintString |
The syntax used to drop a primary key constraint from a table.
(Inherited from Dialect.) |
![]() | GetDropSequenceString | (Overrides PostgreSQLDialect..::.GetDropSequenceString(String).) |
![]() | GetDropTableString |
Return SQL needed to drop the named table. May (and should) use
some form of "if exists" clause, and cascade constraints.
(Inherited from Dialect.) |
![]() | GetForUpdateNowaitString | (Inherited from PostgreSQL81Dialect.) |
![]() | GetForUpdateString | Overloaded. |
![]() | GetHashCode | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
![]() | GetIdentitySelectString |
PostgreSQL 8.1 and above defined the fuction lastval() that returns the
value of the last sequence that nextval() was used on in the current session.
Call lastval() if nextval() has not yet been called in the current
session throw an exception.
(Inherited from PostgreSQL81Dialect.) |
![]() | GetLimitString | Overloaded. |
![]() | GetSequenceNextValString | (Inherited from PostgreSQLDialect.) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | GetTypeName | Overloaded. |
![]() | IsQuoted |
Checks to see if the name has been quoted.
(Inherited from Dialect.) |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | Quote |
Quotes a name.
(Inherited from Dialect.) |
![]() | QuoteForAliasName |
Quotes a name for being used as a aliasname
(Inherited from Dialect.) |
![]() | QuoteForColumnName |
Quotes a name for being used as a columnname
(Inherited from Dialect.) |
![]() | QuoteForSchemaName |
Quotes a name for being used as a schemaname
(Inherited from Dialect.) |
![]() | QuoteForTableName |
Quotes a name for being used as a tablename
(Inherited from Dialect.) |
![]() | RegisterColumnType | Overloaded. |
![]() | RegisterFunction | |
![]() | ToString | (Inherited from Object.) |
![]() | UnQuote | Overloaded. |
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.) |