Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id DD42C47586C for ; Thu, 18 Apr 2002 21:34:47 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 16yNJ8-0004PP-00; Thu, 18 Apr 2002 19:35:26 -0600 Date: Thu, 18 Apr 2002 19:35:26 -0600 From: Roberto Mello To: matt Cc: pgsql-docs@postgresql.org Subject: Re: Getting Metadata Message-ID: <20020419013526.GB16915@cc.usu.edu> References: <008c01c1e73b$b98cbe60$b9d47e82@puckster> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <008c01c1e73b$b98cbe60$b9d47e82@puckster> User-Agent: Mutt/1.3.28i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Archive-Number: 200204/31 X-Sequence-Number: 1356 On Thu, Apr 18, 2002 at 07:47:04PM -0500, matt wrote: > That is how do i access pg_attribute within a program? With a regular SELECT. > Also, are the columns stored in order within pg_attribute? Go into psql and type "\d pg_attribute" like any other table. If you want to see how psql does its internal queries (e.g. when you run '\d table') run psql with the -E switch. -Roberto -- +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer Newsbytes - Microsoft announce EDLIN for Windows.