Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql commands to display all functions and process/connections based on a database. - Mailing list pgsql-general

From sklassen@commandprompt.com
Subject Re: Postgresql commands to display all functions and process/connections based on a database.
Date
Msg-id 20041001094923.A24761@commandprompt.com
Whole thread Raw
In response to Postgresql commands to display all functions and process/connections based on a database.  (ying_lu@encs.concordia.ca)
List pgsql-general
Tree view 
* 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

pgsql-general by date:

Previous
From: "Arnau Rebassa"
Date:
Subject: Random not so random
Next
From: "Ashok......"
Date:
Subject: Arjunt......