Postgresql DDL Index type not showing : DbVis Software

a

anonymous

started a topic about 9 years ago

[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);

Hans Bergsten

said about 9 years ago

[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

Roger Bjärevall

said over 8 years ago

[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

Hans Bergsten

said over 8 years ago

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

How can we help you today?

Postgresql DDL Index type not showing

anonymous

Hans Bergsten

Roger Bjärevall

Hans Bergsten