Re: OID - insert statement

paul simdars <psimdars(at)lisco(dot)com> writes:

> Many tables I am creating have IDs associated with the row. I'm
> wondering what the syntax is for a new id in an insert statement.

Using OIDs for primary keys is a bad idea. Here's the way it's
usually done:

CREATE TABLE mytable (
id SERIAL PRIMARY KEY,
name TEXT
);

INSERT INTO mytable (name) VALUES ('Name of first');
SELECT currval('mytable_id_seq'); -- yields last 'id' value inserted

See the docs for the SERIAL data type, and for CREATE SEQUENCE on
which it's based.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863