Jerry Sievers <gsievers19@xxxxxxxxxxx> writes: > ProPAAS DBA <dba@xxxxxxxxxxx> writes: >> pg_toast.pg_toast_16784 >> How do I find the primary table for this toast table? > Find the pg_class row with reltoastrelid = $oid-of-toast-table. After you've done that a couple of times, you'll notice that the numeric part of the toast table's name is the OID of its parent, so really you just need to do select '16784'::regclass; Confirming the reltoastrelid link is a good idea though. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
