Received: from dozer.computec.de (unknown [212.123.108.12]) by postgresql.org (Postfix) with ESMTP id 04BE347545D for ; Fri, 1 Mar 2002 04:53:43 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.4712.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: SQL statement : list table details Date: Fri, 1 Mar 2002 10:54:02 +0100 Message-ID: <2266D0630E43BB4290742247C89105758DCAB6@dozer.computec.de> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [GENERAL] SQL statement : list table details Thread-Index: AcHAwMyl2InYUiM+R0mSD5Q6xbAbuAARfHig From: "Marc Polatschek" To: X-Archive-Number: 200203/2 X-Sequence-Number: 21388 Im using this one SELECT pg_class.relname AS table_name, pg_attribute.attname AS column_name, pg_type.typname AS data_type FROM pg_class, pg_attribute, pg_type WHERE pg_class.relfilenode =3D pg_attribute.attrelid AND pg_type.oid =3D pg_attribute.atttypid AND pg_class.relname not like 'pg_%' AND pg_attribute.atttypmod > 0 AND pg_class.reltype > 0 ORDER BY pg_class.relname, pg_attribute.attname