Postgres Pro
Downloads
Home   >   mailing lists

Validating User - Mailing list pgsql-general

From ShepherdHill DB Subscriptions
Subject Validating User
Date
Msg-id 43B38BFC.7050502@shepherdhill.biz
Whole thread Raw
Responses Re: Validating User
List pgsql-general
Tree view 
Hi,

Please as a superuser how would I obtain an equivalent of this query:

SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd'

I browse the content of the pg_shadow and the passwd field shows
something like md5...

All I am after is to validate a user against pg_shadow table in version
8.0.4.

Cheers.

Olu

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: 'AS' column-alias beign ignored on outer select
Next
From: Matthew Hixson
Date:
Subject: Re: importing an Oracle database into Postgres