{"id":1050,"date":"2017-05-15T12:18:35","date_gmt":"2017-05-15T12:18:35","guid":{"rendered":"https:\/\/data36.com\/?p=1050"},"modified":"2024-02-06T22:35:26","modified_gmt":"2024-02-06T22:35:26","slug":"install-sql-workbench-postgresql","status":"publish","type":"post","link":"https:\/\/data36.com\/install-sql-workbench-postgresql\/","title":{"rendered":"How to install SQL Workbench for postgreSQL"},"content":{"rendered":"\n<p>In my previous <a href=\"https:\/\/data36.com\/sql-for-data-analysis-tutorial-beginners\/\">SQL for data analysis tutorial<\/a>,&nbsp;I briefly mentioned that I prefer SQL Workbench&nbsp;over pgadmin4&nbsp;for SQL querying. Today I will show you how you can install it too! The setup process is more or less the same on Mac, Windows and Linux, but I\u2019ll highlight the slight differences in my article &#8211; and you can always select the appropriate solutions for yourself.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">STEP 1: Download and install Java 8+ on your computer!<\/h2>\n\n\n\n<p>SQL Workbench works with Java8+, so until you have this package, you won\u2019t be able to run it! Java will be useful anyway, so simply download and install it from here:<br><a href=\"https:\/\/java.com\/en\/download\">https:\/\/java.com\/en\/download<\/a><\/p>\n\n\n\n<p>It is fully free &#8211; provided by Oracle.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">STEP 2: Download SQL Workbench!<\/h2>\n\n\n\n<p>It\u2019s free too and you can get it here:<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/www.sql-workbench.eu\/download-archive.html\n<\/div><\/figure>\n\n\n\n<p><span style=\"font-weight: 400;\">Here, you&#8217;ll see all the previously released SQL Workbench versions.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">When I write this article, <strong>Build 124<\/strong> is on the top. Whether it&#8217;s on the top for you as well or not, <strong>please go and find this exact version:<\/strong> <strong>Build 124<\/strong>.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">And make sure you are downloading the right version for your operating system:<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"691\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-1024x691.png\" alt=\"sql workbench install\" class=\"wp-image-4958\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-1024x691.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-300x202.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-768x518.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-973x656.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install-508x343.png 508w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-install.png 1518w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><em>UPDATE! As of 2023-02-06, in some countries the above linked website doesn&#8217;t work. I don&#8217;t know why but just in case, as a temporary solution, I&#8217;ve uploaded the installation files to a Google Drive folder, too. You can find them here:&nbsp;<\/em><a href=\"https:\/\/drive.google.com\/drive\/folders\/1MEwZ2sYLZmQRFbIw87fOF7XBidN_ETZQ?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\"><em>SQL Workbench backup files<\/em><\/a><em>.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">STEP 3: Open SQL Workbench!<\/h2>\n\n\n\n<p>Once you have downloaded your file, unzip it! You don\u2019t have to install anything, just run the SQL Workbench application. If you have trouble opening it:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>On Windows:<\/strong> right click on SQLWorkbench.exe &#8211;\u00bb Run as administrator<\/li>\n\n\n\n<li><strong>On Mac:<\/strong> right click on SQLWorkbenchJ &#8211;\u00bb Open<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">STEP 4: Download the postgreSQL plugin!<\/h2>\n\n\n\n<p>Unfortunately you have to download a postgreSQL plugin too!<br>Link: <a href=\"https:\/\/jdbc.postgresql.org\/download\/#latest-versions\">https:\/\/jdbc.postgresql.org\/download\/#latest-versions<\/a><\/p>\n\n\n\n<p>Read the instructions and download the appropriate version (in our case, this is going to be the one that is compatible with Java8+). Don&#8217;t worry about too much about the exact version number &#8212; but just in case when I\u2019m updating this article (January, 2024), the right file is: <em>PostgreSQL JDBC 4.2 Driver, <code>Java 8, 42.7.1<\/code><\/em> &#8212;<em> if a new one comes out in the mean time you can always go with the latest version.<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42.png\"><img decoding=\"async\" width=\"2014\" height=\"712\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42.png\" alt=\"SQL Workbench postgresql driver jdbc 42\" class=\"wp-image-8051\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42.png 2014w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42-300x106.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42-1024x362.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42-768x272.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench-postgresql-driver-jdbc-42-1536x543.png 1536w\" sizes=\"(max-width: 2014px) 100vw, 2014px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Important! Put this file in a folder where it is safe and where you won\u2019t accidentally move or remove it.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">STEP 5: Connect to your server!<\/h2>\n\n\n\n<p><em>Note: if you don\u2019t have your own data server to practice yet, set one up here: <a href=\"https:\/\/data36.com\/data-coding-101-install-python-sql-r-bash\/\">Install Python, R, SQL and bash!<\/a><\/em><\/p>\n\n\n\n<p>When you run your SQL Workbench application, the first window will be the \u201cConnect window.\u201d If not, you can still access it from File &#8211;\u00bb Connect Window.<\/p>\n\n\n\n<p>It requires a few pieces of information to make the connection:<\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>Name:<\/strong><\/span> You have to name your connection, which can be anything. (I\u2019ve typed in: <em>\u201cMy first postgreSQL connection\u201d<\/em>)<\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>Driver:<\/strong><\/span> Select <strong>PostgreSQL<\/strong>! You will get an error message. Something like this:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full wp-image-1053\"><img decoding=\"async\" width=\"834\" height=\"326\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench_error.png\" alt=\"SQL Workbench error: &quot;The library for the driver is not accessible!&quot;\" class=\"wp-image-1053\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench_error.png 834w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench_error-300x117.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench_error-768x300.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-Workbench_error-508x199.png 508w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><figcaption class=\"wp-element-caption\">SQL Workbench error: &#8220;The library for the driver is not accessible!&#8221;<\/figcaption><\/figure>\n\n\n\n<p>Click YES!<br>As you can see, SQL Workbench can\u2019t find the postgreSQL driver by itself\u2026 Let\u2019s help it out and click the little Folder icon.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-1024x598.png\" alt=\"SQL_Workbench_select_driver\" class=\"wp-image-1054\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-1024x598.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-300x175.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-768x449.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-973x569.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver-508x297.png 508w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL_Workbench_select_driver.png 1578w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Go and find the driver that you just downloaded&nbsp;during STEP 4. Open it!<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large wp-image-1055\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-1024x602.png\" alt=\"SQL workbench postgresql-42.1.1.jar driver defined\" class=\"wp-image-1055\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-1024x602.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-300x176.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-768x451.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-973x572.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined-508x299.png 508w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-postgresql-driver-defined.png 1572w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">the .jar file is imported&#8230;<\/figcaption><\/figure>\n\n\n\n<p>If you can see it on the \u201cLibrary list\u201d (shown in the above picture), click OK and your driver will be set!<\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>URL:<\/strong><\/span> The URL has 4 parts.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"109\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-1024x109.png\" alt=\"sql workbench url\" class=\"wp-image-1056\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-1024x109.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-300x32.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-768x81.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-973x103.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql-workbench-url-508x54.png 508w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The <code>jdbc:postgresql:\/\/<\/code> is a constant in our case. You don\u2019t have to change it.<\/li>\n\n\n\n<li>The next part (red) will be the IP address of your server. Type&nbsp;<em><strong>your<\/strong><\/em> server\u2019s IP address (the format should be something like: <code>46.101.100.000<\/code>)<\/li>\n\n\n\n<li>The next step (green) is the port number. If you followed <a href=\"https:\/\/data36.com\/category\/coding-data-science-analytics\/\">my tutorials<\/a> so far, this is going to be <code>5432<\/code> for you as well!<\/li>\n\n\n\n<li>Finally provide the name of the database that you want to access (it can be anything that has been created before\u2026 If you followed <a href=\"https:\/\/data36.com\/category\/coding-data-science-analytics\/\">my tutorials<\/a>&nbsp;so far, it will be <code>postgres<\/code>!)<\/li>\n<\/ol>\n\n\n\n<p><em>Note: usually when you get access to a database, you get this information (IP address, port, database name) from the admin of the database.<\/em><\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>Username:<\/strong><\/span> This should be the username that you set up when you&nbsp;<a href=\"https:\/\/data36.com\/data-coding-101-install-python-sql-r-bash\/\">installed your data server<\/a>. (e.g. for me it\u2019s \u201cdataguy\u201d or \u201ctomi\u201d)<\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>Password:<\/strong><\/span> Your previously set password.<\/p>\n\n\n\n<p>If you did everything properly, you should have something like this on your screen:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"646\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-1024x646.png\" alt=\"SQL workbench ready to login\" class=\"wp-image-1057\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-1024x646.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-300x189.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-768x484.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-973x614.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-workbench-ready-to-login-508x320.png 508w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Click OK and the connection will be established!<\/strong><br><strong> Congrats! You are in!<\/strong><\/p>\n\n\n\n<p><em>Note: It\u2019s worth saving your connection details so you don\u2019t have to type&nbsp;them again!<\/em><\/p>\n\n\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7012\" class=\"elementor elementor-7012\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-259c3993 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"259c3993\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-679a79f1\" data-id=\"679a79f1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e5ca0c1 elementor-widget elementor-widget-heading\" data-id=\"e5ca0c1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">The Junior Data Scientist's First Month<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5bc28c elementor-widget elementor-widget-text-editor\" data-id=\"f5bc28c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: var( --e-global-color-text ); font-family: 'PT Serif'; font-size: 1em; word-spacing: var( --e-global-typography-text-word-spacing );\">A 100% practical online course. A 6-week simulation of being a junior data scientist at a true-to-life startup.<\/span><\/p><p><i>&#8220;Solving real problems, getting real experience &#8211; just like in a real data science job.&#8221;<\/i><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6da23e4 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"6da23e4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/data36.com\/the-junior-data-scientists-first-month-online-course\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn more...<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n\n\n\n<h2 class=\"wp-block-heading\">STEP 6: Run a test query!<\/h2>\n\n\n\n<p>As a last step, just run some sample queries to test out your new SQL query tool!<br>You can try the classy <code>SELECT * FROM zoo;<\/code> or you can go ahead and explore your data tables via the Database Explorer feature:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"766\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-1024x766.png\" alt=\"SQL explore\" class=\"wp-image-1058\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-1024x766.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-300x224.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-768x574.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-973x728.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-explore-508x380.png 508w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"767\" src=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-1024x767.png\" alt=\"SQL database explorer\" class=\"wp-image-1059\" srcset=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-1024x767.png 1024w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-300x225.png 300w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-768x575.png 768w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-973x729.png 973w, https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/SQL-database-explorer-508x381.png 508w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Aaand&#8230; That\u2019s it for today! You have a cool free SQL query tool, SQL Workbench. From now on you can use either this or pgadmin4 to complete my <a href=\"https:\/\/data36.com\/learn-sql-for-data-analysis-from-scratch\/\">SQL for data analysis tutorials<\/a>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If you want to learn more about how to become a data scientist, take my 50-minute video course: <a href=\"https:\/\/data36.com\/how-to-become-a-data-scientist\/\">How to Become a Data Scientist.<\/a>&nbsp;(It&#8217;s&nbsp;free!)<\/li>\n\n\n\n<li>Also check out my 6-week online course: <a href=\"https:\/\/data36.com\/jds\/\">The Junior Data Scientist\u2019s First Month video course.<\/a><\/li>\n<\/ul>\n\n\n\n<p><em>Cheers,<\/em><br><strong><em>Tomi Mester<\/em><\/strong><\/p>\n\n\n\n<p><em>Cheers,<\/em><br><strong><em>Tomi Mester<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my previous SQL for data analysis tutorial,&nbsp;I briefly mentioned that I prefer SQL Workbench&nbsp;over pgadmin4&nbsp;for SQL querying. Today I will show you how you can install it too! The setup process is more or less the same on Mac, Windows and Linux, but I\u2019ll highlight the slight differences in my article &#8211; and you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[139],"tags":[66,13,90,85,92,87,65,111,110,30,60],"class_list":["post-1050","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-coding-data-science-analytics","tag-command-line","tag-data","tag-data-coding","tag-learn-data-science","tag-learn-to-code","tag-pgadmin","tag-sql","tag-sql-query-tool","tag-sql-workbench","tag-tomi-mester","tag-tool"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to install SQL Workbench for postgreSQL? (6 steps)<\/title>\n<meta name=\"description\" content=\"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data36.com\/install-sql-workbench-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install SQL Workbench for postgreSQL? (6 steps)\" \/>\n<meta property=\"og:description\" content=\"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data36.com\/install-sql-workbench-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Data36\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/data36\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/data36\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-15T12:18:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-06T22:35:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql_workbench.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Tomi Mester\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to install SQL Workbench for postgreSQL? (6 steps)\" \/>\n<meta name=\"twitter:description\" content=\"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql_workbench.png\" \/>\n<meta name=\"twitter:creator\" content=\"@data36_com\" \/>\n<meta name=\"twitter:site\" content=\"@data36_com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomi Mester\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/data36.com\/install-sql-workbench-postgresql\/\",\"url\":\"https:\/\/data36.com\/install-sql-workbench-postgresql\/\",\"name\":\"How to install SQL Workbench for postgreSQL? (6 steps)\",\"isPartOf\":{\"@id\":\"https:\/\/data36.com\/#website\"},\"datePublished\":\"2017-05-15T12:18:35+00:00\",\"dateModified\":\"2024-02-06T22:35:26+00:00\",\"author\":{\"@id\":\"https:\/\/data36.com\/#\/schema\/person\/cbc505eee4cecd9d74a2c0f0d00d356e\"},\"description\":\"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)\",\"breadcrumb\":{\"@id\":\"https:\/\/data36.com\/install-sql-workbench-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/data36.com\/install-sql-workbench-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/data36.com\/install-sql-workbench-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/data36.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install SQL Workbench for postgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/data36.com\/#website\",\"url\":\"https:\/\/data36.com\/\",\"name\":\"Data36\",\"description\":\"Learn Data Science the Hard Way!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/data36.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/data36.com\/#\/schema\/person\/cbc505eee4cecd9d74a2c0f0d00d356e\",\"name\":\"Tomi Mester\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/data36.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b782b29236065ff5e1c0e47a8bdb6ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b782b29236065ff5e1c0e47a8bdb6ba?s=96&d=mm&r=g\",\"caption\":\"Tomi Mester\"},\"description\":\"Tomi Mester is a data analyst and researcher. He\u2019s the author of the Data36 blog where he gives a sneak peek into online data analysts\u2019 best practices. He writes posts and tutorials on a weekly basis about data science, AB-testing, online research and data coding. Tomi is a guest blogger on Crazyegg, Hackernoon and Tech-In-Asia. You can meet him as a presenter on conferences like: Global E-commerce Summit, TEDx, Business Intelligence Forum, etc...\",\"sameAs\":[\"https:\/\/data36.com\",\"https:\/\/www.facebook.com\/data36\"],\"url\":\"https:\/\/data36.com\/author\/mestitomi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install SQL Workbench for postgreSQL? (6 steps)","description":"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data36.com\/install-sql-workbench-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How to install SQL Workbench for postgreSQL? (6 steps)","og_description":"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)","og_url":"https:\/\/data36.com\/install-sql-workbench-postgresql\/","og_site_name":"Data36","article_publisher":"https:\/\/www.facebook.com\/data36\/","article_author":"https:\/\/www.facebook.com\/data36","article_published_time":"2017-05-15T12:18:35+00:00","article_modified_time":"2024-02-06T22:35:26+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql_workbench.png","type":"image\/png"}],"author":"Tomi Mester","twitter_card":"summary_large_image","twitter_title":"How to install SQL Workbench for postgreSQL? (6 steps)","twitter_description":"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)","twitter_image":"https:\/\/data36.com\/wp-content\/uploads\/2017\/05\/sql_workbench.png","twitter_creator":"@data36_com","twitter_site":"@data36_com","twitter_misc":{"Written by":"Tomi Mester","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/data36.com\/install-sql-workbench-postgresql\/","url":"https:\/\/data36.com\/install-sql-workbench-postgresql\/","name":"How to install SQL Workbench for postgreSQL? (6 steps)","isPartOf":{"@id":"https:\/\/data36.com\/#website"},"datePublished":"2017-05-15T12:18:35+00:00","dateModified":"2024-02-06T22:35:26+00:00","author":{"@id":"https:\/\/data36.com\/#\/schema\/person\/cbc505eee4cecd9d74a2c0f0d00d356e"},"description":"I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you, how you can install it too! (Mac, Linux and Windows too!)","breadcrumb":{"@id":"https:\/\/data36.com\/install-sql-workbench-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data36.com\/install-sql-workbench-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/data36.com\/install-sql-workbench-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/data36.com\/"},{"@type":"ListItem","position":2,"name":"How to install SQL Workbench for postgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/data36.com\/#website","url":"https:\/\/data36.com\/","name":"Data36","description":"Learn Data Science the Hard Way!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data36.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/data36.com\/#\/schema\/person\/cbc505eee4cecd9d74a2c0f0d00d356e","name":"Tomi Mester","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data36.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b782b29236065ff5e1c0e47a8bdb6ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b782b29236065ff5e1c0e47a8bdb6ba?s=96&d=mm&r=g","caption":"Tomi Mester"},"description":"Tomi Mester is a data analyst and researcher. He\u2019s the author of the Data36 blog where he gives a sneak peek into online data analysts\u2019 best practices. He writes posts and tutorials on a weekly basis about data science, AB-testing, online research and data coding. Tomi is a guest blogger on Crazyegg, Hackernoon and Tech-In-Asia. You can meet him as a presenter on conferences like: Global E-commerce Summit, TEDx, Business Intelligence Forum, etc...","sameAs":["https:\/\/data36.com","https:\/\/www.facebook.com\/data36"],"url":"https:\/\/data36.com\/author\/mestitomi\/"}]}},"_links":{"self":[{"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/posts\/1050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/comments?post=1050"}],"version-history":[{"count":5,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/posts\/1050\/revisions"}],"predecessor-version":[{"id":8867,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/posts\/1050\/revisions\/8867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/media\/1418"}],"wp:attachment":[{"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/media?parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/categories?post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data36.com\/wp-json\/wp\/v2\/tags?post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}