Debian Codegraph @

src/interfaces/ecpg/test/sql/show.pgc

raw
1 #include <stdio.h>
2 #include <stdlib.h>
3 #include <string.h>
4
5 EXEC SQL INCLUDE ../regression;
6
7 int main() {
8 EXEC SQL BEGIN DECLARE SECTION;
9 char var[25] = "public";
10 EXEC SQL END DECLARE SECTION;
11
12 ECPGdebug(1, stderr);
13 EXEC SQL CONNECT TO REGRESSDB1;
14
15 EXEC SQL WHENEVER SQLWARNING SQLPRINT;
16 EXEC SQL WHENEVER SQLERROR SQLPRINT;
17
18 EXEC SQL SET search_path TO :var;
19 EXEC SQL SHOW search_path INTO :var;
20 printf("Var: Search path: %s\n", var);
21
22 EXEC SQL SET search_path TO 'public';
23 EXEC SQL SHOW search_path INTO :var;
24 printf("Var: Search path: %s\n", var);
25
26 EXEC SQL SET standard_conforming_strings TO off;
27 EXEC SQL SHOW standard_conforming_strings INTO :var;
28 printf("Var: Standard conforming strings: %s\n", var);
29
30 EXEC SQL SET TIME ZONE PST8PDT;
31 EXEC SQL SHOW TIME ZONE INTO :var;
32 printf("Time Zone: %s\n", var);
33
34 EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
35 EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
36 printf("Transaction isolation level: %s\n", var);
37
38 EXEC SQL DISCONNECT ALL;
39
40 return 0;
41 }