|
3 | 3 | * |
4 | 4 | * Copyright (c) 2000-2005, PostgreSQL Global Development Group |
5 | 5 | * |
6 | | - * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.121 2005/07/1817:40:14 tgl Exp $ |
| 6 | + * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.122 2005/07/1819:09:09 tgl Exp $ |
7 | 7 | */ |
8 | 8 | #include"postgres_fe.h" |
9 | 9 | #include"describe.h" |
@@ -1766,7 +1766,7 @@ listSchemas(const char *pattern, bool verbose) |
1766 | 1766 | appendPQExpBuffer(&buf, |
1767 | 1767 | "\nFROM pg_catalog.pg_namespace n LEFT JOIN pg_catalog.pg_user u\n" |
1768 | 1768 | " ON n.nspowner=u.usesysid\n" |
1769 | | -"WHERE(n.nspnameNOT LIKE E'pg\\\\_temp\\\\_%%' OR\n" |
| 1769 | +"WHERE(n.nspname!~ '^pg_temp_' OR\n" |
1770 | 1770 | " n.nspname = (pg_catalog.current_schemas(true))[1])\n");/* temp schema is first */ |
1771 | 1771 |
|
1772 | 1772 | processNamePattern(&buf,pattern, true, false, |
|