PG（HGDB）中创建-查看-删除extension

最新推荐文章于 2024-04-23 08:00:00 发布

lk_db

最新推荐文章于 2024-04-23 08:00:00 发布

阅读量880

点赞数

分类专栏： Highgo DB PostgreSQL

本文链接：https://blog.csdn.net/lk_db/article/details/78214853

版权

Highgo DB 同时被 2 个专栏收录

171 篇文章 2 订阅

订阅专栏

PostgreSQL

162 篇文章 2 订阅

订阅专栏

highgo=# create extension "uuid-ossp";
CREATE EXTENSION
highgo=# select extname,extowner,extnamespace,extrelocatable,extversion from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion
-----------+----------+--------------+----------------+------------
plpgsql | 10 | 11 | f | 1.0
uuid-ossp | 10 | 2200 | t | 1.0
(2 rows)

highgo=# create extension "uuid-ossp";
错误: 扩展 "uuid-ossp" 已经存在
highgo=# drop extension "uuid-ossp";
DROP EXTENSION
highgo=# select extname,extowner,extnamespace,extrelocatable,extversion from pg_extension;
extname | extowner | extnamespace | extrelocatable | extversion
---------+----------+--------------+----------------+------------
plpgsql | 10 | 11 | f | 1.0
(1 row)