Skip to main content

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.

Jump to: navigation, search

Connecting to PostgreSQL 8.x

Revision as of 16:29, 13 August 2006 by Unnamed Poltroon (Talk) (PostgreSQL 8.x)

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.

Back to the top