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]