Use this script to load NIFTY Intraday data into PostgreSQL Database

LoadDataIntoPostgreSQL.py

import psycopg2
conn = psycopg2.connect("host='localhost' port='5432' dbname='stocks' user='xxxxxx' password='xxxxxx'")
cur = conn.cursor()

SQL_STATEMENT = """
    COPY %s FROM STDIN WITH
        CSV
        HEADER
        DELIMITER AS ','
    """

def process_file(conn, table_name, file_object):
    cursor = conn.cursor()
    cursor.copy_expert(sql=SQL_STATEMENT % table_name, file=file_object)
    conn.commit()
    cursor.close()

f = open(r'C:\Users\xxx\Desktop\AllStocksExtracted\code\result.csv', 'r')


try:
    process_file(conn, 'stocks', f)
finally:
    conn.close()