Postgres Pro
Downloads
Home   >   mailing lists

How to autoincrement a primary key... - Mailing list pgsql-sql

From Doug Hyde
Subject How to autoincrement a primary key...
Date
Msg-id 000001c6de7b$3a211c70$6501a8c0@laptop
Whole thread Raw
In response to Re: Group by minute  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: How to autoincrement a primary key...
List pgsql-sql
Tree view 
I am sure this is simple, but I don't get it. I am new to PGSQL, coming from
MySQL - in mysql, you can autoincrement the primary key; in postgre, I am
not sure how to do this. I have read the documentation, and tried "nextval"
as the default - I have searched for the datatype SERIAL, but I am using
navicat and this datatype is not supported. Can someone tell me how to do
this - I just want the integer value for a primary key to autoincrement by
one. 

Thanks,

Doug

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: nested select within a DISTINCT block
Next
From: Richard Broersma Jr
Date:
Subject: Re: How to autoincrement a primary key...