Postgres upsert

Upsert postgres

INSERT INTO table_name(column_list)
VALUES(value_list)
ON CONFLICT target [DO NOTHING]

-- or 
    
INSERT INTO table_name(column_list)
VALUES(value_list)
ON CONFLICT target DO UPDATE SET column_1 = value_1, .. WHERE condition]

Source: postgresqltutorial.com

Similar codes

0 vote158 views1 answer
Sql server list table sizes
SQL
0 vote156 views1 answer
List all indexes postgres
SQL
0 vote166 views1 answer
Php select data from mysql database without column name
SQL
1 vote217 views1 answer
Column with prefix in sql
SQL
0 vote188 views1 answer
How to find sql server name
SQL
0 vote160 views1 answer
Mysql cast null to string
SQL
0 vote156 views3 answers
Database restoring error
SQL
2 votes158 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote152 views1 answer
How to write if case in select query in select statement
SQL
2 votes169 views2 answers
Sql query to list all tables in a database sql server
SQL