Postgresql commands to display all functions and process/connections based on a database.

[ying_lu]

Hello,

Could someone help tell the commands of the following operation under postgreSQL
please?

.. List all functions have been defined (e.g., defined through pg/sql) within a
database
.. Display all process/connections (similar to show processlist under MySQL)

Thanks in advance,
Ly
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[sklassen]

* yi*****@encs.concordia.ca <yi*****@encs.concordia.ca> [2004-09-28 17:28:25 -0400]:

. List all functions have been defined (e.g., defined through
pg/sql) within a database

SELECT proname FROM pg_proc JOIN pg_language ON (pg_proc.prolang =
pg_language.oid) WHERE pg_language.lanname = 'plpgsql';

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, [phone]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings