Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2010/3/5 <venkatrao.b@xxxxxxx>


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.b@xxxxxxx
To: pgsql-novice@xxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
Date: 03/05/2010 05:11 PM
Subject: [NOVICE] Is there any oracle user_source table equivalent in postgre?
Sent by: pgsql-novice-owner@xxxxxxxxxxxxxx






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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux