X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id A2C9E30F5BD for ; Tue, 10 Jun 2003 08:49:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 59863-06 for ; Tue, 10 Jun 2003 05:48:52 -0300 (ADT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id B1206310698 for ; Tue, 10 Jun 2003 04:04:15 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1) id 19PdB1-000Ier-0Y; Tue, 10 Jun 2003 08:04:15 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 417541662D; Tue, 10 Jun 2003 08:04:14 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 8841D16621; Tue, 10 Jun 2003 08:04:13 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: "Guillaume Houssay" , Subject: Re: SQL question Date: Tue, 10 Jun 2003 08:04:10 +0100 User-Agent: KMail/1.4.3 References: <016501c32e8b$4e5522c0$62aa84c3@camille> In-Reply-To: <016501c32e8b$4e5522c0$62aa84c3@camille> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200306100804.10644.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Archive-Number: 200306/337 X-Sequence-Number: 43267 On Monday 09 Jun 2003 2:30 pm, Guillaume Houssay wrote: > I found a way to have the list of all the tables for my database. > > Now, I would like to get the name of the columns of any table. > I could not find the SQL command to do that. > > Thank you for you help In psql there are a number of backslash commands - you might find the=20 following useful: \d \dt \dv \d mytable1 \d my* If you start psql with the -E flag you'll see the SQL that's used to run=20 these. See "man psql" or the manuals for more info. --=20 Richard Huxton