Yurttas/PL/DBL/postgres/F/01/PR/02/PR-ins.sql

 1/*
 2REM
 3REM
 4REM PR-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "pr-02";
11
12INSERT INTO PR
13  VALUES('a1', 'c1', 'd1');
14
15INSERT INTO PR
16  VALUES('a1', 'c2', 'd1');
17
18INSERT INTO PR
19  VALUES('a1', 'c1', 'd2');
20
21INSERT INTO PR
22  VALUES('a2', 'c2', 'd2');
23
24INSERT INTO PR
25  VALUES('a3', 'c1', 'd2');
26
27INSERT INTO PR
28  VALUES('a3', 'c2', 'd2');
29
30INSERT INTO PR
31  VALUES('a3', 'c3', 'd1');
32
33INSERT INTO PR
34  VALUES('a3', 'c3', 'd2');