Re: PATCH: psql show index with type info

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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company