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 vote190 views1 answer
Group_concat only returns one row
SQL
11 votes189 views2 answers
Mysql set safe mode off
SQL
0 vote189 views1 answer
Mysql where don't have string
SQL
0 vote218 views1 answer
Finding leap year in sql
SQL
-2 votes201 views2 answers
Add auto_increment column to existing table mysql
SQL
10 votes185 views1 answer
Oracle view dependencies
SQL
1 vote236 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote187 views1 answer
Oracle dynamic select into
SQL
0 vote206 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote191 views1 answer
Kill a pid redshift
SQL