postgres

[Anon]

when using postgres is it posiale to grab the last value of a column and increment it by one seeing as postgres's auto_increment is either stupid or noexistant.

[Anon]

Postgres does autoincrement quite well.

Declare the type SERIAL instead of that long string o crap you gotta use in most databases and it works fine, like so:

create table test(
name text,
address text,
user_id serial);

And you've got an autoincrementing field named user_id.

[Anon]

I'd echo the recommendation to use SERIAL; just don't forget that the mechanism PosgreSQL uses to create the serial data type is to create a named sequence.

Given the field specification

create table test( 
    ...
    user_id serial

it will create a sequence named 'test_user_id_seq'; if this name already exists the entire CREATE TABLE statement will fail.