I am using agate to load my csv file into Postgres.

table = agate.Table.from_csv(csvPath)
table.to_sql('postgresql:///Pricing', 'complete', )

Is there a way to only insert rows that do not already exist in Postgres? The unique key would be ref & date