On Sun, 2009-01-11 at 17:13 -0600, Tim Hart wrote: > Would it be worthwhile to specify this in the documentation? One of > the sources of my confusion was the following statement: > > http://www.postgresql.org/docs/8.3/interactive/app-psql.html: > > \distvS > "... to obtain a listing of all the matching objects..." > > I fully understand that 'foo' would need to be qualified when used in > sql, pl/pgsql, etc. > > I understood the documentation to read that all tables, views, and > sequences in the search path would be listed, not just those unobscured. > See the paragraph: "A pattern that contains a dot (.) is interpreted as a schema name pattern followed by an object name pattern. For example, \dt foo*.*bar* displays all tables whose table name includes bar that are in schemas whose schema name starts with foo. When no dot appears, then the pattern matches only objects that are visible in the current schema search path. Again, a dot within double quotes loses its special meaning and is matched literally." And: "Whenever the pattern parameter is omitted completely, the \d commands display all objects that are visible in the current schema search path — this is equivalent to using the pattern *. To see all objects in the database, use the pattern *.*. " Perhaps it could be a little clearer in the short descriptions, do you have a suggestion? Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
