Re: Toast table get list from instance

Thanks, I'll check it out.

On Thu, Jul 4, 2024, 3:54 PM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> wrote:

> You can use the following query to get the info from one database.
>
> SELECT nspname AS schema_name, c.relname AS toast_table_name, c.oid AS
> toast_table_oid, r.relname AS main_table_name FROM pg_class c JOIN
> pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_class r ON
> r.reltoastrelid = c.oid WHERE c.relkind = 't';
>
> But to get info from all the databases then you need to write a shell
> script which will first get all the databases and then run the above query
> on the all returned databases.
>
> Regards
> Kashif Zeeshan
>
> On Thu, Jul 4, 2024 at 2:52 PM Sathish Reddy <
> sathishreddy(dot)postgresql(at)gmail(dot)com> wrote:
>
>> Hi
>> Help me on getting all toast table information from instance level all
>> databases by using select querying in postgres .
>>
>>
>> Thanks
>> Sathish Reddy
>>
>