Forum .LRN Q&A: I need to know all function names.

Collapse
1: I need to know all function names.
Posted by Angel Romero on 07/15/03 02:48 PM
Hi,

I have in my system postgresql 7.3.2 with dotlrn 1.0. I need to know two things:

- All table of my data base only.
- All function of my data base only.(not those of the system).

The first table I obtain it winth query in table "pg_tables". But, the second thing (all function) I don´t find what table I do query.

Somebody knows it.

Thank you for advance.

Angel

Collapse
2: Re: I need to know all function names. (response to 1)
Posted by Jarkko Laine on 07/15/03 02:57 PM
Hey Angel,

Just type '\?' in psql shell, and you'll get all the commands that you might need.

'\dt' lists all the tables
'\d tablename' describes the individual table
'\df' lists all the functions

Leave out the quotes, they're only marking the start and end of the command 😊