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)
Список pgsql-general
Дерево обсуждения


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
Дата:
Сообщение: Re: 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?