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

-1 vote205 views1 answer
How to switch user in mysql
SQL
2 votes240 views1 answer
Oracle log files
SQL
3 votes264 views2 answers
Search text in all sql server stored procedure
SQL
0 vote247 views1 answer
Sql character index
SQL
0 vote203 views1 answer
Oracle sql date summer time
SQL
0 vote197 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote261 views1 answer
Postgres get running query
SQL
-1 vote208 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote337 views1 answer
Postgres set column based on another column
SQL
3 votes170 views2 answers
Coalesce mysql
SQL