qst4y2Nm

1import psycopg2 
2     
3PS C:Python Projectsdatabase> pip install psycopg2
4Requirement already satisfied: psycopg2 in c:usersuserappdatalocalprogramspythonpython37libsite-packages (2.8.2) 
5     
6PS C:Python Projectsdatabase> python script2.py
7Traceback (most recent call last):
8  File "script2.py", line 48, in <module>
9    create_table()
10  File "script2.py", line 9, in create_table
11    cur.execute("CREATE TABLE store IF NOT EXISTS (item TEXT, quantity INTEGER, price REAL)")
12psycopg2.errors.SyntaxError: syntax error at or near "IF"
13LINE 1: CREATE TABLE store IF NOT EXISTS (item TEXT, quantity INTEGE...