Re: Connect without specifying a database?

On Saturday 11 April 2009 9:10:33 am lists(at)mgreg(dot)com wrote:
> On Apr 11, 2009, at 11:56 AM, Tom Lane wrote:
> > There are, although we don't spell the commands like that. This is
> > not
> > relevant to the question of whether it makes sense to connect without
> > being connected to a specific database. It doesn't, because the
> > catalogs that you have to inspect to find out anything are
> > database-specific.
> >
> > regards, tom lane
>
> I'm sorry, I'm confused by your reply. I may have said "table" when I
> meant "database". I believe it absolutely *does* make sense to
> connect without specifying a database first. What if you hit that
> edge case where there are in fact no databases? I suppose you could
> always run "createdb" just in case before you do anything else, but
> that seems counterintuitive.
>
> What do you mean when you say the "catalogs...are database-
> specific" ? If I'm understanding what you're saying, my whole point
> is that I don't want to be tied to a database to do any kind of
> querying about the PG engine itself. Does that make sense?
>
> Best,
> Michael

Might try looking at the pg_database file in ~/DATADIR/global. It lists the
databases in the cluster.

--
Adrian Klaver
aklaver(at)comcast(dot)net