C
C
Cyril2017-09-20 14:29:50
PostgreSQL
Cyril, 2017-09-20 14:29:50

How to map data types in MS Visio 2010?

Using ODBC, PostgreSQL (psqlodbc) imported all the necessary tables from the PostgreSQL database into a Visio document. When importing, no errors occur, everything is OK. But after the import, the field types in the imported tables do not match the field types of the tables that are in the PostgreSQL database. An example is below.
The role table , which in the PostgreSQL DB is:

CREATE TABLE "role" (
    id serial NOT NULL,
    "name" varchar(30) NOT NULL,
    "count" integer,
    description text,
    created_at integer,
    updated_at integer,
)

The role table in Visio after importing from the PostgreSQL database:
f112fbbd31904219be1783e45d457222.png
As you can see, the varchar(30) type of the name field in Visio has become longvarbinary , although the varchar type is present in Visio . The same problem with the description field , etc.
Where is the correct type mapping configured in Visio? So that when imported, varchar is varchar, and not something else.
Thank you!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question