On Fri, Aug 13, 2004 at 13:50:48 -0300, [EMAIL PROTECTED] wrote: > Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now > I'm testing postgres. > In mysql there is a way to make a second autoincrement field, just:
Use serial for the type. You probably want to read up on sequences and the serial type (which is really a macro for an int plus a default based on a sequence) as the semantics are not identical with autoincrement. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster