Re: Questions for experts - Mailing list pgsql-sql

From Tom Lane
Subject Re: Questions for experts
Date
Msg-id 24725.1052928133@sss.pgh.pa.us
Whole thread Raw
In response to Questions for experts  (SEB Menard <smenard@avior.ca>)
List pgsql-sql
SEB Menard <smenard@avior.ca> writes:
> I want to perform dynamic SQL update in PL/PGSQL... i don't know the
> name of the columns that i want to update. i just want to update a
> complete line... How i can get the names of the columns of a table in
> PL/PGSQL for produce a dynamic  SQL update? 

Use pltcl, not plpgsql.  This sort of thing is easy in pltcl, hard or
impossible in plpgsql.
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: bad query performance
Next
From: Randall Lucas
Date:
Subject: Re: Type coercion on column in a query