Search in code

Vitaly Belman <vitalyb@gmail.com> writes:

In Oracle I was used to be able to search directly in code from SQL
Navigator (I'm not sure if it is a feature of the database or the
tool). It means that I could search if a certain string appears in one
of the functions (across different schemas/packages).

You mean something like

select proname, prosrc from pg_proc where prosrc ~ 'word';

? A little less polished than Oracle's tool, no doubt ...

regards, tom lane