Re: \dt doesn't show all relations in user's schemas (8.4.2)

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org, Ralph Graulich <ralph(dot)graulich(at)t-online(dot)de>
Subject: Re: \dt doesn't show all relations in user's schemas (8.4.2)
Date: 2009-12-22 13:08:53
Message-ID: 92869e660912220508n456c2f17tc5992b7d6f191f3b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/12/22 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

>
> Ahh, right, it's about visibility. Hadn't caught that part.
>

While it appears that the docs and utility are logically consistent, this is
SO counter-intuitive.

I was just scanning the man page from top to bottom, looking for a way to
show all tables...

diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 8533c29..d704776 100644
--- a/doc/src/sgml/ref/psql-ref.sgml
+++ b/doc/src/sgml/ref/psql-ref.sgml
@@ -877,7 +877,7 @@ testdb=&gt;
If <command>\d</command> is used without a
<replaceable class="parameter">pattern</replaceable> argument, it is
equivalent to <command>\dtvs</command> which will show a list of
- all tables, views, and sequences. This is purely a convenience
+ all visible tables, views, and sequences. This is purely a convenience
measure.
</para>
</note>

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2009-12-22 13:21:52 Not finding RPMs for 8.4.2!
Previous Message Pau Marc Munoz Torres 2009-12-22 10:39:06 Drop/ Alter index if exist