Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it

Поиск
Список
Период
Сортировка
От Avi Weinberg
Тема Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
Дата
Msg-id DB9PR07MB71809309FB4B5AD42E458C58CB539@DB9PR07MB7180.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответы Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general

Hi Experts,

 

Is it possible to get the size of the table a foreign table is pointing to (without creating another connecting to the remote server)?  Obviously this "select pg_size_pretty(pg_total_relation_size('f_table'))" returns 0.

 

Thanks!

 

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

В списке pgsql-general по дате отправления:

Предыдущее
От: Issa Gorissen
Дата:
Сообщение: Re: WAL Archiving and base backup
Следующее
От: Shaozhong SHI
Дата:
Сообщение: How can a Postgres SQL script be automatically run when a new table turns up?