postgres=# \l+ List of databases Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges---+---+---+---+---+---+---+---advent_of_code
\dp [PATTERN] list table, view, and sequence access privileges \dP[itn+] [PATTERN] list [only index/table] partitioned relations [n=nested] \drds [ROLEPTRN [DBPTRN]] list per-database role settings \dRp[+] [PATTERN] list replication publications \dRs[+] [PATTERN] list replication subs...
\e[FILE][LINE]edit the query buffer(or file)with external editor \ef[FUNCNAME[LINE]]editfunctiondefinition with external editor...Informational(options:S=show system objects,+=additional detail)\d[S+]list tables,views,and sequences \d[S+]NAME describe table,view,sequence,or index \da[S][...
postgres=# \l+List of databases Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges ---+---+---+---+---+---+---+--- advent_of_code | postgres | UTF8 | en_US.utf8 | en_US.utf8 | | libc | postgres=CTc/postgres+ | | | | ...
\? 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 ...
-c, --command=COMMAND run only single command (SQL or internal) and exit -d, --dbname=DBNAME database name to connect to (default: "postgres") -f, --file=FILENAME execute commands from file, then exit -l, --list list available databases, then exit ...
-c, --command=COMMAND run only single command (SQL or internal) and exit -d, --dbname=DBNAME database name to connect to (default: "gpadmin") -f, --file=FILENAME execute commands from file, then exit -l, --list list available databases, then exit ...
Command: sh /home/gpadmin/20160907/get_data.sh Execute on: host 'sdw01' 【命令: \l[+] 】 功能介绍: 显示所有数据库 testdb=# \l List of databases Name | Owner | Encoding | Access privileges ---+---+---+--- gpperfmon | gpadmin | UTF8 | gpadmin=CTc/gpadmin : =c/...
\? 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 querybuffer(or file) with external editor ...
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 function definition w...