| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2010-04-14 13:16:52 | Re: Can you please let me know? |
| Previous Message | Craig Ringer | 2010-04-14 11:41:44 | Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Lopes | 2010-04-14 13:03:15 | Error in Trigger function. How to correct? |
| Previous Message | Bill Moran | 2010-04-14 12:53:58 | Re: auto vacuum |