Re: PATCH: psql show index with type info

* Robert Haas (robertmhaas(at)gmail(dot)com) wrote:
> On Mon, Mar 6, 2017 at 9:30 AM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> > * Amos Bird (amosbird(at)gmail(dot)com) wrote:
> >> Well, the prefix is used to differentiate other \d commands, like
> >> this,
> >
> > Ah, ok, fair enough.
> >
> > Should we consider differentiating different table types also? I
> > suppose those are primairly just logged and unlogged, but I could see
> > that being useful information to know when doing a \dt. Not a big deal
> > either way though, and this patch stands on its own certainly.
>
> Logged vs. unlogged isn't the same thing as identifying the access
> method. Anything with storage can come in logged, unlogged, and
> temporary varieties, but an access method is essentially a way of
> saying that one object has a different physical layout than another.
> Right now there is, indeed, only one heap access method, but some of
> my colleagues and I are scheming over how to change that.

Fair enough, sounds like a good reason to add an Access Method column to
me.

Thanks!

Stephen