Re: newbie question re: primary keys

Try using a sequence.

"duncanlovett" <duncanlovett(at)sbisolutions(dot)co(dot)uk> wrote in message
news:135af385(dot)0303140928(dot)641319c4(at)posting(dot)google(dot)com(dot)(dot)(dot)
> 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