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

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

* ying_lu@encs.concordia.ca <ying_lu@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, (503) 667-4564