test.pgc

application/octet-stream

Download

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

EXEC SQL BEGIN DECLARE SECTION;
     char dbname[1024];
EXEC SQL END DECLARE SECTION;

int main()
{
	EXEC SQL WHENEVER SQLWARNING SQLPRINT;
	EXEC SQL WHENEVER SQLERROR SQLPRINT;
	EXEC SQL WHENEVER SQLERROR STOP;

	/* ECPGdebug(1, stdout); */

	EXEC SQL CONNECT TO tcp:postgresql://localhost:5432/postgres?keepalives=1&keepalives_idle=1&keepalives_interval=1&keepalives_count=2 USER postgres;

	EXEC SQL SELECT current_database() INTO :dbname;
	printf("current=%s (should be postgres)\n", dbname);

	EXEC SQL DISCONNECT ALL;

	return 0;
}