Support for auto-increment column
PostgreSQL supports the auto-increment column with the following
two methods:
-
Method 1: GetIdentity=’Select
currval(”GEN_&TableName”)’ -
Method 2: GetIdentity=’Select
currval(”&TableName._&ColumnName._seq’)’Method 2 uses the serial to create the auto-increment
column.
These methods require that the sequence name follows the name
conversions specified by GetIdentity in pbodb.ini, for example,
gen_TableName,
TableName_ColumnName_seq. If
the sequence name is not in the required format, the identity value
cannot be obtained automatically.
These methods also require that the DelimitIdentifier property
(“Enclose Table and Column Names in Quotes” option) set to NO. If it is
set to YES, the identity value cannot be returned.