public class PostgreSQLDialect extends StandardDialect
Constructor and Description |
---|
PostgreSQLDialect() |
Modifier and Type | Method and Description |
---|---|
protected java.lang.String |
alterIdentityColumnFormat() |
protected java.lang.String |
currentTimestampPattern() |
int |
getColumnType(ColumnProperties properties)
PostgreSQL uses the native type OID to identify BLOBs.
|
java.util.List<java.lang.String> |
getDefaultSchemas(java.sql.DatabaseMetaData metaData)
PostgreSQL uses a schema search path to locate unqualified table names.
|
java.util.regex.Pattern |
getIdentifierPattern(java.sql.DatabaseMetaData metaData)
Versions >=8.1 of the PostgreSQL JDBC driver return incorrect values for DatabaseMetaData.getExtraNameCharacters().
|
protected java.lang.String |
nextSequenceValueFormat() |
protected java.lang.String |
randomPattern() |
protected java.lang.String |
selectForUpdatePattern()
Recognizes FOR SHARE and FOR UPDATE.
|
protected java.lang.String |
sequencePattern() |
protected java.lang.String |
truncateTableFormat() |
alterSequenceFormat, createForeignKeyConstraintFormat, createUniqueConstraintFormat, currentDatePattern, currentTimePattern, currentTimestampFunction, dateLiteralFormat, dropConstraintFormat, dropForeignKeyConstraintFormat, dropUniqueConstraintFormat, dummyTable, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, getAlterIdentityColumnSQL, getAlterSequenceSQL, getCreateForeignKeyConstraintSQL, getCreateUniqueConstraintSQL, getDropForeignKeyConstraintSQL, getDropUniqueConstraintSQL, getNextSequenceValueSQL, getSequences, getSimpleSQL, getTruncateTableSQL, insertIntoTablePattern, isSelectForUpdate, parse, parseInsertTable, parseSequence, sequenceTableType, timeLiteralFormat, timestampLiteralFormat
public PostgreSQLDialect()
public java.util.List<java.lang.String> getDefaultSchemas(java.sql.DatabaseMetaData metaData) throws java.sql.SQLException
getDefaultSchemas
in interface Dialect
getDefaultSchemas
in class StandardDialect
java.sql.SQLException
StandardDialect.getDefaultSchemas(java.sql.DatabaseMetaData)
public int getColumnType(ColumnProperties properties)
getColumnType
in interface Dialect
getColumnType
in class StandardDialect
properties
- table column meta dataStandardDialect.getColumnType(net.sf.hajdbc.ColumnProperties)
public java.util.regex.Pattern getIdentifierPattern(java.sql.DatabaseMetaData metaData) throws java.sql.SQLException
getIdentifierPattern
in interface Dialect
getIdentifierPattern
in class StandardDialect
java.sql.SQLException
StandardDialect.getIdentifierPattern(java.sql.DatabaseMetaData)
protected java.lang.String truncateTableFormat()
truncateTableFormat
in class StandardDialect
StandardDialect.truncateTableFormat()
protected java.lang.String sequencePattern()
sequencePattern
in class StandardDialect
StandardDialect.sequencePattern()
protected java.lang.String nextSequenceValueFormat()
nextSequenceValueFormat
in class StandardDialect
StandardDialect.nextSequenceValueFormat()
protected java.lang.String alterIdentityColumnFormat()
alterIdentityColumnFormat
in class StandardDialect
StandardDialect.alterIdentityColumnFormat()
protected java.lang.String currentTimestampPattern()
currentTimestampPattern
in class StandardDialect
StandardDialect.currentTimestampPattern()
protected java.lang.String randomPattern()
randomPattern
in class StandardDialect
StandardDialect.randomPattern()
protected java.lang.String selectForUpdatePattern()
selectForUpdatePattern
in class StandardDialect
StandardDialect.selectForUpdatePattern()