Seg fault on completing query

Hi,

I'm working on a frontend to a Postgresql database. I've chosen C in
which to work, mainly because I wanted to learn the language. So, I'm
using the pqlib frontend library. The C source I have is below. I
compile it (on linux) with gcc -g -Wall -lpq -oantibug antibug.c. When
I run the executable, it prints out the query to the screen ok, but also
prints a "Segmentation Fault" on completion of the list. Does anyone
know why? How can I prevent this?

Thanks,

Chris J

Source:

/**************************************************************
* A test C program to perform a SELECT query on tblantibiotic*
* on the bugswat database. *
**************************************************************/

#include <stdio.h>
#include <libpq-fe.h>
#include <stdlib.h>

void exit_nicely(PGconn * conn) {
PQfinish(conn);
printf("Abnormal exit");
exit(1);
}

int main() {
/* Declare variables for the connection and getting results */
int num_records;
PGconn *connect;
PGresult *res;
int i;
char *name;

/* Connect to the database */
connect = PQconnectdb("host = linux.chrisdomain dbname=antibugdb
user=cjewell");
if (PQstatus(connect) == CONNECTION_BAD) {
fprintf(stderr, "Could not connect to database");
fprintf(stderr, "Error: %s\n", PQerrorMessage(connect));
exit_nicely(connect);
}

/* Perform our query */
res = PQexec(connect, "SELECT * FROM tblactivity;");
if ((!res) || (PQresultStatus(res) != PGRES_TUPLES_OK)) {
fprintf(stderr, "SELECT query failed, error: %d\n",
PQresultStatus(res));
fprintf(stderr, "Server error: %s\n", PQerrorMessage(connect));
PQclear(res);
exit_nicely(connect);
}

num_records = PQntuples(res); /* put the number of tuples into
num_records */

/* Now print out the results to the screen */
for(i=0; i < num_records; ++i) {
sprintf(name, "%s", PQgetvalue(res, i, 0));
printf("%s\n", name);
}

PQclear(res);
PQfinish(connect);

return(0);

}

Output:

[cjewell(at)chris cprogs]$ ./antibug
good
some
poor
none
unknown
Segmentation fault
[cjewell(at)chris cprogs]$