Postgres Pro
Downloads
Home   >   mailing lists

Get the last inserted id - Mailing list pgsql-sql

From Nacef LABIDI
Subject Get the last inserted id
Date
Msg-id f16f7ea00804111023xc2072ddk796b1e0336c14aac@mail.gmail.com
Whole thread Raw
Responses Re: Get the last inserted id  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Get the last inserted id  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Get the last inserted id  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
Tree view
Hi all,
 
I was wondering if postgres can return the last ID inserted for a table which the primary key is autoincremented. I need to retrieve this ID in my code to continue processing on that inserted row.
 
Thanks to all

pgsql-sql by date:

Previous
From: Erik Jones
Date:
Subject: Re: Testing for null record in plpgsql
Next
From: "Scott Marlowe"
Date:
Subject: Re: Get the last inserted id