On Thu, 2022-01-13 at 09:49 +0000, 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 no straightforward way to do that.
What you could do is create a view on the remote database that provides the
required information and access that view via a foreign table.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com