Re: Toast table get list from instance
| От | Kashif Zeeshan |
|---|---|
| Тема | Re: Toast table get list from instance |
| Дата | |
| Msg-id | CAAPsdhc7vusYTz_1y2n1M=P4gJ7D-6VwRMmebcnuXQHTaPKnpQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Toast table get list from instance (Sathish Reddy <sathishreddy.postgresql@gmail.com>) |
| Ответы |
Re: Toast table get list from instance
|
| Список | pgsql-admin |
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.postgresql@gmail.com> wrote:
HiHelp me on getting all toast table information from instance level all databases by using select querying in postgres .ThanksSathish Reddy
В списке pgsql-admin по дате отправления: