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

2022-01-13 Thread Laurenz Albe
On Thu, 2022-01-13 at 09:49 +, Avi Weinberg wrote: > 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. No, there is

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

2022-01-13 Thread Avi Weinberg
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 intende