- foreign_table_exposer 1.0.0
- Expose foreign tables as a regular table
This PostgreSQL extension exposes foreign tables like a normal table with rewriting Query tree. Some BI tools can't detect foreign tables since they don't consider them when getting table list from
pg_catalog.pg_class. With this extension those BI tools can detect foreign tables as well as normal tables.
$ make $ sudo make install
Write this line in your
postgresql.conf and then restart PostgreSQL.
shared_preload_libraries = 'foreign_table_exposer'
Execute this statement when you want to enable this feature.
CREATE EXTENSION foreign_table_exposer;
When you scan
pg_catalog.pg_class with a predicate like
relkind in ('r', 'v'), this extension automatically rewrites the query to include
'f' (foreign table).
postgres=# select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname; relname | nspname | relkind ------------------+---------+--------- normal_tbl | public | r foreign_tbl | public | f example_view | public | v (3 rows)