> How to Create auto_increment field in PostreSQL. Its called the SERIAL datatype:
create table test_table ( field1 serial, constraint test_table_pkey primary key (field1)); > Can I create them using Trigger. Yes, alternatively, but I'm told that is not recommended because the server source code that manages the special sequence table is highly optimized for this specific functionality. ~Berend Tober ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])