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 vote203 views1 answer
Set mysql mode global query
SQL
2 votes195 views1 answer
Postgresql add entry to table
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
0 vote202 views1 answer
What is metadata in sql
SQL
0 vote204 views1 answer
Sql string length postgresql
SQL
0 vote272 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote207 views1 answer
Search for tables with name postgresql
SQL
0 vote219 views1 answer
How to display value of variable in mysql
SQL
0 vote203 views1 answer
How to save data in database in mysql node
SQL
2 votes203 views1 answer
Oracle sql day of month from date
SQL