Connecting from DBeaver:
- From the "Database" menu, select "New Database Connection"
- In the wizard that pops up, search for "PostgreSQL." Select it and click "Next >".
- Type in the connection details above for host, port, database, user, and password.
- Click on the SSL tab. Check the box next to "Use SSL." Using the "SSL mode" drop-down menu, select "require."
- Click Finish.
- 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."
- Expand the arrow to see the contents of the database.
- Under "Schemas", select "public"
- Under "public", select "Tables"
- Under "Tables", double click on a table name to see basic information about the table, including a tab that shows the data
- 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:
...
- 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';
