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 vote144 views1 answer
Postgres drop type
SQL
10 votes228 views2 answers
Doublon sql
SQL
0 vote157 views1 answer
Get who is hired in february in sql
SQL
20 votes147 views3 answers
SQL query rename table
SQL
0 vote153 views2 answers
Python mysql create table if not exists
SQL
2 votes298 views5 answers
Unique in sql server
SQL
0 vote142 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote151 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote143 views1 answer
Default column value in sql same as other column
SQL
0 vote154 views1 answer
Mysql page segment
SQL