建数据库不要给public模式
新建用户默认有 public 权限
而public 包含了 登录数据库的权限
revoke connect on database postgres from public;
新建用户并赋予某数据库所有权限
create role psadmin with password 'psadmin' LOGIN NOSUPERUSER NOINHERIT ;
授权访问数据库,表权限
grant all on database sutpc_phone_signal to psadmin;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO psadmin;
查看连接数
select client_addr,count(1) as num from pg_stat_activity group by client_addr
日期转换
to_char(fee_pay_time, 'YYYY-MM-DD HH24:MI:SS')