切换数据库
\connect $DBNAME
查看Postgresql的可用扩展
SELECT * FROM pg_available_extensions;
安装所需扩展
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
验证扩展安装
SELECT * FROM pg_extension;
注意:请在操作先切换至所需开启的数据库中进行操作。
同样可以为数据库安装adminpack
CREATE EXTENSION adminpack;
Powered by: 博客园 Copyright © 2024 WebClerk Powered by .NET 8.0 on Kubernetes