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

3 votes170 views2 answers
Sqlite show table definition
SQL
0 vote171 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote175 views1 answer
What is default mysql database password in linux
SQL
0 vote179 views1 answer
Php mysqli install
SQL
21 votes176 views1 answer
Cheatsheet for sql
SQL
6 votes178 views1 answer
Oracle trigger after logon on database
SQL
-1 vote181 views1 answer
Sql oracle take only last results
SQL
0 vote186 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote173 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote169 views2 answers
2nd max salary query in sql
SQL