postgresql in jupyter

pip install ipython-sql
conda install psycopg2

brew install postgresql
echo 'export PGDATA=/usr/local/var/lib/pgsql/data' >> ~/.zshrc
source ~/.zshrc
initdb
brew services start postgresql

jupyter-console

%load_ext sql
%sql postgresql://@localhost/postgres
# => 'Connected: @postgres'

%sql create table test_table (id int, name text)
%sql insert into test_table values (1, 'a'), (2, 'b')
df = %sql select * from test_table
df