In another thread (Re: Return value of 'serial' column on insert) Bruno Wolff wrote
...
You can use the currval function to get the id. Normally the sequence will have a name like table_column_seq. In 8.0, there is a function you can use to get the sequence name, which is a bit more robust than hard coding it.
This sounds well useful. How do I find out what the functions available in Postgres 8 are, and what their usage and calling parameters are?
The manuals are online at http://www.postgresql.org/ and come with most installations.
As a quick reminder, you can do "\df foo*" in psql to check functions that start with "foo".
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
