From: Kis János Tamás <kjt@takarnet.hu>
To: pgsql-sql@postgresql.org
Subject: usernames of a group from SQL
Date: Fri, 19 May 2006 10:40:04 +0200
Message-ID: <200605191040.04885.kjt@takarnet.hu> (raw)
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kjt@takarnet.hu
Subject: Re: usernames of a group from SQL
In-Reply-To: <200605191040.04885.kjt@takarnet.hu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox