[PostgresSQL] Install and start the service

Install:

brew install postgresql

 

Start:

brew services start postgresql

psql postgres

 

Create a table:

$ postgres=# create table Users (
$ postgres(# create_date Date,
$ postgres(# user_handle uuid,
$ postgres(# last_name text,
$ postgres(# first_name text );

 

Insert data:

$ postgres=# insert into Users (create_date, user_handle, last_name, first_name) values ('2018-06-06', 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', 'clark', 'tyler');

insert multi data: (insert 3 rows)

$ postgres=# insert into Users (create_date) values (now()), (now()), (now());