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
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme