import psycopg2
import csv
import string

# Connect to an existing database
conn = psycopg2.connect("dbname=postgres user=postgres password=xxxx")

cur = conn.cursor()

# create a table
 cur.execute("CREATE TABLE ADDRESS_SITE (ADDRESS_DETAIL_PID varchar(15) PRIMARY KEY, DATE_CREATED Date,
#   DATE_RETIRED Date, ADDRESS_TYPE varchar(8), ADDRESS_SITE_NAME varchar(45));")

file = open("/Users/jubertroldan/GNAF/AUG17_GNAF_PipeSeparatedValue_20170821153434/G-NAF/G-NAF AUGUST 2017/Standard/NSW_ADDRESS_SITE_psv.psv","r")

with file as f:
    next(f)
    for line in f:
        print(f.readline().count('|'))
        print(f.readline())
        cur.copy_from(f, 'ADDRESS_SITE', sep="|",null = '')
        conn.commit()
file.close()

Traceback (most recent call last):
  File "GNAF_ADDRESS_SITE.py", line 43, in <module>
    cur.copy_from(f, 'ADDRESS_SITE', sep="|",null = '')
psycopg2.DataError: extra data after last expected column
CONTEXT:  COPY address_site, line 1379807: "713005737|2015-04-28||UN|EASEMENT FOR OVERHANG 0.7 WIDE
701367558|2004-02-23||UN|"

01367554|2004-02-23||UN|
701367555|2004-02-23||UN|
701367556|2004-02-23||UN|
713005737|2015-04-28||UN|EASEMENT FOR OVERHANG 0.7 WIDE
701367558|2004-02-23||UN|
701367559|2004-02-23||UN|
701367560|2004-02-23||UN|