Re: Connect without specifying a database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "lists(at)mgreg(dot)com" <lists(at)mgreg(dot)com>
Cc: rod(at)iol(dot)ie, pgsql-general(at)postgresql(dot)org
Subject: Re: Connect without specifying a database?
Date: 2009-04-11 15:56:07
Message-ID: 18605.1239465367@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"lists(at)mgreg(dot)com" <lists(at)mgreg(dot)com> writes:
> Hrm...Ok, well, for the record, I'm moving some systems from MySQL to
> Postgres and am in the process of getting familiar with it. I was
> hoping there were some higher level management items like "show
> databases", and "show tables", etc in Postgres as well.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-04-11 15:59:02 Re: Connect without specifying a database?
Previous Message lists@mgreg.com 2009-04-11 15:49:25 Re: Connect without specifying a database?