Hi,
At the first time: I'm in newbie in SQL... I'm sorry!
My question is: How can I get the usernames of a group (for example
'osztatlan_users') from SQL?
I try it:
SELECT usename
FROM pg_user
WHERE usesysid IN (SELECT grolist FROM pg_group WHERE
groname='osztatlan_users')
ORDER BY pg_user;
But I get the next error message:
ERROR: operator does not exist: oid = oid[]
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
I see, what is the problem, but what can I do...?
Thans,
kjt
McAfee SCM 4.1 által ellenőrizve!
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
