Hi All,
Quick question: Does PGSQL provide a mechanism by which to connect to
the server without specifying a database? I saw a thread back in 2005
that said "no" (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg00031.php
), but I was curious as to whether that's changed. Basi
On Apr 11, 2009, at 11:39 AM, Raymond O'Donnell wrote:
The answer is still "no". :-)
The usual thing it to connect to the "postgres" database (or to
"template1" in older versions of PG), and then you can issue queries
to
see what's there. You're pretty much guaranteed that one of those
data
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 fi
On Apr 11, 2009, at 12:56 PM, Tom Lane wrote:
There is no such edge case. DROP DATABASE has to be issued while
connected to some database, and it won't let you drop the DB you're
connected to.
And CREATE DATABASE has to be issued while connected to some database,
so createdb still has to have
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/
