Skip site navigation (1) Skip section navigation (2)

Can you please let me know?

From: Gaurav K Srivastav <gauravgkp(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Can you please let me know?
Date: 2010-04-14 13:02:15
Message-ID: q2nbf0617111004140602lb0b83872ha67245441dcd3c5d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Hi Sir,

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.
or
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

Responses

pgsql-bugs by date

Next:From: Pavel StehuleDate: 2010-04-14 13:16:52
Subject: Re: Can you please let me know?
Previous:From: Craig RingerDate: 2010-04-14 11:41:44
Subject: Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)

pgsql-general by date

Next:From: Andre LopesDate: 2010-04-14 13:03:15
Subject: Error in Trigger function. How to correct?
Previous:From: Bill MoranDate: 2010-04-14 12:53:58
Subject: Re: auto vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group