diff options
Diffstat (limited to 'db/create_table.py')
-rw-r--r-- | db/create_table.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/db/create_table.py b/db/create_table.py new file mode 100644 index 0000000..168fb16 --- /dev/null +++ b/db/create_table.py @@ -0,0 +1,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() + + |