By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
* 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, (503) 667-4564

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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.