Category "roles"

Create PostgreSQL ROLE (user) if it doesn't exist

How do I write an SQL script to create a ROLE in PostgreSQL 9.1, but without raising an error if it already exists? The current script simply has: CREATE ROLE

How to check if a role exists in Sybase

Anyone know how I can check if a role already exist in a Sybase database ... i have the name of the role There is a sysroles table but no name column! select