how to inesrt a row through postgres code example

Example 1: posgres insert

INSERT INTO films 
  (code, title, did, date_prod, kind)
    VALUES 
  ('T_601', 'Yojimbo', 106, '1961-06-16', 'Drama');

Example 2: sql multiple insert postgres

INSERT INTO User (name, surname, "roomId") // roomId is with quetes("") because it is case sensitive in this example
  VALUES 
    ('Joe', 'Travolta', 1),
    ('Jim', 'Carrey', 2),
    ('Shakira', 'whenever', 3); // remember about semicolon(;) at the end

Tags:

Sql Example

Related