Seed

Question

Seed

我推出我的数据库

curl -s http://site/api/seed/user/1000

Test

我这样做了。

psql --username=nm -d portal -h 192.168.1.27 -c "SELECT count(*) from users;"

我

Watch

watch psql --username=nm -d portal -h 192.168.1.27 -c "SELECT count(*) from users;"

我

Every 2.0s: psql --username=nm -d portal -h 192.168.1.27 -...  bh-macbook-pro-15-512gb.local: Tue Nov 21 15:19:08 2017

sh: -c: line 0: syntax error near unexpected token `(                                                                          
sh: -c: line 0: `psql --username=nm -d portal -h 192.168.1.27 -c SELECT count(*) from users;

我如何纠正这一错误?

Answer 1

1. 提供指挥作为单一援引的论点:

watch  psql --username=nm -d portal -h 192.168.1.27 -c "SELECT count(*) from users;"

Answer 2

Use the commande `watch` of psql

One line in terminal

To run everything in one command in your terminal, echo your SQL QUERY with the addition watch at the end and use the pipe | to provide your psql command. If you use the psql command with the argument -c the watch command will not work (the -c necessarily ends with a semicolon ; and therefore the command watch; is not recognized).

echo  YOUR_SQL_QUERY; watch  | psql [your_connection]

例:

echo  SELECT count(*) from users; watch  | psql --username=nm -d portal -h 192.168.1.27

Interactive terminal

To execute the command directly on PostgreSQL interactive terminal of psql, once connected to your database, execute your command and then use the watch command. 例:

SELECT count(*) from users;
watch

Description of the commande `watch`:

watch [ i[nterval]=seconds ] [ c[ount]=times ] [ seconds ]

一再执行目前的盘点缓冲(如 g)直至被打断,或达到执行限额(如果有)。否认处决之间特定数目的二分数(过失2)。对于后向相容性,二者可以与预设装置一起或没有间隔。每个查询结果都有一张头盔,其中包括打字标题(如果有的话)、起立时间以及间隔时间。

来源:。

Seed

Test

Watch

Use the commande watch of psql

One line in terminal

Interactive terminal

Description of the commande watch:

友情链接

Use the commande `watch` of psql

Description of the commande `watch`: