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 |
