sqlor/docs/postgresql.md
2024-09-23 14:19:50 +08:00

21 lines
286 B
Markdown
Executable File

# POSTGRESQL
## create database
create database testdb;
## create user
create role guest with login;
## grat privileges
grant all privileges on database testdb to guest;
### grant table privileges
psql -d testdb
grant all privileges on all tables in schema public to guest;