Postgres Pro
Downloads
Home   >   mailing lists

Verifying a user. - Mailing list pgsql-general

From Thomas Hallgren
Subject Verifying a user.
Date
Msg-id ckm5so$smr$1@sea.gmane.org
Whole thread Raw
Responses Re: Verifying a user.  (Michael Fuhr <mike@fuhr.org>)
Re: Verifying a user.  (Steven Klassen <sklassen@commandprompt.com>)
List pgsql-general
Tree view 
I'm connected to a database and I want to verify that a username and
password for some user is correct. I know I can verify a users existence
by doing:

select exists(select * from pg_user where usename = $1)

but I would like to verify the correctness of the password as well. Is
there a way to do that using SQL?

Regards,

Thomas Hallgren

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Date format for bulk copy
Next
From: Michael Fuhr
Date:
Subject: Re: Date format for bulk copy