Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> I have a faint memory of it being possible to create users
> "inside" *one* given database by way of a particular "create
> user" syntax along the lines of:
> create user newuser(at)thisdb ...;
There is the db_user_namespace kluge^H^H^H^H^Hparameter, but it's
pretty ugly. Do you really need DB-specific user names, or just
a more convenient way to limit which DBs a user can connect to? If
the latter, the "samegroup" technique Philippe mentions seems like
a good bet.
regards, tom lane