How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Viewing Postgres foreign tables

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

I have a few tables in Postgres created with the Foreign Data Wrapper (FDW). They are labeled with a type of 'foreign table' when I view with \d. I can't see them when I'm in DbVisualizer 9.2.5. Any help would be greatly appreciated. TIA, Scott I'm running postgres 9.4 and Product: DbVisualizer Pro 9.2.5 [Build #2431] OS: Mac OS X OS Version: 10.9.5 OS Arch: x86_64 Java Version: 1.7.0_75 Java VM: Java HotSpot(TM) 64-Bit Server VM Java Vendor: Oracle Corporation Java Home: /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home DbVis Home: /Applications/DbVisualizer.app/Contents/java/app Any suggestions to f
5 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: Viewing Postgres foreign tables
Hi Scott, DbVisualizer does not currently support FDWs. I have opened a ticket for looking into adding support for this database object type. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Viewing Postgres foreign tables
Hans, Thanks for your help. I did some additional testing with other tools and they had the same problem. This might be related to the postgres driver (JDBC?) not returning an accurate list of objects. I tested with Tableau and Squirrel SQL and both display same behavior. Scott
[This reply is migrated from our old forums.]

Re: Viewing Postgres foreign tables
Hi Scott, Thanks for the additional info. I noticed when I answered you initially that it is marked as an "experimental feature" or something like that in the PostgreSQL documentation. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Viewing Postgres foreign tables
Hi Scott, We just launched the BETA testing of the upcoming 9.5 version with a few improvements for PostgreSQL including support for foreign tables. 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

Hi Scott,


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

Login or Signup to post a comment
More topics in Support
See all 1311 topics