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 B081030F032 for ; Tue, 10 Jun 2003 06:55:43 +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 43215-01 for ; Tue, 10 Jun 2003 03:55:33 -0300 (ADT) Received: from svana.org (svana.org [203.20.62.76]) by svr1.postgresql.org (Postfix) with ESMTP id 8529430E55D for ; Tue, 10 Jun 2003 02:32:50 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 19PbkQ-0001uz-00; Tue, 10 Jun 2003 15:32:42 +1000 Date: Tue, 10 Jun 2003 15:32:42 +1000 From: Martijn van Oosterhout To: Guillaume Houssay Cc: pgsql-general@postgresql.org Subject: Re: SQL question Message-ID: <20030610053242.GC18095@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Guillaume Houssay , pgsql-general@postgresql.org References: <016501c32e8b$4e5522c0$62aa84c3@camille> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="yVhtmJPUSI46BTXb" Content-Disposition: inline In-Reply-To: <016501c32e8b$4e5522c0$62aa84c3@camille> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Archive-Number: 200306/331 X-Sequence-Number: 43261 --yVhtmJPUSI46BTXb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jun 09, 2003 at 03:30:33PM +0200, Guillaume Houssay wrote: > I found a way to have the list of all the tables for my database. >=20 > Now, I would like to get the name of the columns of any table. > I could not find the SQL command to do that. In psql type \? to get a list of all the commands. In particular, \d is what you're looking for. --=20 Martijn van Oosterhout http://svana.org/kleptog/ > "the West won the world not by the superiority of its ideas or values or > religion but rather by its superiority in applying organized violence. > Westerners often forget this fact, non-Westerners never do." > - Samuel P. Huntington --yVhtmJPUSI46BTXb Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+5W16Y5Twig3Ge+YRAhv5AKCPZIL8c4GWSYNsouNlogrQsHLScgCgpGtk 6eOjjehA09CKx/IZsJZrGeQ= =uMov -----END PGP SIGNATURE----- --yVhtmJPUSI46BTXb--