copy_from_ok.pgc

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

EXEC SQL WHENEVER SQLERROR CALL die();
EXEC SQL WHENEVER NOT FOUND DO BREAK;

void
die(void)
{
    fprintf(stderr, "%s\n", sqlca.sqlerrm.sqlerrmc);
    exit(1);
}

int
main(void)
{
    EXEC SQL BEGIN DECLARE SECTION;
    const char *target = "postgres@localhost:5432";
    const char *user = "ryo";
    const char *passwd = "";
    EXEC SQL END DECLARE SECTION;

    EXEC SQL CONNECT TO :target USER :user USING :passwd;
    EXEC SQL COPY name_age_list FROM './test_ecpg.out';
    EXEC SQL COMMIT;
    EXEC SQL DISCONNECT ALL;

    return 0;
}