Re: discover a toast table name

"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> How can I discover which toast table referenced to a phisic table?

Look at the base table's pg_class row.  reltoastrelid is the OID of the
corresponding toast table.  So, for example, if I thought "text_tbl" had
such a problem:

regression=# select relname from pg_class where
regression-# oid = (select reltoastrelid from pg_class where relname = 'text_tbl');    relname
-----------------pg_toast_163219
(1 row)

regression=# reindex table pg_toast.pg_toast_163219;
REINDEX
regression=#
        regards, tom lane