Mark writes: > Is there other meanings of oids than unique row identifier?
In normal user tables, OIDs don't mean anything unless you interpret something into them. Nowadays, the advice is usually not to use OIDs, but instead use user-defined sequences. > Can I make two identical tables in the same database (even with oids)? Yes. > Something like this > CREATE TABLE table2 AS (SELECT oid,* FROM table1); This won't work (aside from the syntax error caused by the extra parentheses), because CREATE TABLE will automatically add an oid column in table2, which will interfere with the one from table1. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])