> shishaozhong@gmail.com wrote:
>
> I do not know what happened.
>
> psql does not provide proper response anymore.
>
> I typed the following and see nothing.
>
> user=# select * from boundaryline.scotland_and_wales_const_region
> user-#
>
> Can anyone enlighten me?
This happens to me all too frequently. Then I kick myself and realize that I earlier said “\o spool.txt” (by hand) and
forgotto turn it off with the bare “\o”. This is my typical use case:
\o spool.txt
\i script.sql
The script causes an error. I read it, see the bad statement, and then type the correct statement by hand. Then I see
whatyou did: a big fat nothing.
Might this be happening to you?