As part of the "edit data in the table" work, I would like to make use
of the "rowid" mechanism in databases that provide it. Since I'm working
on this at home, I don't have access to Oracle or any other commercial
DB, so...
Does anyone know of a free DB on Linux that:
- has a pseudo-column containing a unique id for each table row
- makes that pseudo-column name available through getBestRowIdentifier?
I have PostgreSQL, which has a pseudo-column called OID, but the JDBC
driver currently seems to return null for getBestRowIdentifier.
Anyone know of other free DBs that use a "rowid"-like pseudo-column?
Thanks.
Glenn
|