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 vote132 views1 answer
Trigger vérifier stock
SQL
-1 vote157 views2 answers
Sql truncate number
SQL
0 vote125 views1 answer
Mariadb errno 121
SQL
0 vote123 views1 answer
Components/Fields of Internal Table
SQL
0 vote187 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote139 views2 answers
What is the default password for sql server sa
SQL
6 votes111 views5 answers
Get current date sql
SQL
7 votes119 views3 answers
How to check table name in current database sql
SQL
0 vote137 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote156 views1 answer
Gcloud sql instance list
SQL