autoincrement question - Mailing list pgsql-novice

From Jack Albright
Subject autoincrement question
Date
Msg-id 4ED5AEA8-A4A8-4CFF-A23E-A36A3FD506FC@mobiusnm.com
Whole thread Raw
Responses Re: autoincrement question  ("Sean Davis" <sdavis2@mail.nih.gov>)
List pgsql-novice
I'm new to the list and new to postgreSQL.
I usually work in mySQL.
I'm using NaviCat to manipulate my postgreSQL db.

QUESTION:
What is the best way for a novice like me to  make my  primary key ID
column   auto-increment?  It is a basic integer column.

  Also, do I need to set a default value  for my primary keys?

In MySQL (using phpMyAdmin) it's a simple matter of checking a
checkbox. What is the recommended way to do this in postgres?

Thanks,

Jack Albright
jack@mobiusnm.com





pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Command line output - How to output values only?
Next
From: "Sean Davis"
Date:
Subject: Re: autoincrement question