Re: Connect without specifying a database?

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