#include <stdio.h>
#include <stdlib.h>



EXEC SQL WHENEVER sqlerror sqlprint;
EXEC SQL WHENEVER sqlwarning sqlprint;
EXEC SQL WHENEVER not found sqlprint;



void main ()
{
	int i;
 EXEC SQL BEGIN DECLARE SECTION;
	
	char *strings[3];
 EXEC SQL END DECLARE SECTION;

	for (i = 0; i < 3; i++)
		strings[i] = (char *)malloc(sizeof(char) * 100);
	
	EXEC SQL CONNECT TO 'unix:postgresql://localhost/postgres' AS main USER ashutosh;

    EXEC SQL DECLARE cur1 CURSOR FOR  select relname from pg_class order by relname;

    EXEC SQL OPEN cur1;

    /* Fetch multiple columns into one structure. */
    EXEC SQL FETCH 3 FROM cur1 INTO :strings;

    for (i = 0; i < 3; i++)
    {
        /* Print members of the structure. */
        printf("relname=%s\n", strings[i]);
    }

    EXEC SQL CLOSE cur1;

	EXEC SQL DISCONNECT;
}