+-
首页 专栏 postgresql 文章详情
＿xk 发布于 2 月 23 日
关注作者
关注作者
0
PostgreSQL
＿xk 发布于 2 月 23 日
解析器:
查询已有解析器
postgres=# \dFpRefs:
解析器 -- 官方文档中文翻译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 functionsRefs:
Listing the extensions available in PostgreSQL postgresql
阅读 45 更新于 2 月 23 日
赞
收藏
分享
本作品系原创， 采用《署名-非商业性使用-禁止演绎 4.0 国际》许可协议
＿xk
要么吊, 要么掉.
9 声望
0 粉丝
0 条评论
得票 时间
提交评论
＿xk
要么吊, 要么掉.
9 声望
0 粉丝
宣传栏
目录
▲
解析器:
查询已有解析器
postgres=# \dFpRefs:
解析器 -- 官方文档中文翻译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 functionsRefs:
Listing the extensions available in PostgreSQL