[PYTHON/PSYCOPG2] Cursor 클래스 : execute 메소드를 사용해 테이블 생성하기

■ Cursor 클래스의 execute 메소드를 사용해 테이블을 생성하는 방법을 보여준다.

▶ 예제 코드 (PY)


import psycopg2

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

cursor = connection.cursor()

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

cursor.execute(sql)

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()

sql = """

CREATE TABLE test

(

ID INTEGER PRIMARY KEY,

NAME VARCHAR,

AGE INTEGER

);

"""

cursor.execute(sql)

connection.commit()

cursor.close()

connection.close()

▶ requirements.txt


psycopg2-binary==2.9.9

psycopg2-binary==2.9.9