Re: Determining the names of columns in a dynamic query

On 2009-04-24, Johan Nel <johan555(dot)nel555(at)xsinet555(dot)co(dot)za> wrote:
> Hi,
>
> Sorry for cross posting, but seems nobody read the pgsql.sql NG. Have
> not received any response there so lets see if this create some reaction.
>
> Is it possible in pgsql to have something to manipulate columns where
> the column names will only be resolved during execution of the select
> statement:

no.

> FOR rec IN (SELECT * FROM table)
> LOOP
> -- This is what I would like to do
> FOR col IN (rec.column_names)
> LOOP

> For the above, it does not need to be exactly the same, but are there a
> group of functions available to at least return in a dynamic query the
> number of columns, name of a column given the ordinal number of the
> column, etc?

not in plpgsql, you have to use a different language like plpython,
plperl, or C.