Re: How to find out about the functions supported in Postgres - Mailing list pgsql-general

laurie.burrow@powerconv.alstom.com wrote:
> In another thread (Re: [GENERAL] 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