X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4B74FD1B238 for ; Tue, 18 May 2004 19:02:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 13376-06 for ; Tue, 18 May 2004 19:02:16 -0300 (ADT) Received: from ms-smtp-05.tampabay.rr.com (ms-smtp-05-smtplb.tampabay.rr.com [65.32.5.135]) by svr1.postgresql.org (Postfix) with ESMTP id 97708D1B1CD for ; Tue, 18 May 2004 19:02:12 -0300 (ADT) Received: from joiner (155.14.33.65.cfl.rr.com [65.33.14.155]) by ms-smtp-05.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i4IM2C4F013039 for ; Tue, 18 May 2004 18:02:13 -0400 (EDT) Subject: Re: table column information From: "Scot L. Harris" To: pgsql-php@postgresql.org In-Reply-To: <200405181753.35869.xzilla@users.sourceforge.net> References: <1084749506.2056.148.camel@lathe> <1084789582.27913.7.camel@lamb.mcmillan.net.nz> <1084829504.2059.187.camel@lathe> <200405181753.35869.xzilla@users.sourceforge.net> Content-Type: text/plain Message-Id: <1084917731.2058.293.camel@lathe> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 18 May 2004 18:02:12 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/35 X-Sequence-Number: 2754 On Tue, 2004-05-18 at 17:53, Robert Treat wrote: > A little late to the party, but it seems worth mentioning that this > information is also available in the information_schema, which has the > benefits of being sql complient, stable across releases, and keeps you out of > the system catalogs. for example: > > cms74=# select column_name from information_schema.columns where table_name = > 'current_downloads'; > column_name > ------------- > start_time > entity_id > (2 rows) > > for more on information schema check out > http://www.postgresql.org/docs/7.4/interactive/information-schema.html > > Robert Treat That looks like a nice way to get that information. Thanks for another good tip. -- Scot L. Harris