Re: psql -l

On Tue, Jul 17, 2001 at 09:26:02PM +0200, Peter Eisentraut wrote:
> will trillich writes:
>
> > in the old days (7.0.3) i could list databases via
> >
> > psql -l
> >
> > but these days (7.1) i must
> >
> > psql -l [-d] nameOfADatabaseFromPreordainedKnowledge
> >
> > probably because of some fuxnored setting. but which?
>
> Evidence please?

this was 7.0.3, as it'll tell you:

$ psql -V
psql (PostgreSQL) 7.0.3
contains readline, history, multibyte support
Portions Copyright (c) 1996-2000, PostgreSQL, Inc
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

$ psql -l
List of databases
Database | Owner | Encoding
-----------+----------+----------
admin | rdt | LATIN1
agf | will | LATIN1
camp | rdt | LATIN1
ed | will | LATIN1
gunk | will | LATIN1
puz | will | LATIN1
secsed | will | LATIN1
template1 | postgres | LATIN1
testorama | will | LATIN1
tharp | rdt | LATIN1
tips | will | LATIN1
will | will | LATIN1
(12 rows)

but with v 7.1 i get

$ psql -V
No database specified
$ psql -l
No database specified
$ psql -V mydb
psql (PostgreSQL) 7.1
contains readline, history, multibyte support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
- Tod Steward

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!