install postgresql mac code example

Example 1: postgres install mac

$ brew install postgresql

Example 2: how to open postgresql in mac

brew services start postgresqlpsql postgres

Example 3: install postgresql on mac

brew install postgresql

Example 4: postgresql create database mac

sudo psql -U postgres
psql: FATAL:  role "postgres" does not exist

Example 5: postgresql 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=# \q

Example 6: how to open postgresql in mac

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"