Creating a #Postgresql Table

python.py

import psycopg2

def create_table():
  
  #Referece: Constructing #Postgresql connection obect
  
  sql_create_asset_table = ('''CREATE TABLE IF NOT EXISTS ASSETS (
            ID          SERIAL PRIMARY KEY,
            NAME        TEXT   NOT NULL,
            LICENSE     TEXT   NOT NULL,
            QUANTITY    INT    NOT NULL,
            HOSTNAME    TEXT   NOT NULL,
            EXPIRES     TEXT   NOT NULL,
            ENVIRONMENT TEXT   NOT NULL,
            DESCRIPTION TEXT   NOT NULL);''')

            cursor.execute(sql_create_asset_table)

            #Commit Changes to Database
            conn.commit()

            #Close Database Connection
            conn.close()