[PYTHON/PSYCOPG2] connect 함수 : 데이터베이스 연결하기

■ connect 함수를 사용해 데이터베이스에 연결하는 방법을 보여준다.

▶ 예제 코드 1 (PY)


import psycopg2

with psycopg2.connect(host = "192.168.29.118", port = "5432", database = "testdb", user = "testuser1", password = "test1234") as connection:
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM test;")

        resultList = cursor.fetchall()

        for result in resultList:
            print(result)

"""
(1, '홍길동', 20)
(2, '김철수', 30)
(3, '이영희', 25)
"""

import psycopg2

with psycopg2.connect(host = "192.168.29.118", port = "5432", database = "testdb", user = "testuser1", password = "test1234") as connection:

with connection.cursor() as cursor:

cursor.execute("SELECT * FROM test;")

resultList = cursor.fetchall()

for result in resultList:

print(result)

"""

(1, '홍길동', 20)

(2, '김철수', 30)

(3, '이영희', 25)

"""

▶ 예제 코드 2 (PY)


import psycopg2

with psycopg2.connect("host='192.168.29.118' dbname='testdb' user='testuser1' password='test1234'") as connection:
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM test;")

        resultList = cursor.fetchall()

        for result in resultList:
            print(result)

"""
(1, '홍길동', 20)
(2, '김철수', 30)
(3, '이영희', 25)
"""