I needed to list all stored procedures on my postgres database. As usual, stack overflow helped: http://stackoverflow.com/questions/1559008/list-stored-functions-using-a-table-in-postgresql:
PS. I am using pgweb to inspect my postgres database, its awesome!