Good, good, very good! being one of the people who steadfastly avoids PGUSER
and PGPASSWORD for security reasons, it would be nice t be able to do
    $ psql db user < file
As the docs say you can. Would this change also allow the use of:
    $ pg_dump > dumpfile
Which doesn't work when prompting for password, but that can be a stdout
issue.

I would enumerate these issues as the top annoyances with the postgres
client apps. Although I would place them very low compared to being able to
alter/remove columns.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: Bruce Momjian <[EMAIL PROTECTED]>
> Date: Sun, 14 Oct 2001 19:07:25 -0400 (EDT)
> To: PostgreSQL-general <[EMAIL PROTECTED]>
> Subject: [GENERAL] Reading psql password from stdin
> 
> We have recently realized that psql and pg_dump read passwords from
> stdin, rather than from the more traditional /dev/tty.  I would like to
> change the default to /dev/tty and read from stdin only when /dev/tty
> can't be opened.
> 
> Is this good or bad?  I need votes.
> 
> -- 
> Bruce Momjian                        |  http://candle.pha.pa.us
> [EMAIL PROTECTED]               |  (610) 853-3000
> +  If your life is a hard drive,     |  830 Blythe Avenue
> +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> 


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to