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 4A92A5E4079 for ; Fri, 6 Aug 2004 06:53:10 -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 14481-03 for ; Fri, 6 Aug 2004 09:53:08 +0000 (GMT) Received: from mail1.virtual-email.net (Mail1.virtual-email.net [213.228.203.180]) by svr1.postgresql.org (Postfix) with ESMTP id C290C5E381D for ; Fri, 6 Aug 2004 06:53:04 -0300 (ADT) Received: from mail2.virtual-email.net ([213.228.203.173] RDNS failed) by mail1.virtual-email.net with Microsoft SMTPSVC(6.0.3790.0); Fri, 6 Aug 2004 10:53:05 +0100 Received: from mail4.virtual-email.net ([213.228.203.171]) by mail2.virtual-email.net with Microsoft SMTPSVC(6.0.3790.0); Fri, 6 Aug 2004 10:53:05 +0100 thread-index: AcR7mykKqFEd/zPAQCCRq6dIiLJhNQ== Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 Received: from albourne.com ([213.207.142.99]) by mail4.virtual-email.net with Microsoft SMTPSVC(6.0.3790.0); Fri, 6 Aug 2004 10:52:57 +0100 Message-ID: <41135508.8040709@albourne.com> Date: Fri, 06 Aug 2004 12:53:12 +0300 From: "Antonis Antoniou" User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Subject: retrieve the tables names based on the owner Content-Type: text/plain; format=flowed; charset="us-ascii" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Aug 2004 09:52:58.0111 (UTC) FILETIME=[273468F0:01C47B9B] 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/37 X-Sequence-Number: 18534 Hi guys, How can I retrieve (with a query) from a database, only the table names based on the owner name? Many Thanks Antonis