How to create, then use, a postgres REFCURSOR in postgres

POSTGRESQL_REFCURSOR_EXAMPLE.py

import psycopg2
import json




def get_drives_and_media_type():
    results = []
    with psycopg2.connect("host=# dbname=entertainment_database user=# password=#") as conn:
        with conn.cursor() as db_cursor:
            db_cursor.callproc('GET_DRIVES_AND_MEDIA_TYPES',['something'])
            with conn.cursor('something') as cursor2:
                for x in cursor2:
                    results.append({'table_name':x[0],'id':x[1],'name':x[2],'storage_type':x[3]})
    return results