Re: [GENERAL] Auto-increment Numeric Primary keys

2000-06-18 Thread Brett W. McCoy
On Sun, 18 Jun 2000, Vipin Samtani wrote: > 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 impl

Re: [GENERAL] Auto-increment Numeric Primary keys

2000-06-18 Thread Mike Mascari
Vipin Samtani wrote: > > 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 PostgreS

[GENERAL] Auto-increment Numeric Primary keys

2000-06-18 Thread Vipin Samtani
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