how to open postgresql in mac
brew services start postgresqlpsql postgreshow to open postgresql in mac
brew services start postgresqlpsql postgrespostgresql create database mac
postgres=# CREATE DATABASE DB_NAME;
CREATE DATABASE
postgres=# CREATE USER USER_NAME WITH password 's3cr3t';
CREATE ROLE
postgres=# GRANT ALL ON DATABASE DB_NAME TO USER_NAME;
GRANT
postgres=# \c DB_NAME
You are now connected to database "DB_NAME" as user "postgres".
DB_NAME=# REVOKE ALL ON SCHEMA public FROM public;
REVOKE
DB_NAME=# GRANT ALL ON SCHEMA public TO DB_NAME;
GRANT
DB_NAME=# \qCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
