Re: psql -l - Mailing list pgsql-general

From will trillich
Subject Re: psql -l
Date
Msg-id 20010717224248.E9630@serensoft.com
Whole thread Raw
In response to Re: psql -l  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: psql -l
Next
From: "Richard Church"
Date:
Subject: Express binary data in standard ANSI SQL