Locate function in PostgreSQL

Question

I have a PostgreSQL database with 37 schemas and > 500 functions. I'm trying to locate a specific function but am not seeing it when I manually browse the database tree in pgAdmin.

Is there a command in PostgreSQL to locate the schema that a specific function is in?

Thanks.

Either query the catalogs, or use pg_dump --schema-only <dbname> and grep/edit the output. — joop
– joop, Commented Jul 9, 2013 at 16:46

Trent · Accepted Answer · 2013-07-09 16:46:33Z

2

You can use information_schema.routines to do this:

SELECT specific_schema,  specific_catalog, routine_schema, routine_catalog 
FROM  information_schema.routines
WHERE routine_name = 'X' AND routine_type = 'FUNCTION';

answered Jul 9, 2013 at 16:46

Trent

3,1332 gold badges37 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Locate function in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related