PostgreSQL Create Database
To create a database, run
1 |
CREATE DATABASE "DB_NAME_HERE"; |
Creating user, grant permissions
1 2 3 4 5 6 7 8 9 10 11 12 13 |
CREATE USER USER_NAME_HERE WITH PASSWORD 'BAPT788HZutBdV'; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO USER_NAME_HERE; GRANT USAGE ON SCHEMA public TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA DB_NAME_HERE TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA DB_NAME_HERE TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON DATABASE DB_NAME_HERE TO USER_NAME_HERE; psql DB_NAME_HERE -c "GRANT ALL ON ALL TABLES IN SCHEMA public to USER_NAME_HERE;" psql DB_NAME_HERE -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to USER_NAME_HERE;" psql DB_NAME_HERE -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to USER_NAME_HERE;" |
Creating a User and Database using psql
1 2 3 |
su - postgres createuser USERNAME_HERE createdb --encoding=UTF8 --owner=USERNAME_HERE DB_NAME_HERE |