How Postgresql COPY TO STDIN With CSV do on conflic do update?

by

In this SO post, there are two answers that -combined together- provide a nice solution for successfully using ON CONFLICT. The example below, uses ON CONFLICT DO NOTHING;:

BEGIN;
CREATE TEMP TABLE tmp_table 
(LIKE main_table INCLUDING DEFAULTS)
ON COMMIT DROP;
    
COPY tmp_table FROM 'full/file/name/here';
    
INSERT INTO main_table
SELECT *
FROM tmp_table
ON CONFLICT DO NOTHING;
COMMIT;

Replace both instances of main_table with the name of your table.

More Related Contents:

  1. psycopg2: insert multiple rows with one query
  2. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  3. Passing table name as a parameter in psycopg2
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. error installing psycopg2, library not found for -lssl
  6. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  7. How to set up a PostgreSQL database in Django
  8. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  9. Psycopg2 image not found
  10. Error Installing Psycopg2 on MacOS 10.9.5
  11. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  12. Create a Postgres database using python
  13. Python/postgres/psycopg2: getting ID of row just inserted
  14. Escape SQL “LIKE” value for Postgres with psycopg2
  15. How to set connection timeout in SQLAlchemy
  16. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  17. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  18. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  19. Insert Python Dictionary using Psycopg2
  20. Use binary COPY table FROM with psycopg2
  21. create a loop inside a loop in python
  22. Writing a pandas DataFrame to CSV file
  23. How to install psycopg2 with “pip” on Python?
  24. Can’t subtract offset-naive and offset-aware datetimes
  25. How to keep leading zeros in a column when reading CSV with Pandas?
  26. Writing Python lists to columns in csv
  27. Reading rows from a CSV file in Python
  28. CSV new-line character seen in unquoted field error
  29. How do you replace all the occurrences of a certain character in a string?
  30. Converting a csv file into a list of tuples with python

Leave a Comment