X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09FFC5E40B0 for ; Fri, 6 Aug 2004 07:05:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17554-04 for ; Fri, 6 Aug 2004 10:05:56 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 334135E4079 for ; Fri, 6 Aug 2004 07:05:51 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i769HK4T006203; Fri, 6 Aug 2004 12:17:20 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i769HKuJ006199; Fri, 6 Aug 2004 12:17:20 +0300 Date: Fri, 6 Aug 2004 12:17:19 +0300 (EEST) From: Achilleus Mantzios To: Antonis Antoniou Cc: pgsql-sql@postgresql.org Subject: Re: retrieve the tables names based on the owner In-Reply-To: <41135508.8040709@albourne.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/38 X-Sequence-Number: 18535 O kyrios Antonis Antoniou egrapse stis Aug 6, 2004 : > Hi guys, Kalhmera Antoni! > > How can I retrieve (with a query) from a database, only the table names > based on the owner name? > SELECT schemaname||'.'||tablename from pg_tables where tableowner='postgres'; > > Many Thanks > Antonis > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- -Achilleus