Re: (Mis?)Behavior of \copy with -f and \i

Mark Feit wrote:
> Peter Eisentraut declared that from that point on, stdin would be
> whatever stream the \copy command came from.  I'd like to propose a
> variant on the "FROM" clause which makes good on Peter's declaration
> without breaking anything already using FROM STDIN and expecting it
> to really read from stdin.  (I think this is for the better because
> there are lots of good uses for "psql -f foo.sql < foo.dat".)
>
> I'd be more than happy to write and test a patch if folks think this
> would be a good thing.  I'm leaning toward "FROM -" as the syntax but
> am open to other ideas (i.e., "FROM HERE" or "FROM INPUT").

I'm not sure about the proposed syntax, but the feature sounds quite 
reasonable.