On Wed, 14 Aug 2002, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I have no personal preference between period and @ or whatever. See if
> > you can get some other votes for @ because most left @ when the ORDER BY
> > idea came up from Marc.
>
> FWIW, I still lean to username@database, so I think we're roughly at a
> tie. It would be good to get more votes ...
Seeing as this is rumbling on I'll throw in my fraction of a vote.
I too like the user@database form, partly because it 'reads'. On the other hand
I can see the the reasons to like database.user and it does match the style of
database.schema.object.
Unfortunately for this second form, as '.' is a valid character in a database
name then I can see this causing problems, especially with the behind the
scenes combination of the two names. I don't see this problem with the '@' form
because I can't see that character being used in a 'unqualified' user name.
Hmmm...not sure that makes a terribly good arguement for my vote for 'user@db',
is there a third choice for us confused folks to go for? A
compromise: database@username ?
[BTW, I did check and '@' seems to be a valid character in database and user
names.]
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants