Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Date
Msg-id 200106230000.f5N00km08631@candle.pha.pa.us
Whole thread Raw
In response to Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> I said:
> > Hm.  Shouldn't psql's \dS ignore temp items, since \d and \di do?
>
> Wait a sec --- I was confusing \dS (display system tables) with \ds
> (display sequences).  It looks like the latter should get it right
> already.


test=> \ds
No relations found.

> Possibly it does make sense to suppress temp items in \dS, but there
> isn't precedent for it.  We should discuss it on its own merits.

If we don't show temp items with \dS we need another backslash command
to show temp stuff.  Doesn't seem worth it, especially since we don't
show much info about temp stuff except that numeric name.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Next
From: Bruce Momjian
Date:
Subject: Re: use GUC for cmdline