Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) 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 an open-source framework and allows the 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 and different database management utilities (e.g. ERD).
1047 questions
-1
votes
0 answers

How can I filter for unique identities based on timestamp with a list of duplicated ids?

I have the following SQL table: id fid ts val 1 4004 2019-01-22 True 2 4004 2018-12-03 True 3 4004 2020-07-08 True 2 4004 2020-07-09 True 3 4004 2020-07-21 …
ifrj
  • 91
  • 7
-1
votes
0 answers

Why is the record count different for a Select Statement vs. a Delete Statement which are identical in DBeaver?

Using Dbeaver 23.1.0 connected to a Sybase Adaptive Server Database I run 2 simple select queries which both return a record count of 5333 which is expected. Select * from Availability Where ProductId in (select ProductId from Products where…
user200709
  • 31
  • 4
-1
votes
0 answers

How can I view prisma relation data in dbeaver?

I would like to view the rich relation data which is available in prisma studio in dbeaver. For example, in prisma studio if a Post entity has a userId field and user relation defined: model Post { id String …
Christopher Geiger
  • 179
  • 1
  • 10
-1
votes
2 answers

Automatically update a MySQL table with the last 24 months

I have the following already created table in DBeaver: Let's say that from this dataset in the ss On the 1st of August i want to add 2023-08-01 and delete 2021-07-01 from the 1st row. I am using this to update a dashboard timeline with the last 24…
KazimiR
  • 1
  • 2
-1
votes
1 answer

Unable to connect to Postgres Docker container with DBeaver

I am new to Docker, it is something the team I am on is looking into as we also move to Azure. One of the things I have been trying to do is replicate an existing Postgres database used for local development in a Docker container. I have been…
Ray Koziel
  • 11
  • 2
-1
votes
1 answer

DBeaver run AS400 CL commands

I connect to an AS400 database using DBeaver and ODBC, it lets me run CRUD operations better than the 5250 Emulator. Is there a way to run from DBeaver command lines like WRKUSRPRF or CHGUSRPRF?
user10191234
  • 531
  • 1
  • 4
  • 24
-1
votes
1 answer

PostgreSQL - I get SQL Error [42P01] or [42703] if I don't add double quotes around table names or Fields

I'm using DBeaver to write script for my PostgreSQL database. I have a PostgreSQL DB with Tables autogenerated by C#/EFCore (Microsoft ORM) - I receive SQL Error [42P01] if I don't add double quotes around table names when I cut and paste my ORM…
Eric Ouellet
  • 10,996
  • 11
  • 84
  • 119
-1
votes
1 answer

SQL Error [1452] [23000]: Cannot add or update a child row: a foreign key constraint fails

I have created tables in SQL as shown below, but when I try to insert values, I get the following error and I'm not sure why: SQL Error [1452] [23000]: Cannot add or update a child row: a foreign key constraint fails (N01581969.Attending,…
Tara
  • 15
  • 3
-1
votes
2 answers

Query SQL Select Column Matching From Another Table

edit : Sorry gurus, I have to rephrase my question since I forgot there are 3 tables in one query. I have three tables with tbl_goods ,tbl_units and tbl_sat which looks like this : tbl_goods, consists of sold goods …
Imam
  • 37
  • 6
-1
votes
1 answer

Duplicates - Deletion under PostgreSQL

I am working on tables where primary keys are sometimes not defined. I have observed the following behavior while trying to delete duplicates using the row deletion button of the interface: Deletion of one row (1 of the duplicate) leads to deletion…
Sylvainjoon
  • 3
  • 2
-1
votes
1 answer

DB2 Connection is not working in DBeaver when i'm trying to connect

i'm trying to connect DB2 Database in DBeaver client, i tried with some of DB2 Drivers, but always it's showing the same error: Error My drivers: Drivers What could be the problem?
papafrita9999
  • 3
  • 2
-1
votes
3 answers

How can I build a CASE statement in SQL that tells when there are multiple/different values in another column for a specific item?

Here is a simple example of what I'm trying to achieve: Essentially I want to change this: Into this: I'm thinking some sort of CASE statement for when there are multiple colors for any single fruit, THEN 'Multiple' ELSE "Color", but not sure how…
Keena
  • 9
  • 4
-1
votes
2 answers

Why does LEFT OUTER JOIN produce the same results as INNER JOIN in DBEAVER when querying from Redshift?

I have 2 tables. t1.uuid has 630,000 distinct values. t2.uuid has 300,000 distinct values. When I run SELECT t1.uuid , t2.uuid FROM t1 --630,000 uuids LEFT OUTER JOIN t2 -- 300,000 uuids ON t1.uuid = t2.uuid WHERE …
Syd
  • 65
  • 8
-1
votes
1 answer

Use lag function to add column in mysql

I need a column that gives me the difference of a column of a previous row and current row. I am able to achieve this using a select statement. Using SELECT *,`open` - LAG(`close`,1,`open`) over (order by `open`) as `previous_day_close` FROM…
Ramesh2209
  • 17
  • 4
-1
votes
1 answer

SQL data, selecting and searching in the same table

id1 id2 v1 v2 v3 P1 I1 A B C P1 I2 D E F P2 I1 A B D P3 I1 A D E P2 I2 B D E How can I get from the table above to following: First, I need all entries with an A, we call this table X (I think I can do this with: SELECT * FROM…
TRK
  • 85
  • 6
1 2 3
…
69 70