diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-18 19:12:09 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-18 19:12:09 +0000 |
| commit | affcb4371c35d2f0a2ac8fd3547be4fc1248367c (patch) | |
| tree | c2325463da4f7c51767ca2216be9b8f6fb1ce036 /src | |
| parent | fdd84469f7e74b18eab908cdb8d7dcd6ded521d3 (diff) | |
| download | postgresql-affcb4371c35d2f0a2ac8fd3547be4fc1248367c.tar.gz postgresql-affcb4371c35d2f0a2ac8fd3547be4fc1248367c.zip | |
Avoid use of E'', and thereby creating an unnecessary version-dependency,
by using LIKE...ESCAPE instead. Per suggestion by andrew@supernews.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dumpall.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/bin/pg_dump/pg_dumpall.c b/src/bin/pg_dump/pg_dumpall.c index a8983699850..795f45d23be 100644 --- a/src/bin/pg_dump/pg_dumpall.c +++ b/src/bin/pg_dump/pg_dumpall.c @@ -6,7 +6,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.63 2005/07/08 16:51:30 tgl Exp $ + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.64 2005/07/18 19:12:09 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -543,10 +543,10 @@ dumpTablespaces(PGconn *conn) * pg_xxx) */ res = executeQuery(conn, "SELECT spcname, " - "pg_catalog.pg_get_userbyid(spcowner) AS spcowner, " + "pg_catalog.pg_get_userbyid(spcowner) AS spcowner, " "spclocation, spcacl " "FROM pg_catalog.pg_tablespace " - "WHERE spcname NOT LIKE E'pg\\_%'"); + "WHERE spcname NOT LIKE 'pg!_%' ESCAPE '!'"); if (PQntuples(res) > 0) printf("--\n-- Tablespaces\n--\n\n"); |