Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?

2010/3/5 <venkatrao(dot)b(at)tcs(dot)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: venkatrao(dot)b(at)tcs(dot)com To: pgsql-novice(at)postgresql(dot)org,
> pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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
>
>
>
>