Postgresql Procedure get return schema

Question

I'm looking for a way to get the return schema of a procedure in Postgresql. So for example, if the procedure returns a select from a table, it would be that particular result. So similar to the information schema to see the table columns, I need to see the columns returned in a procedure.

Laurenz Albe · Accepted Answer · 2019-09-21 19:10:31Z

2

That information is in the proallargtypes and proargmodes columns of the pg_proc catalog table.

The output parameters (which are the result columns) will have an o or b in proargmodes.

If it is a function that is not declared with output parameters, then the result type is found in the prorettype column. If that is a composite type, its columns will be found in pg_attribute.

answered Sep 21, 2019 at 19:10

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

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

Collectives™ on Stack Overflow

Postgresql Procedure get return schema

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