dbeaver / dbeaver/dbeaver

Newly created schema merges into default postgres database on its own

Open
#37,710 2 comments 0 reactions 0 assignees View on GitHub
x:postgresql
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

I am unsure if this is a bug with DBeaver or Postgres (or intended behavior), but after creating a new database and schema, importing data from a CSV file, and reloading the database connection, odd behavior occurs.

The newly created database does not appear in DBeaver (but is present and empty in psql). In addition, the schema and tables appear under the default postgres database instead.

In addition, this problem seems to completely vanish after altering the "Database:" setting in Connection Settings from "postgres" to "Small_Examples" (the name of the database I created). When I revert the setting back to the default "postgres", any new database and tables do not follow the above behavior and are created properly.

I have attached various images of the issue.

![Image](https://github.com/user-attachments/assets/b9619a9d-276a-4dd5-91da-8a7cd935a099)

![Image](https://github.com/user-attachments/assets/a21d31ad-505e-48fe-9243-9393596cc0da)

![Image](https://github.com/user-attachments/assets/ba928a1e-eaae-4732-a45a-717c3b11fa7b)

![Image](https://github.com/user-attachments/assets/dfb27afb-50a0-4cde-a50c-882d4b17afcb)

As shown, the "Small_Examples" database appears in psql, but is empty. The newly created schema, "company", appears under the default postgres database.

### DBeaver Version

Community Edition 25.0.1.202503302330

### Operating System

Fedora Silverblue 41 / MacOS Sequoia / Windows 11

### Database and driver

PostgreSQL 16.8
PostgreSQL JDBC Driver 42.7.2

### Steps to reproduce

1. Create a new database ("Small_Examples")
2. Create a new schema ("company")
3. Import CSVs into the schema to create new tables
4. Reload the database connection

### Additional context

No extensions loaded, fresh installation of DBeaver and PostgreSQL

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.