postgresl创建用户/授权/数据库导入、导出

创建用户create user tblwgadmin with password 123456;修改密码ALTER USER xxx WITH PASSWORD xxx2026;授权数据库GRANT ALL PRIVILEGES ON DATABASE workgroup TO tblwgadmin;导出pg_dump -U username -p 5342 -d database a.txt导入psql -U tblwgadmin -d workgroup -f E:\工作\tableau脚本\pd_data授予最基本的 USAGE 权限允许访问 schema 中的对象GRANT USAGE ON SCHEMA db_prod_pub TO your_user;授予对 schema 中所有表、视图、序列的权限常用GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA db_prod_pub TO your_user; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA db_prod_pub TO your_user;授权GRANT USAGE, CREATE ON SCHEMA public TO datafill_bootstrap;授权是库级别的每个数据库要单独授权跨库不生效。