Index: fe-exec.c
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/interfaces/libpq/fe-exec.c,v
retrieving revision 1.107
diff -u -r1.107 fe-exec.c
--- fe-exec.c	2001/08/17 15:11:15	1.107
+++ fe-exec.c	2001/08/22 15:58:40
@@ -56,6 +56,69 @@
 static int	getNotify(PGconn *conn);
 static int	getNotice(PGconn *conn);
 
+/* ---------------
+ * Escaping arbitrary strings to get valid SQL strings/identifiers.
+ *
+ * Replaces "\\" with "\\\\", "\0" with "\\0", "'" with "\\'", and 
+ * "\"" with "\\\"".  length is the length of the buffer pointed to by
+ * from.  The buffer at to must be at least 2*length + 1 characters
+ * long.  A terminating NUL character is written.
+ * ---------------
+ */
+
+size_t
+PGescapeString (char *to, const char *from, size_t length)
+{
+	const char *source = from;
+	char *target = to;
+	unsigned int remaining = length;
+
+	while (remaining > 0) {
+		switch (*source) {
+		case '\0':
+			*target = '\\';
+			target++;
+			*target = '0';
+			/* target and remaining are updated below. */
+			break;
+			
+		case '\\':
+			*target = '\\';
+			target++;
+			*target = '\\';
+			/* target and remaining are updated below. */
+			break;
+
+		case '\'':
+			*target = '\\';
+			target++;
+			*target = '\'';
+			/* target and remaining are updated below. */
+			break;
+
+		case '"':
+			*target = '\\';
+			target++;
+			*target = '"';
+			/* target and remaining are updated below. */
+			break;
+		
+		default:
+			*target = *source;
+			/* target and remaining are updated below. */
+		}
+		source++;
+		target++;
+		remaining--;
+	}
+
+	/* Write the terminating NUL character. */
+	*target = '\0';
+	
+	return target - to;
+}
+
+
 
 /* ----------------
  * Space management for PGresult.