dbeaver / dbeaver/dbeaver

Dump only DDL of the database (without data)

Open
#37,378 2 comments 0 reactions 0 assignees View on GitHub
x:postgresql xf:native clients
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
I'm always frustrated when I need to get the script of the database without data (only create-statements) so that I can give that script to another person without data.

**Describe the solution you'd like**
I suggest adding checkbox in menu: Tools -> Backup.
If it is set to true, the dump will be done with data, otherwise - without data (or vice versa).
pg_dump allows it easily.

**Describe alternatives you've considered**
I know there is an option: select all schemas and make use of "DDL" menu item.
But it behaves differently when scripting DDL.
For example, it doesn't script my own types ("CREATE TYPE") and maybe something else (looks like a bug, though).
I also want to get the sql-file rather than copy-paste text to clipboard and save it manually to the file.

**Additional context**
Add checkbox here:

![Image](https://github.com/user-attachments/assets/e808f155-3630-4f78-8299-9143cf24c294)

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.