ons
Schema | Name | Type | Owner
--------+------+-------+----------
public | t | table | postgres
?
7.\dn命令-列出所有的schema
?
osdba-# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres
pg_toast_temp_1 | postgres
public | postgres
(5 rows)
?
8.\db命令-显示所有表空间
?
osdba-# \db
List of tablespaces
Name | Owner | Location
------------+----------+----------
pg_default | postgres |
pg_global | postgres |
(2 rows)
?
9.\dg-列出数据库中所有角色和用户
?
osdba-# \dg
List of roles
Role name | Attributes | Member of
-----------+-------------+-----------
postgres | Superuser | {}
: Create role
: Create DB
?
10.\dp-显示表的权限分配情况
?
osdba-# \dp
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+------+-------+-------------------+--------------------------
public | t | table | |
(1 row)
?
四、指定字符集编译的命令
1.\encoding gbk-设置客户端的字符编码为gbk
?
五、\pset命令
1.\pset命令-用于设置输出的格式，\pset border 0/1/2：输出内容无边框、只有内边框、内外都有边框
?
osdba-# \pset border 0
Border style is 0.
osdba-# \dp
Access privileges
Schema Name Type Access privileges Column access privileges
------ ---- ----- ----------------- ------------------------
public t table
(1 row)
osdba-# \pset border 1
Border style is 1.
osdba-# \dp
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+------+-------+-------------------+--------------------------
public | t | table | |
(1 row)
osdba-# \pset border 2
Border style is 2.
osdba-# \dp
Access privileges
+--------+------+-------+-------------------+--------------------------+
| Schema | Name | Type | Access privileges | Column access privileges |
+--------+------+-------+-------------------+--------------------------+
| public | t | table | | |
+--------+------+-------+-------------------+--------------------------+
(1 row)
?
2.\x命令-可以把表中的每一行的每列数据都拆分为单行展示，如果有一行数据有太多的拆行，显示不下，就可以使用这个命令
?
osdba-# \x
Expanded display is on.
osdba-# \dp
Access privileges
+-[ RECORD 1 ]-------------+--------+
| Schema | public |
| Name | t |
| Type | table |
| Access privileges | |
| Column access privileges | |
+--------------------------+--------+
osdba-# \x
Expanded display is off.
osdba-# \dp
Access privileges
+--------+------+-------+-------------------+--------------------------+
| Schema | Name | Type | Access privileges | Column access privileges |
+--------+------+-------+-------------------+--------------------------+
| public | t | table | | |
+--------+------+-------+-------------------+--------------------------+
(1 row)
?
五、psql使用技巧
1.使用上下键把过去使用过的命令或者SQL语句调出来，连续两个tab键表示补全或给出提示输入
?
osdba-# \d
\d \dc \dD \dew \dFd \dg \dn \ds \dT
\da \dC \des \df \dFp \di \do \dS \du
\db \dd \deu \dF \dFt \dl \dp \dt \dv
?
2.psql加上-E参数，可以把psql中各种以"\"开头的命令执行的实际SQL打印出来
?
-bash-4.1$ psql -E postgres
psql (8.4.20)
Type "help" for help.
postgres=# \d
********* QUERY **********
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_ca