[Postgre] Insert Data into Postgre Tables

// Insert one row

INSERT INTO movies (title, release_date, count_stars, director_id) VALUES (
  'Kill Bill',
  '10-10-2003',
  3,
  1
);

 

// Insert multi rows

INSERT INTO movies (title, release_date, count_stars, director_id) VALUES (
  'Kill Bill',
  '10-10-2003',
  3,
  1
), (
  'Funny People',
  '07-20-2009',
  5,
  2
);

 

posted @ 2017-03-07 19:29  Zhentiw  阅读(192)  评论(0)    收藏  举报