DWS gsql快捷指令

举报
瘸子那条好腿 发表于 2020/10/13 14:53:09 2020/10/13
【摘要】 gsql快捷指令

快捷命令:
 \d[S+] list tables, views, and sequences
 \d[S+] NAME describe table, view, sequence, or index
 \db[+] [PATTERN] list tablespaces
 \dg[+] [PATTERN] list roles
 \di[S+] [PATTERN] list indexes
 \dn[S+] [PATTERN] list schemas
 \do[S] [PATTERN] list operators
 \dO[S+] [PATTERN] list collations
 \dp [PATTERN] list table, view, and sequence access privileges
 \drds [PATRN1 [PATRN2]] list per-database role settings
 \ds[S+] [PATTERN] list sequences
 \dt[S+] [PATTERN] list tables
 \dT[S+] [PATTERN] list data types
 \du[+] [PATTERN] list roles
 \dv[S+] [PATTERN] list views
 \dE[S+] [PATTERN] list foreign tables
 \dx[+] [PATTERN] list extensions
 \l[+] list all databases
 \sf[+] FUNCNAME show a function's definition
 \z [PATTERN] same as \dp
 \dd[S] [PATTERN] show object descriptions not displayed elsewhere
 \ddp [PATTERN] list default privileges
 \dD[S+] [PATTERN] list domains
 \ded[+] [PATTERN] list data sources
 \det[+] [PATTERN] list foreign tables
 \des[+] [PATTERN] list foreign servers
 \deu[+] [PATTERN] list user mappings
 \dew[+] [PATTERN] list foreign-data wrappers
 \df[antw][S+] [PATRN] list [only agg/normal/trigger/window] functions
 \dF[+] [PATTERN] list text search configurations
 \dFd[+] [PATTERN] list text search dictionaries
 \dFp[+] [PATTERN] list text search parsers
 \dFt[+] [PATTERN] list text search templates
 \dl list large objects, same as \lo_list
 \dL[S+] [PATTERN] list procedural languages

【版权声明】本文为华为云社区用户转载文章,如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。