I know Postgres only from hearsay, but this other SO answer says you can have the INSERT statement RETURNING the inserted id, and execute in DBD::Pg shows an example.