Thread: Login Roles

Is there a way to check an entered username against a username in the Login Roles?  I did a search and didn't see anything about checking, just creating a Login Role.

Thanks Again

P.S. Sorry for the newbie questions, just started working with Java and Postgresql.

Chris wrote:
> Is there a way to check an entered username against a
> username in the Login Roles?  I did a search and didn't see
> anything about checking, just creating a Login Role.

You can select from the system catalog pg_roles, see

http://www.postgresql.org/docs/8.3/static/view-pg-roles.html

Yours,
Laurenz Albe

Albe Laurenz wrote:
> Chris wrote:
>
>> Is there a way to check an entered username against a
>> username in the Login Roles?  I did a search and didn't see
>> anything about checking, just creating a Login Role.
>>
>
> You can select from the system catalog pg_roles, see
>
> http://www.postgresql.org/docs/8.3/static/view-pg-roles.html
>
> Yours,
> Laurenz Albe
>
Thank You