解析器:

查问已有解析器

postgres=# \dFp

Refs:

  • 解析器 -- 官网文档中文翻译

extensions（扩大）:

查看数据库已装置的扩大:

postgres=# \dx# Output:#    Name   | Version |   Schema   |                             Description# ----------+---------+------------+---------------------------------------------------------------------#  plpgsql  | 1.0     | pg_catalog | PL/pgSQL procedural  language#  postgis  | 2.4.6   | public     | PostGIS geometry,  geography, and raster spatial types and functions#  zhparser | 2.1     | public     | a parser for full-text search of Chinese# (3 rows)# 或者postgres=# SELECT * FROM pg_extension;# 输入跟下面有点 \dx 有点不同.

查看数据库可装置的扩大:

postgres=# select * from pg_available_extensions;# Output:#             name             | default_version | installed_version |                                                       comment# ------------------------------+-----------------+-------------------+---------------------------------------------------------------------------------------------------------------------# refint                       | 1.0             |                   | functions for implementing referential integrity (obsolete)# postgis                      | 2.4.6           | 2.4.6             | PostGIS geometry, geography, and raster spatial types and functions

Refs:

  • Listing the extensions available in PostgreSQL