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

Поиск
Список
Период
Сортировка
Искать
От
Vibhor Kumar
Тема
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?
Дата
Msg-id
17B1BC76-F252-4FF4-8A6C-7C118A0C7308@gmail.com
Ответ на
Список
Дерево обсуждения
Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Vibhor Kumar <vibhor.aim@gmail.com>
Re: Is there any oracle user_source table equivalent in postgre? Thomas Kellerer <spam_eater@gmx.net>
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Devrim GÜNDÜZ <devrim@gunduz.org>
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? venkatrao.b@tcs.com
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Pavel Stehule <pavel.stehule@gmail.com>
Re: [NOVICE] Is there any oracle user_source table equivalent in postgre? Thomas Kellerer <spam_eater@gmx.net>


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.


You can look into Body of Function using:

Use \df+ Funtionname

Or 

use pg_proc catalog table.

--Vibhor
В списке pgsql-general по дате отправления
От: Thomas Kellerer
Дата:
От: venkatrao.b@tcs.com
Дата:
FAQ