gsql 连接

usr/local/opengauss/bin/gsql -d ${数据库名} -p 5432  //默认数据库有 opengauss 和 postgres 不指定的话 默认opengauss

报错usr/local/opengauss/bin/gsql: error while loading shared libraries: libcjson.so.1: cannot open shared object file: No such file or directory 但是却能找到 libraries: libcjson.so.1 在/usr/local/opengauss/lib/libcjson.so.1

将该目录加进动态链接配置中

echo '/usr/local/opengauss/lib' | sudo tee -a /etc/ld.so.conf
ldconfig

创建数据库

CREATE DATABASE ${数据库名}
  WITH 
  OWNER = ${Owner名}
  ENCODING = 'UTF8'
  LC_COLLATE = 'en_US.UTF-8'
  LC_CTYPE = 'en_US.UTF-8'
  CONNECTION LIMIT = -1;

创建schema

CREATE SCHEMA ${schema名称};

创建ROLE

CREATE ROLE ${ROLE名称} WITH PASSWORD '${密码}';

赋予登录权限

ALTER ROLE ${ROLE} WITH LOGIN;

赋予其他权限

// 赋予全部
GRANT ALL PRIVILEGES ON DATABASE ${数据库名称} TO ${用户名};
GRANT ALL PRIVILEGES ON SCHEMA ${SCHEMA名称} TO ${用户名};

// 单独的
GRANT USAGE ON SCHEMA ${SCHEMA名} TO ${ROLE名};
GRANT CREATE ON SCHEMA ${SCHEMA名} TO ${ROLE名};
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA ${SCHEMA名} TO ${ROLE名};

删除SCHEMA（如果加上CASCADE 递归地删除 schema 及其包含的所有对象）

DROP SCHEMA ${SCHEMA名称} CASCADE;