paul simdars <psimdars@lisco.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
