simple function for test if somebody is superuser
I needed a small functions:
CREATE OR REPLACE FUNCTION is_superuser(text)
RETURNS boolean AS $$
SELECT EXISTS(SELECT 1 FROM pg_roles WHERE rolname = $1 AND rolsuper);
$$ LANGUAGE sql;
postgres=# SELECT is_superuser('tom');
is_superuser
--------------
f
(1 row)


0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home