Function getFunctionName

src/bin/pg_dump/pg_dump.c:15867–15902

* getFunctionName - retrieves a function name from an oid * */

 *
 */
static char *
getFunctionName(Archive *fout, Oid oid)
{
	char	   *result;
	PQExpBuffer query;
	PGresult   *res;
	int			ntups;

	if (oid == InvalidOid)
	{
		return NULL;
	}

	query = createPQExpBuffer();

	appendPQExpBuffer(query, "SELECT proname FROM pg_proc WHERE oid = %u;",oid);

	res = ExecuteSqlQuery(fout, query->data, PGRES_TUPLES_OK);

	/* Expecting a single result only */
	ntups = PQntuples(res);
	if (ntups != 1)
	{
		pg_log_warning("query yielded %d rows instead of one: %s",
					   ntups, query->data);
		exit_nicely(1);
	}

	/* already quoted */
	result = pg_strdup(PQgetvalue(res, 0, 0));

	PQclear(res);
	destroyPQExpBuffer(query);

	return result;
}

/*
 * dumpExtProtocol