| From: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com> |
|---|---|
| To: | venkatrao(dot)b(at)tcs(dot)com |
| Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? |
| Date: | 2010-03-05 11:58:01 |
| Message-ID: | 17B1BC76-F252-4FF4-8A6C-7C118A0C7308@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
>
> Hello,
>
> Can any one help me if oracle like any user_source table is there in postgre 8.4 (in pg_catalog or information_schema).
> Actually we migrated code from Oracle to Postgre. Now i want to search in how many places( i.e. in functions ) we have used a particular syntax( e.g. current_date). This can be achieved by using data dictionary view user_source in oracle.
You can look into Body of Function using:
Use \df+ Funtionname
Or
use pg_proc catalog table.
--Vibhor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | venkatrao.b | 2010-03-05 12:04:29 | Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? |
| Previous Message | Thomas Kellerer | 2010-03-05 11:48:17 | Re: Is there any oracle user_source table equivalent in postgre? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | venkatrao.b | 2010-03-05 12:04:29 | Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? |
| Previous Message | Thomas Kellerer | 2010-03-05 11:48:17 | Re: Is there any oracle user_source table equivalent in postgre? |