return SqlString |
|
SqlString insertSql |
|
string identityColumn |
|
string tableName |
return string |
|
LockMode lockMode |
|
string tableName |
return CaseFragment |
return JoinFragment |
return bool |
|
object obj |
return string |
|
string constraintName |
|
String[] foreignKey |
|
string referencedTable |
|
String[] primaryKey |
return string |
|
string constraintName |
return string |
|
SqlType sqlType |
return string |
|
string sequenceName |
return string |
|
string constraintName |
return string |
|
string constraintName |
return string |
|
string constraintName |
return string |
|
string sequenceName |
return string |
|
string tableName |
return string |
|
string aliases |
return string |
|
string aliases |
return string |
|
LockMode lockMode |
return int |
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.
return string |
|
string identityColumn |
not used |
string tableName |
not used |
return string |
|
string sequenceName |
return Type |
return string |
|
SqlType sqlType |
return string |
|
SqlType sqlType |
|
int length |
return bool |
|
string name |
return string |
|
string aliasName |
return string |
|
string columnName |
return string |
|
string schemaName |
return string |
|
string tableName |
return string |
return String[] |
|
String[] quoted |
return string |
|
string quoted |
return string
|
return bool
|
return bool
|
return Char
|
return IDictionary
|
return bool
|
return string
|
return bool
|
return string
|
return IDictionary
|
return bool
|
To create an identity column it uses the SQL syntaxCREATE TABLE tablename (colname SERIAL);
orCREATE TABLE tablename (colname BIGSERIAL);
return bool
|
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
return string
|
return string
|
return string
|
return int
|
return string
|
INSERT INTO table DEFAULT VALUES;
return string
|
return string
|
return Char
|
return bool
|
return bool
|
return bool
|
return bool
|
return bool
|
return bool
|
return bool
|
return bool
|
return long
|
return bool
|