From: | Aidan Van Dyk <aidan(at)highrise(dot)ca> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: psql and named pipes |
Date: | 2008-03-27 17:55:03 |
Message-ID: | 20080327175503.GU6497@yugib.highrise.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Alvaro Herrera <alvherre(at)commandprompt(dot)com> [080327 13:51]:
> Ah! Yeah, I knew that and forgot :-) It's easier than that actually --
> you just need to keep the pipe open in another process. So I can do
> this: first open a terminal with
>
> $ psql -f foo
>
> And then, in another terminal,
>
> $ cat > foo &
> [1] 29155
>
> [1]+ Stopped cat >foo
> $ echo "begin;" > foo
> $ echo "create table a (a int);" > foo
> $ echo "insert into a values (1);" > foo
> $ echo "insert into a values (2);" > foo
> $ echo "insert into a values (3);" > foo
> $ echo "commit;" > foo
> $ echo "select * from a;" > foo
> $ kill %1
> -bash: echo: write error: Appel système interrompu
> [1]+ Complété cat >foo
>
>
> And while this is going on, the other terminal shows the output being
> produced by psql.
>
> Thanks for the reminder :-)
And thanks for the "any open writer" trick. Makes it even easier for me
to keep using named pipes with psql.
--
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2008-03-27 18:28:54 | Re: [PATCHES] CopyReadLineText optimization |
Previous Message | Alvaro Herrera | 2008-03-27 17:51:39 | Re: psql and named pipes |