X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5E31C4763D2 for ; Tue, 13 May 2003 17:52:36 -0400 (EDT) Received: from smtp.web.de (smtp02.web.de [217.72.192.151]) by postgresql.org (Postfix) with ESMTP id 7C5FF4763C2 for ; Tue, 13 May 2003 17:52:31 -0400 (EDT) Received: from p50818a51.dip0.t-ipconnect.de ([80.129.138.81] helo=web.de) by smtp.web.de with asmtp (TLSv1:RC4-MD5:128) (WEB.DE 4.98 #232) id 19FhhI-0008Kq-00; Tue, 13 May 2003 23:52:32 +0200 Message-ID: <3EC1691D.4050604@web.de> Date: Tue, 13 May 2003 23:52:29 +0200 From: Andreas Pflug User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jamie Lawrence , pgsql-performance@postgresql.org Subject: Re: Finding filenames for tables References: <20030513223055.GZ4093@jal.clueinc.net> In-Reply-To: <20030513223055.GZ4093@jal.clueinc.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-34.4 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,RCVD_IN_NJABL, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA 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/153 X-Sequence-Number: 1932 Jamie Lawrence wrote: >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. > > Jamie, you don't need to join since pg_class is specific for a database. You cannot see any classes from a different database in pg_class. In contrast, pg_database is server-wide mirrored. Regards, Andreas