Re: Questions for experts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: SEB Menard <smenard(at)avior(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Questions for experts
Date: 2003-05-14 16:02:13
Message-ID: 24725.1052928133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

SEB Menard <smenard(at)avior(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Randall Lucas 2003-05-14 16:10:17 Re: Type coercion on column in a query
Previous Message Stephan Szabo 2003-05-14 15:50:15 Re: bad query performance