\g [FILE] or ; execute query (and send results to file or |pipe) \h [NAME] help on syntax of SQL commands, * for all commands \q quit psql Query Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with ...
version: 2 jobs: build: docker: - image: your-docker-image steps: - checkout - run: name: Install PostgreSQL client command: apt-get update && apt-get install -y postgresql-client - run: name: Connect to database and execute SQL query command: psql -h your-database-host -U your-us...
\h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit testdb=> 用户可以在这个提示符下键入SQL 查询。 通常,输入的行将在命令终止分号出现时送到服务器。 一行的终止并不结束命令!因此命令可以因清晰起见跨越好几行。如果命...
options show help on psql command-line options \? variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commandsQuery Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit ...
--command command 声明psql 将执行一条查询字串, command,然后退出。这一点在 shell 脚本里很有用。 command 必须是一条完全可以被服务器分析的查询字串(也就是说,它不包含 psql特有的特性), 或者是一个反斜杠命令。这样你就不会混合SQL和 psql 元命令。要想混合使用,你可以把字串定向到 psql里,象这样: ...
You are using psql, the command-line interface to PostgreSQL. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit 可以看到,标准SQL命令的帮助和psql特有命令的帮助是分开的。输入\?查看...
\watch[SEC]execute query every SEC seconds Help \?[commands]show help on backslash commands \?options show help on psql command-line options \?variables show help on special variables \h[NAME]help on syntax of SQL commands,*forall commands Query Buffer \e[FILE][LINE]edit the query buffer(...
\g or terminate with semicolon to execute query \q to quit aoldbs=# eg:查看SQL commands aoldbs=# \h drop table Command: DROP TABLE Description: remove a table Syntax: DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] ...
\watch [SEC] execute query every SEC seconds Help \? [commands] show help on backslash commands \? options show help on psql command-line options \? variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commands ...
\? options show help on psql command-line options \? variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commands Query Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit f...