Small Asteroid Blog

[python] python + postgresql 연동하기 본문

백엔드/Python

[python] python + postgresql 연동하기

작은소행성☄️ 2021. 10. 28. 09:15
728x90

 

python 프로그래밍 언어용 postgresql 어댑터를 설치해준다.

pip install psycopg2-binary

 

 

 

postgres와 연결하기 위해서는 psycopg2 패키지의 connect이용하면된다.

 

import psycopg2

conn = psycopg2.connect(
        host = "localhost",
        port = 5432,
        dbname = "test",
        user="root",
        password="1234")

 

 

 

 

 

 

 

 

 

 

 

 

728x90
반응형

'백엔드 > Python' 카테고리의 다른 글

[python] /usr/local/lib/python3.8/dist-packages/ipykernel/ipkernel.py:283: DeprecationWarning: `should_run_async` will not call `transform_cell` automatically in the future. Please pass the result to `transformed_cell` argument and any exception that ha..  (0) 2021.10.29
[python] python db select 문 출력하기  (0) 2021.10.28
[python] timestamp 값 년월일로 변환  (0) 2021.10.01
[pyspark] union can only be performed on tables with the same number of columns  (0) 2021.09.16
[pyspark] Cannot Call methods on a stopped SparkContext  (0) 2021.09.16
'백엔드/Python' Related Articles more