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 vote331 views1 answer
Tsql cmd exec script from file
SQL
5 votes411 views1 answer
Oracle drop index if exists
SQL
-1 vote345 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote384 views1 answer
Get role postgres
SQL
0 vote370 views1 answer
Sql server alter table add column tinyint
SQL
0 vote350 views4 answers
How to connect form to database
SQL
0 vote381 views1 answer
Table structure in sql
SQL
28 votes358 views4 answers
Delete database mysql
SQL
0 vote356 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote344 views1 answer
Services.AddDbContext DataSource Sqlite
SQL