随笔分类 -  postresql

摘要：postgresql 删除数据库报错 postgres=# drop database testdb;ERROR: database "testdb" is being accessed by other usersDETAIL: There are 6 other sessions using t 阅读全文

摘要：create user xiaoming with password '8RUy';grant all on DATABASE yqxe to xiaoming;\c mydb (切换到我的数据库yqxe)GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA pu 阅读全文

摘要：查看当前用户 \du 或 select * from pg_roles; postgres的退出postgres-# \q 查看用户权限 select * from information_schema.table_privileges where grantee='zjy'; 创建CREATE R 阅读全文