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 vote106 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote115 views1 answer
Ms sql filter all sympbol
SQL
1 vote124 views1 answer
Limit offset order by mysql
SQL
11 votes117 views5 answers
Sql server reset identity
SQL
0 vote119 views1 answer
Trigger stock phpmyadmin
SQL
1 vote108 views1 answer
How to fetch alternate records from two tables
SQL
27 votes139 views5 answers
Mysql set password for user
SQL
0 vote118 views1 answer
How to remove quotes from a string in ssis load file
SQL
4 votes105 views3 answers
Sql find second highest salary employee
SQL
5 votes121 views6 answers
In operator sql
SQL