Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Connecting to PostgreSQL 8.x"
m (→PostgreSQL 8.x) |
|||
Line 10: | Line 10: | ||
* Driver: org.postgresql.Driver | * Driver: org.postgresql.Driver | ||
* Database name: postgres | * Database name: postgres | ||
− | * URL: jdbc:postgresql:postgres | + | * URL: jdbc:postgresql:postgres |
+ | (edit: URL: jdbc:postgresql:\\servername\databasename) | ||
Next, create the connection profile: | Next, create the connection profile: |
Revision as of 16:29, 13 August 2006
← Back to How Do I Connect to...
PostgreSQL 8.x
DTP 0.9 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.