Re: Difference between ROLE and USER1 - Mailing list pgsql-admin

Philippe Salama <karebacnyc@yahoo.com> writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from USER

Users are the same thing as roles, pretty much.  A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call groups.  You can find more about that in the docs:
http://www.postgresql.org/docs/8.1/interactive/user-manag.html

BTW, not to be impolite, but day-zero questions belong on pgsql-novice
not pgsql-admin.

            regards, tom lane