aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-07-18 19:09:09 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-07-18 19:09:09 +0000
commitfdd84469f7e74b18eab908cdb8d7dcd6ded521d3 (patch)
tree91e44aff5f6e01aba85ca6bfc6af103833bd2986
parentadeede13916fadf53a63cc06d6301e30dac76f60 (diff)
downloadpostgresql-fdd84469f7e74b18eab908cdb8d7dcd6ded521d3.tar.gz
postgresql-fdd84469f7e74b18eab908cdb8d7dcd6ded521d3.zip
Avoid need for E'' construct by using regexp instead of LIKE. More
readable, and more like the other places in this file.
-rw-r--r--src/bin/psql/describe.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 9903771185f..806c1619876 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -3,7 +3,7 @@
*
* Copyright (c) 2000-2005, PostgreSQL Global Development Group
*
- * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.121 2005/07/18 17:40:14 tgl Exp $
+ * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.122 2005/07/18 19:09:09 tgl Exp $
*/
#include "postgres_fe.h"
#include "describe.h"
@@ -1766,7 +1766,7 @@ listSchemas(const char *pattern, bool verbose)
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_namespace n LEFT JOIN pg_catalog.pg_user u\n"
" ON n.nspowner=u.usesysid\n"
- "WHERE (n.nspname NOT LIKE E'pg\\\\_temp\\\\_%%' OR\n"
+ "WHERE (n.nspname !~ '^pg_temp_' OR\n"
" n.nspname = (pg_catalog.current_schemas(true))[1])\n"); /* temp schema is first */
processNamePattern(&buf, pattern, true, false,