Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is free and open source (GPL) universal database tool for developers and database administrators.

DBeaver is free and open source (GPL) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on opensource framework and allows writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD).
535 questions
76
votes
4 answers

Export result set on Dbeaver to CSV

Normally I use Dbeaver for windows and always export my result set like this: Run my query --> select the result --> export the result set --> select export to clipboard --> done This step by step puts my result set in my clipboard and I can paste…
Rafael Meirelles
  • 833
  • 1
  • 6
  • 9
71
votes
8 answers

Recover DB password stored in my DBeaver connection

I forgot the password of a dev instance (irresponsible.. yeah, I am working on it). I have the connection saved in my DBeaver with the password. I am still able to connect using that connection. DBeaver is not showing it in plain text. Is there…
Git_gal
  • 713
  • 1
  • 6
  • 5
44
votes
6 answers

How to switch the capitals characters transform in DBeaver?

The SQL editor in DBeaver has this unsupportable feature of transforming all capital characters into lower case. This happens as you type, the most schizophrenic thing. I have searched in the menus and the Preferences dialogue, but I can not find…
Luís de Sousa
  • 3,801
  • 7
  • 40
  • 71
42
votes
5 answers

Ubuntu Dbeaver backup database

I have Dbeaver installed and I have a connection to a PostgreSQL database on a remote server. I'd like to export this database to my local PC but when I go to Tools -> Backup database I see an error Client home is not specified for connection What…
GriMel
  • 1,872
  • 3
  • 19
  • 36
41
votes
3 answers

DBeaver Can't access non-default database

I'm using DBeaver 3.8.0 and trying to setup general connection to my local PostgreSQL database. To view all the databases i have, I check the "Show non-default databases" checkbox. And when I try to access Schemas of one of my databases - I'm…
Jekis
  • 3,640
  • 2
  • 30
  • 38
33
votes
12 answers

dbeaver: how can I export connection configuration?

I recently got a new macbook pro for work and I'm in the process of migrating a lot of my settings from my old machine. I was hoping that there is a way to export the connection configuration/properties from my old machine rather than have to go…
jaydel
  • 12,815
  • 12
  • 57
  • 89
33
votes
3 answers

How to execute a SQL script in DBeaver?

I have a number of .sql files that I wish to execute through DBeaver. Traditional database development programmes allow the user to edit and run SQL scripts (totally or partially) in the same window, but this is not obvious with DBeaver. When I open…
Luís de Sousa
  • 3,801
  • 7
  • 40
  • 71
32
votes
1 answer

How do I run arbitrary SQL on DBeaver?

Ok, so this may seem like a stupid question but I'm fighting DBeaver and so far it's winning and Google is refusing to pick a side. I've worked out how to explore the database, view the structure of tables, I can even view the data of a table and…
Tim B
  • 38,707
  • 15
  • 73
  • 123
28
votes
7 answers

How to change DBeaver timezone / How to stop DBeaver from converting date and time

When I use DBeaver with Cassandra, it shows an offset of +01:00 even though the data is stored in Date or Times formats, that don't have any timezones. This results in some weird queries like this: SELECT "Time" FROM keyspace."Table" ORDER BY…
Edu
  • 1,869
  • 5
  • 27
  • 32
23
votes
3 answers

DBeaver, export from database Postgres, table structure (properties) into file .txt

I have little problem with DBeaver. I want to export my structure from each table from database in file .txt. I found how to export all data but I don't need this data, just table structure. If you have some solutions for export table structure .csv…
Iani M.D.
  • 333
  • 1
  • 2
  • 7
22
votes
1 answer

DBeaver file encoding (cp1250 - Windows-1250) - change default encoding?

I have a problem setting encoding in DBeaver, specifically SQL file encoding (not db encoding!) to cp1250 (Windows-1250) No problem to set such encoding for new files/scripts - right click on Scripts folder (or the whole project folder, from which…
Tom
  • 323
  • 1
  • 2
  • 12
20
votes
4 answers

DBeaver not showing dbms_output

I'm using dbeaver version 5.1.3. When I use the DBMS_OUTPUT.PUT_LINE method for oracle pl/sql it's output not shown anywhere. It has a output tab. It's also blank.
Indika Rajapaksha
  • 707
  • 1
  • 7
  • 24
17
votes
5 answers

The line number on the SQL Editor in DBeaver

How to toggle the line number on the SQL Editor in DBeaver? I can't find this option in Window / Preferences / General / Editors / SQL Editor. Is it possible to do this?
simhumileco
  • 21,911
  • 14
  • 106
  • 90
16
votes
4 answers

how to configure the DBeaver and Cassandra

I am very new to DBeaver. From forum i got to know that driver need to update for cassandra 3+ to work with DBeaver. https://github.com/serge-rider/dbeaver/issues/167 I downloaded this new driver but unable to set the class path. Can anyone help me…
samir
  • 293
  • 2
  • 4
  • 14
14
votes
3 answers

Error while installing dbeaver - Java error code = 13

I am getting the below error when trying to open dbeaver. Java is up to date...any ideas?
The Numbers Man
  • 139
  • 1
  • 2
  • 7
1
2 3
…
35 36