Postgres Pro
Downloads
Home   >   mailing lists

Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it - Mailing list pgsql-general

From Avi Weinberg
Subject Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
Date
Msg-id DB9PR07MB71809309FB4B5AD42E458C58CB539@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
List pgsql-general
Tree view

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 by date:

Previous
From: Issa Gorissen
Date:
Subject: Re: WAL Archiving and base backup
Next
From: Shaozhong SHI
Date:
Subject: How can a Postgres SQL script be automatically run when a new table turns up?