X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 00A109F9C18 for ; Thu, 18 May 2006 15:41:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 59117-04 for ; Thu, 18 May 2006 15:40:52 -0300 (ADT) X-Greylist: delayed 00:45:58.567597 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B3E5E9F9316 for ; Thu, 18 May 2006 15:40:52 -0300 (ADT) Received: from xrelay04.mail2web.com (xrelay04.mail2web.com [168.144.1.50]) by svr4.postgresql.org (Postfix) with ESMTP id C63065B5EF2 for ; Thu, 18 May 2006 17:54:52 +0000 (GMT) Received: from [168.144.251.106] (helo=M2W005.mail2web.com) by xrelay04.mail2web.com with smtp (Exim 4.50) id 1Fgmi2-00013A-Do for pgsql-admin@postgresql.org; Thu, 18 May 2006 13:54:51 -0400 Message-ID: <380-22006541817540109@M2W005.mail2web.com> X-Priority: 3 Reply-To: ashok@kalculate.com X-Originating-IP: 203.122.31.174 X-URL: http://mail2web.com/ From: "ashok@kalculate.com" To: pgsql-admin@postgresql.org Date: Thu, 18 May 2006 13:54:00 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Subject: find out all users under specific user X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200605/268 X-Sequence-Number: 21800 Hi List, I want to find out all the users under a specific user=2E postgres is a superuser of postgresql, under in postres user i made one user ABC and=20 under this ABC user i made XYZ,MNO,IJK users=2E Now i want to find out all the users, which r exist under in ABC user so what is the query for it=3F plz=2E help me=2E Thanks Ashok =20 -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web=2Ecom/ =2E