Suppose I created a function getage(id character varying).
Now Is there any query in postgreSQL that I can retreive the name of all
user difned/system function in the database schema.
like "select VIEW_TYPE_OWNER, VIEW_TYPE, OID_TEXT from user_views" will list
all views in oracle.
select object_name,CREATED,OBJECT_TYPE from user_objects;
so that I can get the name of all objects created in a database schema.
If yes Please help me out or is there any tutorial online please give me URL
for the same.
Thanks & Regards
Gaurav K Srivastav
pgsql-bugs by date
|Next:||From: Pavel Stehule||Date: 2010-04-14 13:16:52|
|Subject: Re: Can you please let me know?|
|Previous:||From: Craig Ringer||Date: 2010-04-14 11:41:44|
|Subject: Re: Bug in CREATE FUNCTION with character type (CONFIRMED
pgsql-general by date
|Next:||From: Andre Lopes||Date: 2010-04-14 13:03:15|
|Subject: Error in Trigger function. How to correct?|
|Previous:||From: Bill Moran||Date: 2010-04-14 12:53:58|
|Subject: Re: auto vacuum|