How to watch procedures by request?

Question

PostgreSQL

I can, for example, through dbeaver, find the procedures folder in databases -> schemas-> and then manually find the desired procedure by name and select SQL generation -> DDL .
I would like to speed up this process through a query in which I would insert the name of the procedure and give me a response of the properties that are inside this procedure ...
Is it possible to view through a query to the database what the procedure consists of, if so, what query to write in order to do this look.
Interested in query syntax for MS SQL and postgreSQL

Example

Answer 1

postgresql

SELECT pg_catalog.pg_get_functiondef(pg_proc.oid)
FROM pg_proc
/* любые where по вкусу */

Also known as \sf in psql.