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

From ZCubes Wiki
Revision as of 00:53, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→‎REM REM REM PR-ins.sql REM REM: SELECT current_schema(); SET search_path to "pr-02"; INSERT INTO PR VALUES('a...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 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');