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

4 votes116 views1 answer
Postgresql list sequences
SQL
1 vote121 views1 answer
How to show index type in postgresql
SQL
1 vote110 views1 answer
Join to find results not in another table
SQL
0 vote127 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote138 views1 answer
Gcloud sql list databases
SQL
92 votes201 views6 answers
Substring
SQL
0 vote108 views1 answer
Eliminar ultimo carcacter mysql
SQL
-1 vote121 views1 answer
Sql add column bit
SQL
0 vote128 views2 answers
Insert data mysql with cmd
SQL
1 vote139 views1 answer
Sql server if exists update else insert
SQL