¿Cómo buscar funciones en toda la base de datos? - Solucionado
Publicado por Guillermo (33 intervenciones) el 11/12/2016 01:50:48
Hola, este truco nos puede ayudar mucho:
--- Truco 1:
SELECT
proname AS functionname,
prosrc AS source
FROM
pg_proc
WHERE
prosrc ~* ‘texto';
http://stackoverflow.com/questions/4448907/search-grep-alike-through-postgresql-functions
--- Truco 2:
select proname,prosrc from pg_proc where prosrc like '%texto%';
http://stackoverflow.com/questions/27257681/search-text-of-all-functions-in-pgadmin
------------------------------
--- Truco 1:
SELECT
proname AS functionname,
prosrc AS source
FROM
pg_proc
WHERE
prosrc ~* ‘texto';
http://stackoverflow.com/questions/4448907/search-grep-alike-through-postgresql-functions
--- Truco 2:
select proname,prosrc from pg_proc where prosrc like '%texto%';
http://stackoverflow.com/questions/27257681/search-text-of-all-functions-in-pgadmin
------------------------------
Valora esta pregunta
0