Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Connecting to PostgreSQL 8.x
Revision as of 17:59, 3 November 2006 by John.graham.sybase.com (Talk | contribs)
← Back to How Do I Connect to...
PostgreSQL 8.x
DTP 1.0
DTP 1.0 has driver definitions and a sample connection profile for PostgreSQL. While the catalog loader is not complete, this should give enough content in the Data Source Explorer to be useful.
DTP 0.9.x
DTP 0.9.x does not have a separate PostgreSQL driver template. You can, however, override the values in another driver template to get what is needed here.
- Choose any driver template from the list and override all values
- Name the driver template "PostgreSQL 8.x"
- Jar: postgresql-8.1-404.jdbc2.jar
- Driver: org.postgresql.Driver
- Database name: postgres
- URL: jdbc:postgresql:postgres
(edit: URL: jdbc:postgresql:\\servername\databasename)
Next, create the connection profile:
- Choose "SQL Model-JDBC Connection"
- Give the profile an appropriate name, such as "PostgreSQL"
- Choose the driver template you just created from the combo box
- "Finish" to save the connection profile
Note that you might have to tweak these values for your case. Results in a partial tree in Data Source Explorer, and can be used with the SQL Editor.