public class SDriverPostgres extends SDriver
VARCHAR without size means unlimited. No artificial upper size? TEXT has the same behaviour as VARCHAR, apparently.
SDriver.OffsetStrategy
Constructor and Description |
---|
SDriverPostgres() |
Modifier and Type | Method and Description |
---|---|
protected java.lang.String |
columnTypeSQL(SFieldScalar field,
java.lang.String defalt)
Never need to specify byteSize for varchar
|
protected java.lang.String |
createSequenceDDL(java.lang.String name) |
protected java.lang.String |
driverName()
The driver name to be compared to getMetaData().getDriverName()
|
protected java.lang.String |
dropSequenceDDL(java.lang.String name) |
protected long |
generateKeySequence(SRecordMeta<?> rec,
SFieldScalar keyFld)
Specializes SDriver.generateKeySequence using the Postgres SEQUENCEs.
|
protected SDriver.OffsetStrategy |
getOffsetStrategy()
JDBC prefered, if jdbc driver has a sensible scrollable resultset implemntation
QUERY if database would handle it better via some proprietary sql extension (eg.
|
protected java.lang.String |
limitSQL(long offset,
long limit)
Drivers that choose to implement a QUERY offset strategy
should return the limit statment here
|
int |
maxIdentNameLength()
The maximum size for table names and foreign key constraint names.
|
boolean |
supportsKeySequences() |
addNull, alterTableAddColumnSQL, alterTableDropColumnSQL, appendColumnName, appendQuotedIdentifier, appendQuotedIdentifier, appendTableName, clauseSeparator, createTableSQL, deleteSQL, dropTableNoError, foreignKeysSQL, forUpdateSQL, fromSQL, generateKeySelectMax, getLogger, getSession, indexKeySQL, insertSQL, joinSQL, makeForeignKeyIndexSQL, mapForeignKeys, postColumnSQL, postFromSQL, postTablePostParenSQL, postTablePreParenSQL, primaryKeySQL, queryExecuteFactory, registerDriver, selectSQL, selectSQL, supportsLocking, updateSQL, whereSQL, wholeColumnSQL
protected java.lang.String driverName()
SDriver
driverName
in class SDriver
public int maxIdentNameLength()
SDriver
maxIdentNameLength
in class SDriver
protected java.lang.String columnTypeSQL(SFieldScalar field, java.lang.String defalt)
columnTypeSQL
in class SDriver
protected long generateKeySequence(SRecordMeta<?> rec, SFieldScalar keyFld)
generateKeySequence
in class SDriver
public boolean supportsKeySequences()
supportsKeySequences
in class SDriver
protected java.lang.String createSequenceDDL(java.lang.String name)
createSequenceDDL
in class SDriver
protected java.lang.String dropSequenceDDL(java.lang.String name)
dropSequenceDDL
in class SDriver
protected SDriver.OffsetStrategy getOffsetStrategy()
SDriver
Defaults to BULK
getOffsetStrategy
in class SDriver
protected java.lang.String limitSQL(long offset, long limit)
SDriver