How do you make an entity relation diagram using pgAdmin v4 or DB Visualizer or any other open source tool? PG Admin There are lots of explainers for pgadmin III but they suggest that there should...

How can a SQLite *.db file be imported into DbVisualizer? Since the SQLite database file extension is *.db how can we load this into DbVisualizer to view the tables and generate the ER diagram?

I have created database with my own program and it appeared as mydatabase.mv.db file. But when I tried to access the same database with DbVisualizer, with apparently same parameters, it created t...

Ok so, I've been ripping my hairs ou on this one, why doesn't this work? DELIMITER | CREATE PROCEDURE Decrypt_pw() READS SQL DATA BEGIN SELECT 'Hey Select'; END| It's so basic and I'm pretty ...

Is there a setting in DbVisualizer to display all tables in the "References" tab? I am using the free version (10.0) and when I click on a table with the References tab open I only see the direct r...

I have configured my H2 database as follows: @Configuration @Profile({ Profiles.DEV }) public class DevDataSourceConfiguration { @Bean(initMethod = "start", destroyMethod = "stop") public Serve...

I observe there are two ways to achieve an objective on multiple tables. A column in the resultset will be updated and speed may be a requirement. The resultset is obtained either by: Case 1: sel...

I am using DBVisualizer 8.0.6 and when I run a simply query like SELECT * FROM table; It only shows the first 1000 rows and then stops the query and displays in the bottom left corner. Number of ...

I have a H2 database on which some queries work, while others are throwing an ArrayIndexOutOfBoundsException. For example: SELECT COLUMN_1 FROM MY_TABLE; // works fine SELECT COUNT(COLUMN_1) FR...