Search Postgresql Archives

Re: psql does not provide proper response

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





čt 20. 1. 2022 v 19:50 odesílatel Bryn Llewellyn <bryn@xxxxxxxxxxxx> napsal:
> shishaozhong@xxxxxxxxx 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?

you are missing to write semicolon - at end of command

you see it in prompt "-#"

Regards

Pavel
 

This happens to me all too frequently. Then I kick myself and realize that I earlier said “\o spool.txt” (by hand) and forgot to 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 what you did: a big fat nothing.

Might this be happening to you?




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux