Try using a sequence.
"duncanlovett" <duncanlovett@sbisolutions.co.uk> wrote in message
news:135af385.0303140928.641319c4@posting.google.com...
> I have no choice in using postgre for a website i'm currently working
> on and have never used it before. I've used a bit of MySQL in the past
> and know the basics of SQL, enough to set up a db for what i wanted it
> for anyway.
>
> I've been trying to set up a table in postgre which is fine but when
> it comes to making the primary key auto increment i've got stuck. In
> MySQL i used Auto increment when setting up a table, that doesn't seem
> to exist on Postgre.
>
> So the question is, yes i know its got to be the simplest thing ever,
> how do i set up a table with an auto incrementing primary key?
>
> thanks in advance
