Search for text of all functions in PGAdmin

Using PostgreSQL with pgAdmin , I wondered if there was a way to search ALL database functions for a specific text.

Is it possible?

+6
source share
1 answer

something like this should work:

 select proname,prosrc from pg_proc where prosrc like '%search text%'; 

see How to display a function, procedure, run the source code in postgresql?

+12
source

Source: https://habr.com/ru/post/979009/


All Articles