[PYTHON/PSYCOPG2] Cursor 클래스 : execute 메소드를 사용해 데이터 추가하기

■ Cursor 클래스의 execute 메소드를 사용해 데이터를 추가하는 방법을 보여준다.

▶ 테스트 테이블 (SQL)


CREATE TABLE test
(
    ID   INTEGER PRIMARY KEY,
    NAME VARCHAR,
    AGE  INTEGER
);

CREATE TABLE test

(

ID INTEGER PRIMARY KEY,

NAME VARCHAR,

AGE INTEGER

);

▶ 예제 코드 (PY)


import psycopg2

connection = psycopg2.connect("host='192.168.29.118' dbname='testdb' user='testuser1' password='test1234'")

cursor = connection.cursor()

cursor.execute("INSERT INTO test (id, name, age) VALUES (1, '홍길동', 20)")

connection.commit()

cursor.close()
connection.close()

import psycopg2

connection = psycopg2.connect("host='192.168.29.118' dbname='testdb' user='testuser1' password='test1234'")

cursor = connection.cursor()

cursor.execute("INSERT INTO test (id, name, age) VALUES (1, '홍길동', 20)")

connection.commit()

cursor.close()

connection.close()

▶ requirements.txt


psycopg2-binary==2.9.9

psycopg2-binary==2.9.9