Philippe Salama <karebacnyc@xxxxxxxxx> 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