Insert or ignore postgres

INSERT INTO customers (NAME, email)
VALUES('Microsoft','hotline@microsoft.com') 
ON CONFLICT ON CONSTRAINT customers_name_key 
DO NOTHING;
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Insert or ignore postgres

INSERT INTO customers (name, email)
VALUES('Microsoft','hotline@microsoft.com') 
ON CONFLICT (name) 
DO NOTHING;
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Insert or ignore postgres

INSERT INTO 
    customers (name, email)
VALUES 
    ('IBM', 'contact@ibm.com'),
    ('Microsoft', 'contact@microsoft.com'),
    ('Intel', 'contact@intel.com');
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote193 views1 answer
Power bi find all ids not in other tables
SQL
0 vote285 views1 answer
Multiple replace value mssql
SQL
7 votes201 views2 answers
How to create index mysql
SQL
0 vote173 views1 answer
Stuff in sql server
SQL
3 votes179 views4 answers
Mysql decimal
SQL
1 vote175 views1 answer
Group_concat max length mysql
SQL
0 vote190 views1 answer
Tinydb add table
SQL
5 votes186 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote171 views1 answer
Mysql find db contarint
SQL
0 vote156 views1 answer
Hangfire clean script
SQL