X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B48E747605F for ; Wed, 14 May 2003 11:36:38 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 66804-07 for ; Wed, 14 May 2003 11:36:36 -0400 (EDT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 387FF4763EE for ; Wed, 14 May 2003 11:34:32 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 19FyH2-00076a-0Z; Wed, 14 May 2003 16:34:32 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id AB67F16F38; Wed, 14 May 2003 16:34:31 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 1304016F36; Wed, 14 May 2003 16:34:31 +0100 (BST) Content-Type: text/plain; charset="utf-8" From: Richard Huxton Organization: Archonet Ltd To: SEB Menard , pgsql-sql@postgresql.org Subject: Re: Questions for experts Date: Wed, 14 May 2003 16:34:28 +0100 User-Agent: KMail/1.4.3 References: <1052828144.19880.6.camel@mis-11.avior.ca> In-Reply-To: <1052828144.19880.6.camel@mis-11.avior.ca> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200305141634.28476.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/279 X-Sequence-Number: 13444 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=20 provide their output. There's also a system catalogue section in the manuals --=20 Richard Huxton