Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.9.1/8.9.1) with ESMTP id UAA29524 for ; Tue, 24 Nov 1998 20:48:05 -0500 (EST) (envelope-from reina@nsi.edu) Received: from nsi.edu (IDENT:reina@bigred.nsi.edu [204.128.156.214]) by nsi.edu (8.9.1/8.9.1) with ESMTP id RAA17209; Tue, 24 Nov 1998 17:47:41 -0800 (PST) Sender: reina@nsi.edu Message-ID: <365B623C.2B03BB2E@nsi.edu> Date: Tue, 24 Nov 1998 17:49:48 -0800 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i686) MIME-Version: 1.0 To: dbms dbms , reina@nsi.edu, "pgsql-questions@postgresql.org" Subject: Re: [SQL] Question about schema References: <19981125012036.13087.rocketmail@send201.yahoomail.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit If you just want to know what your table looks like, try: select * from pg_class; To just get the class names, try select relname from pg_class; I'm pretty sure that you can execute this from psql c-commands. -Tony