Specifying them is different between databases.

Getting the new value for later use is different between databases.

For query only -- you shouldn't have a problem.

For postgres use the SERIAL data type and all the magic with sequences and junk is done behind the scenes for you.