| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | SEB Menard <smenard(at)avior(dot)ca>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Questions for experts |
| Date: | 2003-05-14 15:34:28 |
| Message-ID: | 200305141634.28476.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tuesday 13 May 2003 1:15 pm, SEB Menard wrote:
> 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?
>
> In Oracle UPDATE ...SET ROW do the jobs any substitutes in POSTGRES?
Start psql with the -E flag, then \d etc will show you the queries they run to
provide their output. There's also a system catalogue section in the manuals
--
Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Barwick | 2003-05-14 15:35:18 | Re: Type coercion on column in a query |
| Previous Message | Richard Huxton | 2003-05-14 15:31:48 | Re: Can arrays reference primary keys in CREATE TABLE? |