X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0FD05475EE2 for ; Tue, 13 May 2003 17:31:15 -0400 (EDT) Received: from jal.clueinc.net (xd84b436b.ip.e-nt.net [216.75.67.107]) by postgresql.org (Postfix) with ESMTP id 0C9D1475AA9 for ; Tue, 13 May 2003 17:31:14 -0400 (EDT) Received: from jal.clueinc.net (localhost [127.0.0.1]) by jal.clueinc.net (8.12.9/8.12.9/Debian-3) with ESMTP id h4DMUuIE023655 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Tue, 13 May 2003 17:30:56 -0500 Received: (from jal@localhost) by jal.clueinc.net (8.12.9/8.12.9/Debian-3) id h4DMUuXi023653 for pgsql-performance@postgresql.org; Tue, 13 May 2003 17:30:56 -0500 Date: Tue, 13 May 2003 17:30:56 -0500 From: Jamie Lawrence To: pgsql-performance@postgresql.org Subject: Finding filenames for tables Message-ID: <20030513223055.GZ4093@jal.clueinc.net> Mail-Followup-To: pgsql-performance@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Organization: clue inc X-URL: http://www.clueinc.net/ User-Agent: Mutt/1.5.4i X-Spam-Status: No, hits=-12.1 required=5.0 tests=BAYES_10,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/152 X-Sequence-Number: 1931 I must be having a bad search-engine day. How do I join pg_class and pg_database to determine OID/tablename pairs for a given database? I can't find anything to join on in those tables. I'm just grepping output right now, but I'd like to do more complicated things in the future, thus my question. -j -- Jamie Lawrence jal@jal.org