/SQL/ON DUPLICATE KEY UPDATE for postgres

ON DUPLICATE KEY UPDATE for postgres

INSERT INTO the_table (id, column_1, column_2) 
VALUES (1, 'A', 'X'), (2, 'B', 'Y'), (3, 'C', 'Z')
ON CONFLICT (id) DO UPDATE 
  SET column_1 = excluded.column_1, 
      column_2 = excluded.column_2;

Source: stackoverflow.com

To ignore duplicate keys during 'copy from' in postgresql

create temp table tmp_table on commit drop as select * from brand with no data;
copy tmp_table (name,slug) from '/var/lib/postgresql/data/Brands.csv' DELIMITER ',' csv header;
insert into brand select distinct on (slug) * from tmp_table;

Similar codes

1 vote144 views1 answer
Postgres select as csv
SQL
0 vote118 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
1 vote126 views1 answer
Psql connections
SQL
1 vote130 views1 answer
Oracle index partition
SQL
0 vote139 views1 answer
Microsoft sql server python connection
SQL
0 vote132 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote124 views2 answers
Zsh: command not found: mysq
SQL
0 vote154 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
2 votes130 views1 answer
Mysql clear screen
SQL
0 vote133 views1 answer
Sql common columns
SQL