Re: getting a list of users

Yep, using that command gives me the error.

I'm using a build that came from the postgres website, and just uses
the config that comes with it.

Eric


On May 9, 2009, at 5:16 PM, Tom Lane wrote:

> Eric Smith <eric_h_smith@mac.com> writes:
>> When I try the command below, I get the very familiar error:
>> "expected
>> just one rule action"
>
> You mean this?
>
> regression=# SELECT usename FROM pg_catalog.pg_user;
> usename
> ----------
> postgres
> (1 row)
>
>
> If you're getting that sort of error from standard views then there is
> something exceedingly broken about your Postgres build.  We have
> occasionally heard from people who got similar errors after installing
> nonstandard hacks that modify the representation of query trees ...
> so is this a completely vanilla build?  Where did you get it from?
>
>             regards, tom lane