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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM Studio-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO Studio
13  VALUES('DreamWorks SKG', 'Hollywood, CA', 3009);
14
15INSERT INTO Studio
16  VALUES('Disney', 'Hollywood, CA', 276);
17
18INSERT INTO Studio
19  VALUES('MCA/Universal Pictures', 'Hollywood, CA', 817);
20
21INSERT INTO Studio
22  VALUES('Paramount', 'Hollywood, CA', 1212);
23
24INSERT INTO Studio
25  VALUES('Warner Bros.', 'Hollywood, CA', 1222);
26
27INSERT INTO Studio
28  VALUES('Be Gentlemen Limited Partnership', 'Hollywood, CA', 3002);
29
30INSERT INTO Studio
31  VALUES('Miramax', 'Hollywood, CA', 413);
32
33INSERT INTO Studio
34  VALUES('Haft Entertainment', 'Hollywood, CA', 789);