Thanks Thomas for your reply. when i am trying -
select * from pg_catalog.pg_proc.prosrc i 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: venkatra...@tcs.com To: pgsql-nov...@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-ow...@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
