PostgreSQL 内部查询命令

概述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/indexe

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,and sequence access privileges (same as \dp)

总结

以上是内存溢出为你收集整理的PostgreSQL 内部查询命令全部内容，希望文章能够帮你解决PostgreSQL 内部查询命令所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。