PostgreSQL 内部查询命令

最新推荐文章于 2020-06-14 11:10:22 发布

转载最新推荐文章于 2020-06-14 11:10:22 发布 · 120 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/dodojava/blog/36046

文章标签：

#数据库 #python

本文详细介绍了在psql提示符下可以使用的多种命令，包括描述表、列出函数、展示权限等，帮助用户更好地管理和操作PostgreSQL数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

Apart from select statements you can use the following commands on psql prompt -

\d [NAME]	describe table, index, sequence, or view
\d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables
\da [PATTERN]	list aggregate functions
\db [PATTERN]	list tablespaces (add "+" for more detail)
\dc [PATTERN]	list conversions
\dC      	list casts
\dd [PATTERN]	show comment for object
\dD [PATTERN]	list domains
\df [PATTERN]	list functions (add "+" for more detail)
\dg [PATTERN]	list groups
\dn [PATTERN]	list schemas (add "+" for more detail)
\do [NAME]    	list operators
\dl    		list large objects, same as \lo_list
\dp [PATTERN]  	list table, view, and sequence access privileges
\dT [PATTERN]  	list data types (add "+" for more detail)
\du [PATTERN]  	list users
\l    		list all databases (add "+" for more detail)
\z [PATTERN]	list table, view, and sequence access privileges (same as \dp)

转载于:https://my.oschina.net/dodojava/blog/36046