PostgreSQL安装及简单应用

下载地址：EDB: Open-Source, Enterprise Postgres Database Management

安装

注意：端口号默认是5432

配置dbeaver应用，创建数据库和表

-- 创建模式（如果不存在）
CREATE SCHEMA IF NOT EXISTS bbbase;-- 创建序列（用于主键自增）
CREATE SEQUENCE IF NOT EXISTS bbbase.rp_config_id_seq2
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;-- 创建路由代理配置表
CREATE TABLE IF NOT EXISTS bbbase.rp_config2 (config_id bigint PRIMARY KEY DEFAULT nextval('bbbase.rp_config_id_seq2'),department_id varchar(64) NULL,request_url varchar(256) NULL,function_id varchar(64) NULL,redirect_url varchar(256) NULL,factorycode varchar(64) NULL,username varchar(64) NULL,password_hash varchar(128) NULL,password_salt varchar(64) NULL,create_by varchar(64) NULL DEFAULT NULL::varchar,create_time timestamptz DEFAULT CURRENT_TIMESTAMP,update_by varchar(64) NULL DEFAULT NULL::varchar,update_time timestamptz DEFAULT CURRENT_TIMESTAMP,remark varchar(500) NULL DEFAULT NULL::varchar,is_deleted boolean DEFAULT false
) WITH (fillfactor = 80);-- 为表添加注释
COMMENT ON TABLE bbbase.rp_config2 IS '路由代理配置表';-- 为各个字段添加注释
COMMENT ON COLUMN bbbase.rp_config2.config_id IS '配置ID（主键）';
COMMENT ON COLUMN bbbase.rp_config2.department_id IS '部门ID';
COMMENT ON COLUMN bbbase.rp_config2.request_url IS '原始请求URL';
COMMENT ON COLUMN bbbase.rp_config2.function_id IS '功能模块ID';
COMMENT ON COLUMN bbbase.rp_config2.redirect_url IS '重定向目标URL';
COMMENT ON COLUMN bbbase.rp_config2.factorycode IS '工厂/系统编码';
COMMENT ON COLUMN bbbase.rp_config2.username IS '认证用户名';
COMMENT ON COLUMN bbbase.rp_config2.password_hash IS '密码哈希值';
COMMENT ON COLUMN bbbase.rp_config2.password_salt IS '密码加密盐值';
COMMENT ON COLUMN bbbase.rp_config2.create_by IS '记录创建人';
COMMENT ON COLUMN bbbase.rp_config2.create_time IS '记录创建时间';
COMMENT ON COLUMN bbbase.rp_config2.update_by IS '记录最后更新人';
COMMENT ON COLUMN bbbase.rp_config2.update_time IS '记录最后更新时间';
COMMENT ON COLUMN bbbase.rp_config2.remark IS '备注信息';
COMMENT ON COLUMN bbbase.rp_config2.is_deleted IS '是否删除（true-已删除，false-未删除）';-- 验证表和注释是否创建成功
SELECT * FROM bbbase.rp_config2 LIMIT 0;

csdn下载链接：https://download.csdn.net/download/ly1h1/91349558