DBeaver

Please see the LDP wiki for the latest version of this page.

Connecting from DBeaver:

1. From the "Database" menu, select "New Database Connection"
2. In the wizard that pops up, search for "PostgreSQL." Select it and click "Next >".
3. Type in the connection details above for host, port, database, user, and password.
4. Click on the SSL tab. Check the box next to "Use SSL." Using the "SSL mode" drop-down menu, select "require."
5. Click Finish.
6. The database connection should now appear in the left panel under the Database Navigator. Unless you changed the name, the connection will likely be named "PostgreSQL - ldp_snapshot."
7. Expand the arrow to see the contents of the database.
   1. Under "Schemas", select "public"
   2. Under "public", select "Tables"
   3. Under "Tables", double click on a table name to see basic information about the table, including a tab that shows the data
8. From the "SQL Editor" menu, select "New SQL Editor" to paste in and run an SQL query

Note about using DBeaver to connect to Amazon Redshift:

When DBeaver connects to Amazon Redshift, the default settings may result in reports that use the UTC timezone for any timestamp and date fields. If you want to force the reports to display times in your local timezone, you can follow these steps to adda "SET timezone" command to your connection:

• Open a new SQL editor window
• Submit the following query to confirm that the current timezone is UTC:
  SHOW timezone;
• Submit the following query to identify the correct name for your current timezone:
  SELECT pg_timezone_names();
• To set the timezone every time you connect to Redshift:
  • Right-click on the Redshift connection and select "Edit Connection"
  • Under "Connection settings > Initialization > Connection > Bootstrap queries", select "Configure".
  • Select "Add" and enter the "SET timezone = . . . ;" command with your timezone. For example, if you are in the Eastern timezone, your command would be: SET timezone='US/Eastern';