云社区 博客 博客详情

DWS gsql快捷指令

瘸子那条好腿 发表于 2020-10-13 14:53:09 2020-10-13
0
0

【摘要】 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

登录后可下载附件,请登录或者注册

【版权声明】本文为华为云社区用户转载文章,如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件至:huaweicloud.bbs@huawei.com进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容。
评论文章 //点赞 收藏 0
点赞
分享文章到微博
分享文章到朋友圈

上一篇:Linux下查看软、硬raid信息的方法

下一篇:ADB for mysql 【INSERT [IGNORE] INTO table_name】迁移 DWS 改写方法

评论 (0)


登录后可评论,请 登录注册

评论