X-Original-To: pgsql-sql@postgresql.org Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 43B6F474E4F for ; Wed, 19 Mar 2003 07:27:38 -0500 (EST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50] (may be forged)) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h2JGclIs024189; Wed, 19 Mar 2003 14:38:47 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h2JGclds024185; Wed, 19 Mar 2003 14:38:47 -0200 Date: Wed, 19 Mar 2003 14:38:47 -0200 (GMT+2) From: Achilleus Mantzios To: Kyle Cc: pgsql-sql@postgresql.org Subject: Re: Listing Users In-Reply-To: <3E78603C.8090500@ccidomain.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200303/453 X-Sequence-Number: 12492 On Wed, 19 Mar 2003, Kyle wrote: > What is the SQL command to list users? > > CREATE USER, DROP USER, ALTER USER, xxxx USER > > I just can't seem to find the command to list them. SELECT * from pg_user ; > > -Kyle > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr