Postgres function - alias when returning SETOF

Question

I have a function which returns a SETOF text, currently it is returned with the same name as the function.

Is it possible to alias the result returned?

Using an alias will allow me to map the results to a property using Dapper without the need for a custom mapper class.

I've tried to return a single column table but the performance when doing that is 10X slower.

For me I wanted a way to rename jsonb_each.key and jsonb_each.value in SELECT jsonb_each.* FROM foo, jsonb_each(bar) — deed02392
– deed02392, Commented Nov 4, 2021 at 22:17

Laurenz Albe · Accepted Answer · 2020-03-02 07:03:26Z

1

You can assign any name to the result column by using an alias:

SELECT myfun AS othername FROM myfun();

or

SELECT * FROM myfun() AS myfun(othername);

answered Mar 2, 2020 at 7:03

Laurenz Albe

257k22 gold badges311 silver badges387 bronze badges

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

1 Answer 1