db/create_table.py


1
2
3
4
5
6
7
8

import psycopg2
import os

conn = psycopg2.connect(os.environ.get("DATABASE_URL") or "dbname=questbook user=postgres")
conn.cursor().execute("create table messages (id int, email varchar(255), name varchar(255), message varchar(2048))")
conn.commit()