Re: Connect without specifying a database? - Mailing list pgsql-general

From lists@mgreg.com
Subject Re: Connect without specifying a database?
Date
Msg-id 0D70885B-55E4-4D9F-8182-F55146C3A10F@mgreg.com
Whole thread Raw
In response to Re: Connect without specifying a database?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general

On Apr 11, 2009, at 1:49 PM, Sam Mason wrote:

As others have said; the design of PG is such that it's built to assume
you're always connected to exactly one database.  I'd guess this is an
artifact from a long time ago when PG didn't have multiple databases.

--
 Sam  http://samason.me.uk/

Yes, I believe that this gets at the heart of some of the issue.  I think there is some confusion on both sides.  Basically, I was under the impression that PG had some overarching database server to which one could connect without needing to specify a database.  While, yes, this might be "unremarkable", it is still an extra constraint for no *obvious* reason.  I could understand if it was an *option* based on the need for security, etc., but the strict enforcement of this paradigm seems a bit dated.  Perhaps the docs make reference as to why, and I simply haven't come across it yet.

That said, "psql" provides me with what I need for now.


Thanks,
Michael

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Connect without specifying a database?
Next
From: Tom Lane
Date:
Subject: Re: Connect without specifying a database?