#include <stdio.h>
#include <string.h>
int main(){
  int i;
  EXEC SQL CONNECT TO "tcp:postgresql://192.168.70.59/db18000";
//EXEC SQL CONNECT TO db18000;でも可能
  EXEC SQL BEGIN DECLARE SECTION;
    int tel=0;
    char name[50]="";
  EXEC SQL END DECLARE SECTION;

  EXEC SQL DECLARE sample_Cursor CURSOR FOR
    SELECT * FROM sample ORDER BY tel;

  EXEC SQL OPEN sample_Cursor;

  printf("SQLSTATE| tel | name\n"); 
  printf("--------+-----+-------\n"); 

  EXEC SQL FETCH sample_Cursor INTO :tel,:name;
  while(!strcmp(sqlca.sqlstate,"00000")){
    printf("%8s|%5d|%s\n",sqlca.sqlstate,tel,name);  
    EXEC SQL FETCH sample_Cursor INTO :tel,:name;
  } 

  EXEC SQL CLOSE sample_Cursor;
  EXEC SQL DISCONNECT db18000;
  return 0;
}