Best Way to do this in SQL for PosgresSQL and Sqlite

General Programming
2

Also is there a good (easy to use for a non-expert) free Mac GUI Postgres DB creation app?
DBeaver - its fugly ish but connects to everything on the planet since its java based and jdbc adapters exist for pretty much every known db on the planet

In sqlite you can use an autoincrementing field with newer versions

CREATE TABLE table_name(
   column1 INTEGER AUTOINCREMENT,
     .....
);

In Postgresql a SERIAL does this (it ends up creating some other things that tie the column to an autoincrementing sequence)

CREATE TABLE table_name (
   column1 SERIAL,
   ....
);