Re: BUG #4040: psql should provide option to not prompt for password

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.