2010/3/5 <venkatra...@tcs.com> > > > Thanks Thomas for your reply. > > when i am trying - > > select * from pg_catalog.pg_proc.prosrc >
prosrc is column name do just select prosrc from pg_proc; regards Pavel > 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 > > > >
