selecting the last record from a table - Mailing list pgsql-general

I have a script that inserts a record into a table and increments the
unique field using nextval('my_sequence'). My problem is once I have
inserted the record, I'd like to select this same record and display it
so that the user knows he has actually inserted the record. I'm
wondering if there's a bit of sql to select the last record.

Thanks for your help,

Mark Tessier