On Saturday 20 September 2003 10:23, you wrote: > On Sat, 2003-09-20 at 06:10, Muhyiddin A.M Hayat wrote: > > How to Create auto_increment field in PostreSQL. > > Can I create them using Trigger. > > Use the SERIAL datatype. See also the functions nextval(), currval() > and setval().
I believe it is better to EXPLICITLY declare a SEQUENCE and set the default value nextval() to the field. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
