#include <stdio.h>


int main(void)
{
EXEC SQL BEGIN DECLARE SECTION;

	typedef struct {
		char name[100];
	} st_foo1;

	typedef struct {
		long count;
		st_foo1 *adr;
	}st_foo2;
	
	st_foo2 var_foo2;
	
EXEC SQL END DECLARE SECTION;

	foo2.adr = malloc(sizeof(st_foo1));

    EXEC SQL CONNECT TO "tcp:postgresql://localhost:5432/test" USER "postgres";
	
    EXEC SQL CREATE TABLE foo_tbl (id int, data text);
	EXEC SQL COMMIT;

	EXEC SQL INSERT INTO foo_tbl VALUES (1, 'some text data');
	EXEC SQL COMMIT;

	EXEC SQL SELECT data INTO :var_foo2.adr->name FROM foo_tbl WHERE id = 1;

	EXEC SQL DROP TABLE foo_tbl;
	EXEC SQL COMMIT;
    EXEC SQL DISCONNECT;

    return 0;
}