Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6VF3Tf88086 for ; Tue, 31 Jul 2001 11:03:29 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by finch-post-10.mail.demon.net with esmtp (Exim 2.12 #1) id 15Rb3M-000MGW-0A; Tue, 31 Jul 2001 15:03:25 +0000 Received: from archonet.com (ibook.archonet.com [192.168.1.32]) by mainbox.archonet.com (Postfix) with ESMTP id 34B5C130C4; Tue, 31 Jul 2001 15:56:42 +0100 (BST) Message-ID: <3B66C697.FF4EC81B@archonet.com> Date: Tue, 31 Jul 2001 15:54:15 +0100 From: Richard Huxton X-Mailer: Mozilla 4.7C-CCK-MCD {C-UDP; EBM-APPLE} (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: =?iso-8859-1?Q?Mar=EDa?= Elena =?iso-8859-1?Q?Hern=E1ndez?= Cc: pgsql-sql@postgresql.org Subject: Re: Get name of columns in a table References: <000001c11765$91adb260$82a431ce@hector2> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/389 X-Sequence-Number: 4203 María Elena Hernández wrote: > To get a list of columns, run "psql -E" and do a standard "\df foo" where foo is your table name. This will show you exactly how PG does it. I've found this very useful with all the backslash commands. HTH - Richard Huxton