Index: describe.c =================================================================== RCS file: /home/ncvs/pgsql/pgsql-server/src/bin/psql/describe.c,v retrieving revision 1.85 diff -u -r1.85 describe.c --- describe.c 7 Sep 2003 03:43:53 -0000 1.85 +++ describe.c 13 Oct 2003 19:32:48 -0000 @@ -1589,7 +1589,12 @@ processNamePattern(&buf, pattern, false, false, NULL, "n.nspname", NULL, NULL); + if (pattern == NULL) + appendPQExpBuffer(&buf, "WHERE "); + else + appendPQExpBuffer(&buf, " AND "); + appendPQExpBuffer(&buf, "n.nspname NOT LIKE 'pg_temp_%%'\n"); appendPQExpBuffer(&buf, "ORDER BY 1;"); res = PSQLexec(buf.data, false);