Commita922472

committed

Supress non-temp schemas from psql \dn display.

1 parentafb09b5 commita922472Copy full SHA for a922472

File tree

-7

lines changed

-7

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.101 2003/12/01 22:21:54 momjian Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.102 2003/12/23 23:13:14 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -957,6 +957,7 @@ testdb=>`
`957`	`957`	`Lists all available schemas (namespaces). If <replaceable`
`958`	`958`	`class="parameter">pattern</replaceable> (a regular expression)`
`959`	`959`	`is specified, only schemas whose names match the pattern are listed.`
	`960`	`+ Non-local temporary schemas are suppressed.`
`960`	`961`	`</para>`
`961`	`962`	`</listitem>`
`962`	`963`	`</varlistentry>`

Lines changed: 7 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright (c) 2000-2003, PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.90 2003/12/01 22:21:54 momjian Exp $`
	`6`	`+ * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.91 2003/12/23 23:13:14 momjian Exp $`
`7`	`7`	`*/`
`8`	`8`	`#include"postgres_fe.h"`
`9`	`9`	`#include"describe.h"`
`@@ -1626,14 +1626,15 @@ listSchemas(const char *pattern)`
`1626`	`1626`
`1627`	`1627`	`initPQExpBuffer(&buf);`
`1628`	`1628`	`printfPQExpBuffer(&buf,`
`1629`		`-"SELECT n.nspname AS \"%s\",\n"`
`1630`		`-" u.usename AS \"%s\"\n"`
	`1629`	`+"SELECT n.nspname AS \"%s\",\n"`
	`1630`	`+" u.usename AS \"%s\"\n"`
`1631`	`1631`	`"FROM pg_catalog.pg_namespace n LEFT JOIN pg_catalog.pg_user u\n"`
`1632`		`-" ON n.nspowner=u.usesysid\n",`
	`1632`	`+" ON n.nspowner=u.usesysid\n"`
	`1633`	`+"WHERE(n.nspname NOT LIKE 'pg\\\\_temp\\\\_%%' OR\n"`
	`1634`	`+" n.nspname = (pg_catalog.current_schemas(true))[1])\n",/* temp schema is first */`
`1633`	`1635`	`_("Name"),`
`1634`	`1636`	`_("Owner"));`
`1635`		`-`
`1636`		`-processNamePattern(&buf,pattern, false, false,`
	`1637`	`+processNamePattern(&buf,pattern, true, false,`
`1637`	`1638`	`NULL,"n.nspname",NULL,`
`1638`	`1639`	`NULL);`
`1639`	`1640`

Comments

(0)