Can anyone explain how this works? - Mailing list pgsql-sql

From RbrtBrn3@aol.com
Subject Can anyone explain how this works?
Date
Msg-id 1e.138d30e8.27fa50a1@aol.com
Whole thread Raw
Responses Re: Can anyone explain how this works?  (Joel Burton <jburton@scw.org>)
List pgsql-sql
<font face="arial,helvetica"><font size="2">Hi, <br /><br />I recently posted this same question a few weeks back but
lostthe reply <br />someone kindly sent. The question again how exactly does this query work: <br /><br />it will
returnall attributes and respective data types of a given table': <br /><br />select attname, typname <br />from
pg_classc, pg_attribute a, pg_type t <br />where relname = relation_name and <br />attrelid = c.oid and <br />atttypid
=t.oid and <br />attnum > 0 <br />order by attnum; <br /><br />Many thanks, <br /><br />Rob Burne.</font></font> 

pgsql-sql by date:

Previous
From: Loïc Bourgeois
Date:
Subject: help
Next
From: Christopher Masto
Date:
Subject: Re: Trigger Function and Html Output