|
6 | 6 | * Portions Copyright (c) 1994, Regents of the University of California |
7 | 7 | * |
8 | 8 | * |
9 | | - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.63 2005/07/08 16:51:30 tgl Exp $ |
| 9 | + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.64 2005/07/18 19:12:09 tgl Exp $ |
10 | 10 | * |
11 | 11 | *------------------------------------------------------------------------- |
12 | 12 | */ |
@@ -543,10 +543,10 @@ dumpTablespaces(PGconn *conn) |
543 | 543 | * pg_xxx) |
544 | 544 | */ |
545 | 545 | res=executeQuery(conn,"SELECT spcname, " |
546 | | -"pg_catalog.pg_get_userbyid(spcowner) AS spcowner, " |
| 546 | +"pg_catalog.pg_get_userbyid(spcowner) AS spcowner, " |
547 | 547 | "spclocation, spcacl " |
548 | 548 | "FROM pg_catalog.pg_tablespace " |
549 | | -"WHERE spcname NOT LIKEE'pg\\_%'"); |
| 549 | +"WHERE spcname NOT LIKE 'pg!_%' ESCAPE '!'"); |
550 | 550 |
|
551 | 551 | if (PQntuples(res)>0) |
552 | 552 | printf("--\n-- Tablespaces\n--\n\n"); |
|