copy "Schema".county_check_audit to '\NETWORK-HOSTNetworkFoldercounty_check.csv' delimiter ',' CSV HEADER;

import psycopg2
connection = psycopg2.connect(database="db", user="postgres", password="password", host="NETWORK-HOST")
cursor = connection.cursor()
cursor.execute("copy "Schema".area_check_audit to '\\NETWORK-HOST\NetworkFolder\area_check.csv' delimiter ',' CSV HEADER;")
connection.commit()

psycopg2.ProgrammingError: could not open file "\NETWORK-HOSTNetworkFolderarea_check.csv" for writing: Permission denied