Re: BUG #4040: psql should provide option to not prompt for password - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4040: psql should provide option to not prompt for password
Date
Msg-id 20080317175218.GG4317@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4040: psql should provide option to not prompt for password  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: BUG #4040: psql should provide option to not prompt for password
List pgsql-bugs
Peter Eisentraut wrote:
> Am Montag, 17. März 2008 schrieb Tom Lane:
> > It's not, IMHO.  You don't even know if the local database is where the
> > user is intending to connect to.  Moreover this presupposes some rather
> > obsolete ideas about what connection parameters might need to be given
> > on the command line.
>
> "psql <TAB>" to complete the local database names is a very useful feature
> that has existed and been in use for a long time.

Agreed.  If it can be made to work with remote database when the user
already provided the -h option, even better.  (And while at it,
providing options for -h completion from .pgpass would be neat too.)

BTW while reading the psql manpage I noticed this statement:

       A popular application of this facility is to refer to  the  last
       inserted OID in subsequent statements to build a foreign key
       scenario.

(This refers to :foo interpolation.)  Talking about popular application
of OIDs in FKs seems so 90's.  Should we remove that phrase?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: Martin Pitt
Date:
Subject: Re: BUG #4040: psql should provide option to not prompt for password
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #4040: psql should provide option to not prompt for password