From 7c76906b7e24d9ea94a2b0e33396ebcac600437d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 9 Apr 2011 14:08:41 -0400 Subject: Don't show unusable collations in psql's \dO command. "Unusable" collations are those not matching the current database's encoding. The former behavior inconsistently showed such collations some of the time, depending on the details of the pattern argument. --- doc/src/sgml/ref/psql-ref.sgml | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 24e8ee0a368..ac351d32d42 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1264,7 +1264,7 @@ testdb=> \dL[S+] [ pattern ] - Lists all procedural languages. If pattern is specified, only languages whose names match the pattern are listed. By default, only user-created languages @@ -1311,7 +1311,6 @@ testdb=> \dO[S+] [ pattern ] - Lists collations. @@ -1320,8 +1319,11 @@ testdb=> listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If + is appended - to the command name, each object is listed with its associated + to the command name, each collation is listed with its associated description, if any. + Note that only collations usable with the current database's encoding + are shown, so the results may vary in different databases of the + same installation. -- cgit v1.2.3