how to see the definition or sql code of function() in postgresql? [duplicate]

Question

I am learning postgresql.

I created a function and it works properly as it is called. However I do have trouble with looking back the sql code.

Would you mind helping me to find a solution ?

GMB · Accepted Answer · 2019-02-25 12:25:54Z

1

select proname, prosrc from pg_proc where proname= 'my_function';

Or from the psql terminal, use the \sf command :

\sf my_function

answered Feb 25, 2019 at 2:32

GMB

224k25 gold badges103 silver badges151 bronze badges

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

1 Comment

@LaurenzAlbe : right ! I edited my answer, thanks for pointing this out.