pg_dump patch: Allow -X'exclude table from dump by pattern'

diff -u pg_dump.orig/pg_dump.c pg_dump.exclude/pg_dump.c
--- pg_dump.orig/pg_dump.c	Thu Aug 16 20:36:43 2001
+++ pg_dump.exclude/pg_dump.c	Wed Aug 22 11:20:56 2001
@@ -145,6 +145,7 @@
 
 #include <unistd.h>				/* for getopt() */
 #include <ctype.h>
+#include <fnmatch.h>
 
 #include "pg_backup.h"
 
@@ -204,6 +205,8 @@
 static PQExpBuffer getPKconstraint(TableInfo *tblInfo, IndInfo *indInfo);
 static const char *getAttrName(int attrnum, TableInfo *tblInfo);
 
+int isTableExcluded(const char *table);
+
 extern char *optarg;
 extern int	optind,
 			opterr;
@@ -228,6 +231,10 @@
 char		g_comment_start[10];
 char		g_comment_end[10];
 
+/* exclude table from dump by patterns */
+#define MAX_EXCLUDE_TABLE_PATTERNS	32
+char	   *excludetable[MAX_EXCLUDE_TABLE_PATTERNS];
+
 
 typedef struct _dumpContext
 {
@@ -268,6 +275,7 @@
 		 "  -S, --superuser=NAME     specify the superuser user name to use in plain\n"
 		 "                           text format\n"
 	  "  -t, --table=TABLE        dump for this table only (* for all)\n"
+	  "  -X, --exclude-table=TABLE        exclude  this table from dump (* allowed)\n"
 		 "  -u, --password           use password authentication\n"
 		 "  -v, --verbose            verbose\n"
 		 "  -x, --no-acl             do not dump ACL's (grant/revoke)\n"
@@ -297,6 +305,7 @@
 		 "  -S NAME                  specify the superuser user name to use in plain\n"
 		 "                           text format\n"
 	  "  -t TABLE                 dump for this table only (* for all)\n"
+	  "  -X TABLE                exclude  this table from dump (* allowed)\n"
 		 "  -u                       use password authentication\n"
 		 "  -v                       verbose\n"
 		 "  -x                       do not dump ACL's (grant/revoke)\n"
@@ -666,7 +675,7 @@
 		if (tblinfo[i].sequence)/* already dumped */
 			continue;
 
-		if (!onlytable || (strcmp(classname, onlytable) == 0) || (strlen(onlytable) == 0))
+		if ( (! isTableExcluded(classname)) && (!onlytable || (strcmp(classname, onlytable) == 0) || (strlen(onlytable) == 0)))
 		{
 			if (g_verbose)
 				fprintf(stderr, "%s preparing to dump out the contents of Table '%s' %s\n",
@@ -750,6 +759,7 @@
 		{"schema-only", no_argument, NULL, 's'},
 		{"superuser", required_argument, NULL, 'S'},
 		{"table", required_argument, NULL, 't'},
+		{"exclude-table", required_argument, NULL, 'X'},
 		{"password", no_argument, NULL, 'u'},
 		{"verbose", no_argument, NULL, 'v'},
 		{"no-acl", no_argument, NULL, 'x'},
@@ -770,6 +780,13 @@
 
 	dataOnly = schemaOnly = dumpData = attrNames = false;
 
+	
+	{
+		int i=0;	
+		for(i=0; i< MAX_EXCLUDE_TABLE_PATTERNS; i++)
+			excludetable[i] = NULL;
+	}
+	
 	if (!strrchr(argv[0], SEP_CHAR))
 		progname = argv[0];
 	else
@@ -797,9 +814,9 @@
 	}
 
 #ifdef HAVE_GETOPT_LONG
-	while ((c = getopt_long(argc, argv, "abcCdDf:F:h:inNoOp:RsS:t:uvxzZ:V?", long_options, &optindex)) != -1)
+	while ((c = getopt_long(argc, argv, "abcCdDf:F:h:inNoOp:RsS:t:uvxzZ:X:V?", long_options, &optindex)) != -1)
 #else
-	while ((c = getopt(argc, argv, "abcCdDf:F:h:inNoOp:RsS:t:uvxzZ:V?-")) != -1)
+	while ((c = getopt(argc, argv, "abcCdDf:F:h:inNoOp:RsS:t:uvxzZ:X:V?-")) != -1)
 #endif
 
 	{
@@ -918,6 +935,45 @@
 				}
 				break;
 
+			case 'X':			/* Exclude this table from dump*/
+				{
+					int			i;
+					char 			*s;
+
+					s = strdup(optarg);
+
+	printf("-- Exclude table:%s\n", s);
+					/*
+					 * quoted string? Then strip quotes and preserve
+					 * case...
+					 */
+					if (s[0] == '"')
+					{
+						strcpy(s, &s[1]);
+						if (*(s + strlen(s) - 1) == '"')
+							*(s + strlen(s) - 1) = '\0';
+					}
+					/* otherwise, convert table name to lowercase... */
+					else
+					{
+						for (i = 0; s[i]; i++)
+							if (isupper((unsigned char) s[i]))
+								s[i] = tolower((unsigned char) s[i]);
+
+					}
+					
+					// Save the exclude pattern to the exclude array
+					i=0;
+					while(i < MAX_EXCLUDE_TABLE_PATTERNS) {
+						if (!excludetable[i]){
+							excludetable[i] = s;
+							break;
+						} else
+							i++;
+					}		
+				}
+				break;
+
 			case 'u':
 				use_password = true;
 				break;
@@ -4057,8 +4113,8 @@
 	{
 		if (!(tblinfo[i].sequence))
 			continue;
-		if (!tablename || (!strcmp(tblinfo[i].relname, tablename))
-			|| (serialSeq && !strcmp(tblinfo[i].relname, serialSeq)))
+		if ((!isTableExcluded(tblinfo[i].relname)) && (!tablename || (!strcmp(tblinfo[i].relname, tablename))
+			|| (serialSeq && !strcmp(tblinfo[i].relname, serialSeq))))
 		{
 			/* becomeUser(fout, tblinfo[i].usename); */
 			dumpSequence(fout, tblinfo[i], schemaOnly, dataOnly);
@@ -4074,7 +4130,7 @@
 		if (tblinfo[i].sequence)/* already dumped */
 			continue;
 
-		if (!tablename || (!strcmp(tblinfo[i].relname, tablename)) || (strlen(tablename) == 0))
+		if ( (!isTableExcluded(tblinfo[i].relname)) && (!tablename || (!strcmp(tblinfo[i].relname, tablename)) || (strlen(tablename) == 0)))
 		{
 
 			resetPQExpBuffer(delq);
@@ -4472,7 +4528,7 @@
 			}
 		}
 
-		if (!tablename || (strcmp(indinfo[i].indrelname, tablename) == 0) || (strlen(tablename) == 0))
+		if ( (! isTableExcluded(indinfo[i].indrelname)) && (!tablename || (strcmp(indinfo[i].indrelname, tablename) == 0) || (strlen(tablename) == 0)))
 		{
 			resetPQExpBuffer(id1);
 			resetPQExpBuffer(id2);
@@ -4844,7 +4900,7 @@
 
 	for (i = 0; i < numTables; i++)
 	{
-		if (tablename && (strcmp(tblinfo[i].relname, tablename) != 0) && (strlen(tablename) > 0))
+		if ( isTableExcluded(tblinfo[i].relname) ||  (tablename && (strcmp(tblinfo[i].relname, tablename) != 0) && (strlen(tablename) > 0)))
 			continue;
 
 		for (j = 0; j < tblinfo[i].ntrig; j++)
@@ -4882,7 +4938,7 @@
 	 */
 	for (t = 0; t < numTables; t++)
 	{
-		if (tablename && (strcmp(tblinfo[t].relname, tablename) != 0) && (strlen(tablename) > 0))
+		if ( isTableExcluded(tblinfo[t].relname) ||  (tablename && (strcmp(tblinfo[t].relname, tablename) != 0) && (strlen(tablename) > 0)))
 			continue;
 
 		/*
@@ -4938,4 +4994,20 @@
 
 		PQclear(res);
 	}
+}
+
+int isTableExcluded(const char *table) {
+	int check=false;
+	int i=0;
+	
+	while (i < MAX_EXCLUDE_TABLE_PATTERNS && excludetable[i] ) {
+		if (! fnmatch(excludetable[i], table, FNM_PATHNAME)) {
+			check=1;
+			break;
+		}
+		i++;
+	}
+
+	return(check);
+
 }