Thread: Search in code

Search in code

From

Vitaly Belman

Date:

24 July 2004, 14:00:05

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).

Is there some way to accomplish this in PostgreSQL?

--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe

Re: Search in code

From

Tom Lane

Date:

24 July 2004, 14:38:02

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