Depending on what client side library you are using you could use the RETURNING clause, see the docs: http://www.postgresql.org/docs/8.2/static/sql-insert.html Regards, Ben "Jamie Deppeler" <jamie@xxxxxxxxxxxxxxx> wrote in message news:45EB4F76.6000702@xxxxxxxxxxxxxxxxxx > Hi, > > Have a quick question is possible to record a primary from a insert > stament > > eg > > xprimary := insert into schema.table(.,.,.,.) VALUES (,,,,); > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >