Re: How to determine if a user exists..

From: "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to determine if a user exists..
Date: 2001-04-23 13:43:40
Message-ID: Pine.LNX.4.21.0104230841140.27430-100000@morannon.the-infinite.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 23 Apr 2001, Joel Burton wrote:

> pg_user holds users
>
> (passwords in pg_shadow)

I doubt the -hackers people would let me add SPI_* stuff into libpq, just
to retrieve whether a user exists or not.. My first thought was to check
the existance of users against $PGDATA/pg_pwd... One question I'd have
there, is whether pg_pwd always exists (or, can be relied upon existing.)?

--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-04-23 13:48:48 Re: Will something bad happen if I put index on xmin ?
Previous Message Tom Lane 2001-04-23 13:41:26 Re: pg_statistic