Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > 'psql test </tmp/x' works fine, but 'psql -f /tmp/x test' hangs waiting > > for input from stdin. Why would we want STDIN to read from the terminal > > if all commands are being read from a file with -f? > > Actually, that behavior is extremely useful. Consider > program-that-generates-data | psql -f somescript > The script can issue a COPY FROM STDIN to insert the data coming through > the pipe. > > > I propose we just fix this and document it in the release notes. > > I propose we not break existing applications. If we change it the way > you suggest, there'll be no way to do the above.
But does anyone use such a capability? The program has to generate \. to terminate the input, so why not have it issue the \copy too? Seems cleaner. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
