Debian Codegraph @

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

raw
1 #include <stdlib.h>
2 #include <string.h>
3 #include <stdlib.h>
4 #include <stdio.h>
5
6 exec sql include ../regression;
7
8 exec sql whenever sqlerror sqlprint;
9
10 int
11 main(void)
12 {
13 EXEC SQL BEGIN DECLARE SECTION;
14 int id;
15 EXEC SQL END DECLARE SECTION;
16
17 ECPGdebug(1, stderr);
18 EXEC SQL connect to REGRESSDB1;
19
20 EXEC SQL SET AUTOCOMMIT TO ON;
21 EXEC SQL WHENEVER SQLWARNING SQLPRINT;
22 EXEC SQL WHENEVER SQLERROR SQLPRINT;
23
24 EXEC SQL CREATE TABLE cta_test (id int);
25 EXEC SQL INSERT INTO cta_test values (100);
26
27 EXEC SQL CREATE TABLE IF NOT EXISTS cta_test1 AS SELECT * FROM cta_test;
28 EXEC SQL SELECT id INTO :id FROM cta_test1;
29 printf("ID = %d\n", id);
30
31 EXEC SQL CREATE TABLE cta_test2 AS SELECT * FROM cta_test WITH NO DATA;
32 EXEC SQL SELECT count(id) INTO :id FROM cta_test2;
33 printf("ID = %d\n", id);
34
35 EXEC SQL DROP TABLE cta_test;
36 EXEC SQL DROP TABLE cta_test1;
37 EXEC SQL DROP TABLE cta_test2;
38 EXEC SQL DISCONNECT all;
39
40 return 0;
41 }