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 vote202 views1 answer
Round one decimal place mysql
SQL
0 vote196 views1 answer
Mysql insert into select transaction c#
SQL
0 vote189 views1 answer
Postgres declare variable
SQL
0 vote190 views1 answer
Oracle merge insert if not exists
SQL
0 vote207 views1 answer
Oracle current date minus 1 day
SQL
0 vote187 views1 answer
Migrations.RunSQL
SQL
0 vote196 views1 answer
MySQL get all previous date record
SQL
0 vote204 views1 answer
Selecting all columns from table sql database
SQL
3 votes218 views2 answers
@sqlresultsetmapping
SQL
3 votes216 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL