create table autoincrement
Hello PG's,
is it possible to create a table with key fields (integer) that will autoincrement
when inserting a dataset???
Thanks for your help in advance!
Best Regards / Un saludo / Mit freundlichen Gr��en
Jos� Manuel Lorenzo L�pez
**********************************************************************
** Jos� Manuel Lorenzo L�pez **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** e-mail to: jose-manuel.lorenzo-lopez@ica.conti.de **
**********************************************************************
--- Jose Manuel Lorenzo Lopez
<jose-manuel.lorenzo-lopez@ica.conti.de> wrote:Hello PG's,
is it possible to create a table with key fields (integer)
that will autoincrement
when inserting a dataset???Thanks for your help in advance!
Try the SERIAL data type.
Brent
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
From: "Jose Manuel Lorenzo Lopez" <jose-manuel.lorenzo-lopez@ica.conti.de>
Hello PG's,
is it possible to create a table with key fields (integer) that will
autoincrement
when inserting a dataset???
Look in the manuals for the CREATE SEQUENCE stuff. There is a special type
SERIAL which does all this for you. Check Bruce's online book too - bound to
have examples in that.
- Richard Huxton