How to get the full source code of a postgresql function

Question

I am using the following sql to get the definition of a function:

SELECT prosrc FROM pg_proc WHERE proname = 'my_func'

It works good but it doesn't include the create or replace function my_func(args) part, when I want to know the input arguments and output arguments, I have to read the code in the function body, which is not convenient.

So, I would ask how to get the full source code of the function body definition.

Show the code of a function, procedure and trigger in PostgreSQL How do I find the implementation of an aggregate PostgreSQL function? How can I get a list of column definitions of the return type of a table returning function How to read the function body of a Postgres standard-SQL function? Show full stored function or procedure code in PostgreSQL? — Zegarek
– Zegarek, Commented Mar 25, 2024 at 13:27

Yohan Aloka · Accepted Answer · 2024-03-25 10:42:40Z

2

To get the function definition you can use the following query.

select pg_get_functiondef(oid)
from pg_proc
where proname = 'functionname';

answered Mar 25, 2024 at 10:42

Yohan Aloka

1146 bronze badges

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

Collectives™ on Stack Overflow

How to get the full source code of a postgresql function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related