Page Comparison

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:

...