Re: interactive oddity for psql -c "cmd; cmd;"

> I would think this should echo *two* "INSERT <oid> 1" messages, instead
> of just 1.
>
> % createdb viewsdb
> CREATE DATABASE
> % psql -d viewsdb -c "create table foo(i integer); create table bar(j
> integer);"
> CREATE
> % psql -d viewsdb -c "insert into foo(i) values (1); insert into foo(i)
> values (2);"
> INSERT 9968065 1
> % psql -d viewsdb -c "select * from foo;"
> i
> ---
> 1
> 2
> (2 rows)
>
> % psql -d viewsdb -c "select oid from foo;"
> oid
> ---------
> 9968064
> 9968065
> (2 rows)
>

The query is sent as one string, and only one return is sent back. It
has always been that way.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026