// Run a insert operation to store a new record
int insert() {
    // Connection stuff
    const char  *conninfo;
    PGconn      *conn;
    PGresult    *res;

    // User data
    char *name;
    char *last_p;
    char *last_m;
    char *birth;
    int phone;

    // Query parameters
    int         paramFormats[5] = {0,0,0,0,1};
    int         paramLengths[5];
    const char  *userData[5];

    // Try to connect to the server
    conninfo = "host=pghost user=user password=pass dbname=db";
    conn = PQconnectdb( conninfo );
    if( PQstatus( conn ) != CONNECTION_OK ) {
        fprintf( stderr, "Error de conexion con la base de datos: %s", PQerrorMessage( conn ) );
        PQfinish( conn );
        exit( 1 );
    }

    // Get the user data from standard input
    printf( "Nombre: " );
    scanf( "%s", &name );
    printf( "Apellido Paterno: " );
    scanf( "%s", &last_p );
    printf( "Apellido Materno: " );
    scanf( "%s", &last_m );
    printf( "Fecha de Nacimiento ( yyyy-mm-dd ): " );
    scanf( "%s", &birth );
    printf( "Numero de Telefono: " );
    scanf( "%d", phone );

    // Convert all to binary
    userData[0] = name;
    userData[1] = last_p;
    userData[2] = last_m;
    userData[3] = birth;
    userData[4] = (char *) htonl( (uint32_t) phone );
    paramLengths[0] = strlen( name );
    paramLengths[1] = strlen( last_p );
    paramLengths[2] = strlen( last_m );
    paramLengths[3] = strlen( birth );
    paramLengths[4] = sizeof( phone );


    // Insert it on the database
    res = PQexecParams( conn,
                "INSERT INTO directorio (nombre, apPaterno, apMaterno, festejo, telefono) VALUES ($1, $2, $3, $4, $5::bigint )",
                5,       //
                NULL,    // let the backend deduce param type
                userData,
                paramLengths,
                paramFormats,
                0 );
    if( PQresultStatus( res ) != PGRES_COMMAND_OK ) {
        fprintf( stderr, "Error al guardar el registro: %s", PQerrorMessage( conn ) );
        PQclear( res );
        PQfinish( conn );
        exit( 1 );
    } else {
        printf( "\n-> El registro fue creado exitosamente\n" );
        PQclear( res );
        PQfinish( conn );
        return 0;
    }
}