diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-18 19:09:09 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-18 19:09:09 +0000 |
commit | fdd84469f7e74b18eab908cdb8d7dcd6ded521d3 (patch) | |
tree | 91e44aff5f6e01aba85ca6bfc6af103833bd2986 | |
parent | adeede13916fadf53a63cc06d6301e30dac76f60 (diff) | |
download | postgresql-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.c | 4 |
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, |