Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > global usernames are stored just like before, e.g. postgres
> > local users are stored as user@dbname
> > when connecting, global users add '@' to their names
> > when connecting, local users use just their user name, no @dbname
>
> I'm OK with this in principle. But I must say I was quite confused
> because the "@" symbol appears in diametrically opposite contexts:
>
> a) designate local users on the server
>
> b) designate global users in the client
>
> Perhaps I might have been less confused if meaning (b) used a different
> character, say "username!". This might be equally confusing to the next
> person -- just my observation.
There is no question it is 100% confusing. You are not alone.
What keeps us from unconfusing it is the desire to make local usernames
clean looking, I think.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
