Yurttas/PL/DBL/postgres/F/01/Movies/MovieStar-ins.sql

 1/*
 2REM
 3REM
 4REM MovieStar-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO MovieStar
13  VALUES('Djimon Hounsou', 'Paris FR', 'M', 1970);
14
15INSERT INTO MovieStar
16  VALUES('Anthony Hopkins', 'Port Talbort, Wales UK', 'M', 1937);
17
18INSERT INTO MovieStar
19  VALUES('Ming-Na Wen', NULL, 'F', NULL);
20
21INSERT INTO MovieStar
22  VALUES('Eddie Murphy', NULL, 'M', NULL);
23
24INSERT INTO MovieStar
25  VALUES('Tom Hanks', NULL, 'M', NULL);
26
27INSERT INTO MovieStar
28  VALUES('Ed Harris', NULL, 'M', NULL);
29
30INSERT INTO MovieStar
31  VALUES('Bill Paxton', NULL, 'M', NULL);
32
33INSERT INTO MovieStar
34  VALUES('Sally Field', NULL, 'F', NULL);
35
36INSERT INTO MovieStar
37  VALUES('Liam Neeson', NULL, 'M', NULL);
38
39INSERT INTO MovieStar
40  VALUES('Ben Kingsley', NULL, 'M', NULL);
41
42INSERT INTO MovieStar
43  VALUES('Danny Glover', NULL, 'M', NULL);
44
45INSERT INTO MovieStar
46  VALUES('Whoopi Goldberg', NULL, 'F', NULL);
47
48INSERT INTO MovieStar
49  VALUES('Robin Williams', NULL, 'M', NULL);
50
51INSERT INTO MovieStar
52  VALUES('Marcia Gay Harden', NULL, 'F', NULL);
53
54INSERT INTO MovieStar
55  VALUES('Mat Damon', NULL, 'M', NULL);
56
57INSERT INTO MovieStar
58  VALUES('John Cusak', NULL, 'M', NULL);
59
60INSERT INTO MovieStar
61  VALUES('Jack Warden', NULL, 'M', NULL);
62
63INSERT INTO MovieStar
64  VALUES('Gwyneth Paltrow', NULL, 'F', NULL);
65
66INSERT INTO MovieStar
67  VALUES('James Cosmo', NULL, 'M', NULL);