关于postgresql:PostgreSQL

解析器:

查问已有解析器

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