Thanks Thomas for your reply.when i am trying -select * from pg_catalog.pg_proc.prosrci am getting error - cross database reference is not implemented. Also i am not able to see this table under pg_catalog node in pgAdmin tool.Same thing is happening with pg_catalog.pg_views.definition.Can you please suggest, am i missing something.Regards,Venkat| From: | venkatrao.b@tcs.com |
| To: | pgsql-novice@postgresql.org, pgsql-general@postgresql.org |
| Date: | 03/05/2010 05:11 PM |
| Subject: | [NOVICE] Is there any oracle user_source table equivalent in postgre? |
| Sent by: | pgsql-novice-owner@postgresql.org |
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.
thanks in advance...
Venkat=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you