Start a new topic

PostgreSQL Show Foreign Tables in Objects Tree

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Foreign Data Wrappers are new in PostgreSQL 9.1, since 9.3 they're writeable too. In DBVisualizer I can't see Foreign Tables in the Objects-Tree. On PostgreSQL-Shell you can list the table with \det postgres=# \det List of foreign tables Schema | Table | Server --------+-------------+------------------- public | other_world | postgres_fdw_test (1 row) DBVis 9.2.12 Pro PostgreSQL 9.4.5 PostgreSQL Native Driver PostgreSQL 9.3 JDBC4 (build 1102)

[This reply is migrated from our old forums.]

Re: PostgreSQL Show Foreign Tables in Objects Tree
Hi, We are looking at adding support for Foreign Tables and related object types in the next feature version. I'll add your vote for this. You can use them in an SQL Commander tab today, even though they are not shown in the tree. Best Regards, hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: PostgreSQL Show Foreign Tables in Objects Tree
+1 for this feature! The table list seems to be available in pg_catalog.pg_foreign_table.
[This reply is migrated from our old forums.]

Re: PostgreSQL Show Foreign Tables in Objects Tree
Hi Jonas, I'll add your vote. As I said earlier, it is in the works for the next feature release. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: PostgreSQL Show Foreign Tables in Objects Tree
Hi, We just launched the BETA testing of the upcoming 9.5 version with a few improvements for PostgreSQL. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger

I just wanted to let you know that we have released DbVisualizer 9.5 yesterday with support for the feature you asked for. Easiest way to upgrade is that you open Help->Check for Update in DbVisualizer to perform the upgrade.

An alternative is that you download from our web site: 

http://www.dbvis.com/download/

Best Regards,

Hans