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

 1/*
 2REM
 3REM
 4REM MovieExec-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO MovieExec
13  VALUES('Debbie Allen', 'Hollywood, CA', 3009, 100);
14
15INSERT INTO MovieExec
16  VALUES('John Hughes', 'Hollywood, CA', 276, 500);
17
18INSERT INTO MovieExec
19  VALUES('Brian Grazer', 'Hollywood, CA', 817, 750);
20
21INSERT INTO MovieExec
22  VALUES('Wendy Finerman', 'Hollywood, CA', 1212, 500);
23
24INSERT INTO MovieExec
25  VALUES('Peter Guber', 'Hollywood, CA', 1222, 800);
26
27INSERT INTO MovieExec
28  VALUES('Su Armstrong', 'Hollywood, CA', 3002, 400);
29
30INSERT INTO MovieExec
31  VALUES('Letty Aronson', 'Hollywood, CA', 413,  500);
32
33INSERT INTO MovieExec
34  VALUES('Patrick Cassavetti', 'Hollywood, CA', 789, 300);