CU7tE9TD

1import psycopg2
2conn = psycopg2.connect("host=127.0.0.1 dbname=postgres user=marinxy")
3
4data = input('Input a sentence: ')
5print(f"Here is your input: \"{data}\"")
6
7cur = conn.cursor()
8cur.execute("""
9CREATE TABLE IF NOT EXISTS split_words(
10    id SERIAL PRIMARY KEY,
11    word text
12)
13""")
14
15for word in data.split(' '):
16    insert_query = "INSERT INTO split_words (word) VALUES ('{}')".format(word)
17    cur.execute(insert_query)
18conn.commit()