Postgres Stempipe Research
Check PG foreign server select srvname as name, srvowner::regrole as owner, fdwname as wrapper, srvoptions as options from pg_foreign_server join pg_foreign_data_wrapper w on w.oid = srvfdw; Here is an example of creating a foreign table with postgres_fdw . First install the extension: https://steampipe.io/ https://turbot.com/pipes/docs/integrations/grafana https://turbot.com/pipes/docs https://aws.amazon.com/ko/blogs/opensource/compliance-auditing-with-steampipe-and-sql/ https://hub.steampipe.io/plugins/turbot/aws#multi-account-connections https://community.grafana.com/t/consolidate-data-from-multiple-datasources-sites-on-same-graph-panel/2496 CREATE EXTENSION postgres_fdw; Then create a foreign server using CREATE SERVER . In this example we wish to connect to a PostgreSQL server on host 192.83.123.89 listening on port 5432 . The database to which the connection is made is named foreign_db on the remote server: CREATE SERVER foreign_server