Re: Compile query results into a table

On Thu, Jan 16, 2020 at 4:22 PM Santosh Udupi <email(at)hitha(dot)net> wrote:

>
>
> Sample calls to the function:
>
> // select * from dbo. test ('search_in_authors')
>
> // select * from dbo. test ('search_in_authors, search_in_editors')
>
> // select * from dbo. test ('search_in_authors,
> search_in_editors,search_in_publishers ')
>
> -----------------------------------------------------
>
> Are there any options in PostgreSQL to achieve this other than using a
> temp table ?
>

Since the names of the tables are dynamic you would need to use pl/pgsql
and its EXECUTE capability and build up a useful SQL command on-the-fly.
To avoid using temporary tables you would need to put all the separate
queries into the same main query. This can be done with "UNION" and/(or?)
Common Table Expressions (CTE - the WITH clause).

David J.