Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # install
- brew install postgresql
- # usage
- 1. 登录
- psql
- 2. 查看所有用户
- \du
- 创建新用户
- create user jifa;
- 修改权限
- alter role jifa createdb;
- 修改密码
- alter role jifa with password ‘haha'
- > 链接的是 database,不是 user。
- 切换database,\c jifa_db;
- 切换 user
- \c jifa_db jifa;
- cmd:
- $ psql
- 万能命令
- \?
- show user:
- $ \du
- default user/passwd
- progres/progres
- show database
- $ \l
- create table;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement