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

[ying_lu@encs.concordia.ca]

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@commandprompt.com]

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

* ying_lu@encs.co ncordia.ca <ying_lu@encs.c oncordia.ca> [2004-09-28 17:28:25 -0400]:
[color=blue]
> . List all functions have been defined (e.g., defined through
> pg/sql) within a database[/color]

SELECT proname FROM pg_proc JOIN pg_language ON (pg_proc.prolan g =
pg_language.oid ) WHERE pg_language.lan name = 'plpgsql';

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

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