make \d pg_toast.foo show its indices
От
Justin Pryzby
Тема
make \d pg_toast.foo show its indices
Дата
Msg-id
20190422154902.GH14223@telsasoft.com
Список
Дерево обсуждения
make \d pg_toast.foo show its indices Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices Rafia Sabih <rafia.pghackers@gmail.com>
Re: make \d pg_toast.foo show its indices Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices Rafia Sabih <rafia.pghackers@gmail.com>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Andres Freund <andres@anarazel.de>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices Stephen Frost <sfrost@snowman.net>
Re: make \d pg_toast.foo show its indices Robert Haas <robertmhaas@gmail.com>
Re: make \d pg_toast.foo show its indices Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table Alvaro Herrera <alvherre@2ndquadrant.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Fabien COELHO <coelho@cri.ensmp.fr>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace) Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Justin Pryzby <pryzby@telsasoft.com>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Fabien COELHO <coelho@cri.ensmp.fr>
Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions Fabien COELHO <coelho@cri.ensmp.fr>
It's deliberate that \dt doesn't show toast tables.
\d shows them, but doesn't show their indices.
It seems to me that their indices should be shown, without having to think and
know to query pg_index.
postgres=# \d pg_toast.pg_toast_2600
TOAST table "pg_toast.pg_toast_2600"
Column | Type
------------+---------
chunk_id | oid
chunk_seq | integer
chunk_data | bytea
Indexes:
"pg_toast_2600_index" PRIMARY KEY, btree (chunk_id, chunk_seq)
Justin
В списке pgsql-hackers по дате отправления
