To download the current version, see the PostgreSQL JDBC Driver page. The first thing you should see is the “Select Connection Profile” window pop-up when you launch the app.Ī JDBC driver is required to connect SQL Workbench/J to PostgreSQL. To get started unzip the archive, and execute the sqlworkbench.jar file. For the purposes of this blog we downloaded the file labeled “Generic package for all systems without support for importing or exporting Excel or OpenOffice spreadsheets.” Go to the SQL Workbench/J site and download the latest stable version for your operating system. Installing SQL Workbench/J Download and Install SQL Workbench/J In this how-to we’ll be focused on getting up and running on a Mac, although SQL Workbench/J supports all the popular operating environments. The instructions for how to get up and running in just a few minutes can be found in our previous blog post, “The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database.” For the purposes of this blog post we’ll be using the Northwind sample database. Editing, inserting and deleting data directly in the query result viewīefore we get into SQL Workbench/J, you’ll need to set up YugaByte DB and install a sample database.Rich support for importing/exporting datasets.SQL Workbench/J has several key features worth highlighting: It is Java based and supports several databases over JDBC, so it is obviously a popular tool among Java developers. SQL Workbench/J is a free cross-platform SQL query and admin tool that can help developers run SQL queries either interactively or as a batch job. In a previous blog we explored the DBeaver database management tool, and in this post we’ll show you how to get up and running with SQL Workbench/J and the popular PostgreSQL Northwind dataset. In fact, you can find a comprehensive list of tools on the PostgreSQL wiki here. If using the command line and learning sometimes arcane syntax makes you uncomfortable, there are graphical tools that can help you speed up many daily DBA tasks. Although most databases ship with a command line utility to administer the instance, these utilities often come with a steep learning curve.

Sql workbench mac log file location