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

286 B
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;