|
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,
|
|