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


---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to