Auto-increment Numeric Primary keys

From: "Vipin Samtani" <vipin(at)attglobal(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Auto-increment Numeric Primary keys
Date: 2000-06-18 21:51:33
Message-ID: 00a901bfd96f$60eb64e0$239c6520@default
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I auto-increment numeric primary keys? So on a table called
"Test1" with fields "ID" and "Name" when I do an INSERT, I only type

INSERT INTO Test1 values ('Bob');

instead of

INSERT INTO Test1 values (1, 'Bob');

Is this implemented in PostgreSQL 7?

-Vipin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2000-06-18 22:08:53 Re: Auto-increment Numeric Primary keys
Previous Message Lamar Owen 2000-06-18 18:13:46 Re: Installing clients (psql) only