dbeaver / dbeaver/dbeaver

Data type is displayed not by Postgres

Open
#34,809 2 comments 4 reactions 0 assignees View on GitHub
wait for votes x:postgresql xf:metadata xf:ui
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

"Table 8.1 shows all the built-in general-purpose data types. Most of the alternative names listed in the “Aliases” column are the names used internally by PostgreSQL for historical reasons. In addition, some internally used or deprecated types are available, but are not listed here."

![photo_2024-06-24_14-48-08](https://github.com/user-attachments/assets/fd96aa46-8557-4d65-9c74-cbb1ee44e2d3)

Not names, but aliases are displayed by default. Switching to display by Postgres format was not detected.

### DBeaver Version

Community Edition 24.1.2-1

### Operating System

EndeavourOS

### Database and driver

1. The Postgres database is connected.
2. The data type is displayed not by Postgres, but by the general rule.

### Steps to reproduce

1. The Postgres database is connected.
2. The data type is displayed not by Postgres, but by the general rule.

### Additional context

I emailed support with this question, but they don't support the community version, so I'm asking the question in issue format here.

Basically, the problem is simple: in Datagrip, Postgres data type mapping works by default, I didn't find support for mapping in Dbeaver Community and my colleagues didn't see it either. Is there any support for Postgres data types at all and the possibility to switch to it?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.