Step-by-step instructions to install, launch and load PostgreSQL on Mac OS 10.3 or later and run it locally.

Install brew

Install anaconda

=================================

brew install postgresql brew upgrade postgresql

==================================

anaconda --version

==================================

conda install -c anaconda psycopg2

=================================

brew tap homebrew/services brew services start postgresql

=================================

cd $PATH/TO/FILE/database_name

=================================

psql

=================================

CREATE DATABASE $database_name;

=================================

\l OR \list

=================================

\connect $database_name OR \c $database_name

=================================

\i $file_name.sql

=================================

psql -f $file_name.sql

=================================

COPY $table_name FROM "$PATH/TO/FILE/$file_name.csv" DELIMITER ',' CSV HEADER;

/COPY $table_name FROM "$PATH/TO/FILE/$file_name.csv" DELIMITER ',' CSV HEADER;

=================================

\d $database_name;

done.

==================================

If you are using zsh with iTerm2, YOU WILL HAVE TO REDO THE PROCESS AFTER INSTALLATION AS WELL AS SETTING ANACONDA SCRIPT IN THE ~/.zshrc file.

I always use nano as such and here's a sample of how my .zshrc file looks like:

` #test -e "${HOME}/.iterm2_shell_integration.zsh" && source "${HOME}/.iterm2_shell_integration.zsh" SHELL="zsh"

__conda_setup="$(CONDA_REPORT_ERRORS=false '/Users/jpro/anaconda3/bin/conda' shell.bash hook 2> /dev/null)" if [ $? -eq 0 ]; then \eval "$__conda_setup" else if [ -f "/Users/$user/anaconda3/etc/profile.d/conda.sh" ]; then . "/Users/$user/anaconda3/etc/profile.d/conda.sh" CONDA_CHANGEPS1=false conda activate base else \export PATH="/Users/jpro/anaconda3/bin:$PATH" fi fi unset __conda_setup

test -e "${HOME}/.iterm2_shell_integration.bash" && source "${HOME}/.iterm2_shell_integration.bash"

__conda_setup="$(CONDA_REPORT_ERRORS=false '/anaconda3/bin/conda' shell.bash hook 2> /dev/null)" if [ $? -eq 0 ]; then \eval "$__conda_setup" else if [ -f "/anaconda3/etc/profile.d/conda.sh" ]; then . "/anaconda3/etc/profile.d/conda.sh" CONDA_CHANGEPS1=false conda activate base else \export PATH="/anaconda3/bin:$PATH" fi fi unset __conda_setup

export PATH="/usr/local/sbin:$PATH"`