快捷導(dǎo)航

PostgreSQL psql 常用命令總結(jié)

更新時(shí)間：2023年07月07日 10:44:46 作者：曉楓的春天

psql是PostgreSQL的一個(gè)命令行交互式客戶端工具，它具有非常豐富的功能，類似于Oracle的命令行工具sqlplus，本文給大家總結(jié)下PostgreSQL 中常用 psql 常用命令以便后續(xù)查閱，感興趣的朋友跟隨小編一起看看吧

角色查看

hrdb=> \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 admin     | Create role, Create DB, Cannot login                       | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 wdh       | Create DB                                                 +| {}
           | Password valid until 2060-12-31 00:00:00+08                |

對(duì)應(yīng)sql

select * from pg_roles

數(shù)據(jù)庫(kù)查看

hrdb=> \l
                                                 List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    | ICU Locale | Locale Provider |   Access privileges   
-----------+----------+----------+-------------+-------------+------------+-----------------+-----------------------
 hrdb      | wdh      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | 
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | 
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =c/postgres          +
           |          |          |             |             |            |                 | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =c/postgres          +
           |          |          |             |             |            |                 | postgres=CTc/postgres

對(duì)應(yīng)sql

select * from pg_database;

模式查看

hrdb=> \dn
      List of schemas
  Name  |       Owner       
--------+-------------------
 hr     | wdh
 public | pg_database_owner
(2 rows)

對(duì)應(yīng)sql

select * from pg_namespace;

表結(jié)構(gòu)查看

hrdb=> \d jobs;
                         Table "public.jobs"
   Column   |         Type          | Collation | Nullable | Default 
------------+-----------------------+-----------+----------+---------
 job_id     | character varying(10) |           | not null | 
 job_title  | character varying(35) |           | not null | 
 min_salary | integer               |           |          | 
 max_salary | integer               |           |          | 
Indexes:
    "job_id_pk" PRIMARY KEY, btree (job_id)
Referenced by:
    TABLE "employees" CONSTRAINT "emp_job_fk" FOREIGN KEY (job_id) REFERENCES jobs(job_id)

表空間查看

hrdb=> \db
       List of tablespaces
    Name    |  Owner   | Location 
------------+----------+----------
 pg_default | postgres | 
 pg_global  | postgres |

到此這篇關(guān)于PostgreSQL psql 常用命令總結(jié)的文章就介紹到這了,更多相關(guān)PostgreSQL psql命令內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: