Re: oids

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 peter_e(at)gmx(dot)net