Start a new topic

Postgresql DDL Index type not showing

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

When I look at the DDL for an index associated with a table it won't tell me what type of index its using ex. Using DB Visualizer: CREATE INDEX tag_index ON tag ( DATETIME ); Using PGAdmin3 and others: CREATE INDEX tag_index ON tag USING BTREE (datetime);

[This reply is migrated from our old forums.]

Re: Postgresql DDL Index type not showing
Hi Willem, I have opened a ticket for looking into this when we go through the PostgreSQL support for the next feature version. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Postgresql DDL Index type not showing
Willem, We just launched the BETA testing of the upcoming 9.5 version with a few improvements for PostgreSQL including a fix for the issue you reported. 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 Willem,


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