PostgreSQL is a popular open source database that offers features not found in some other databases. The PostgreSQL JDBC Driver
-
The PostgreSQL JDBC Driver is part of the postgres project and is recommended
-
Quit SQLEditor if it is currently running
-
Download and unpack the driver archive using stuffit or similar
-
Locate the file postgresql.jar.
-
Copy the file postgresql.jar to the directory
/Library/Java/Extensions/ -
You may need to enable TCP/IP connection support in PostgreSQL if this is not already enabled.
-
Start SQLEditor
-
Show the preferences window using → and select the database tab. Then enter the values as follows:
-
Click the add button
-
Choose File→Import From Database
-
Select the PostgreSQL database driver in the popup menu. Then enter the details of the connection into the fields.
In this example picture we are loading the database test using a database server running on the local machine with a username of test and a password of test. All other options should be left empty. The connection string will auto-complete with the suggested database url. Unless it looks wrong you should probably use the suggested database url.
|
Value |
Setting |
|
|---|---|---|
|
Hostname |
localhost |
the name of the machine that the database is running on (Use localhost if the database is on the same machine) |
|
Database |
test |
The name of the database to connect to |
|
Username |
username |
The username that you wish to connect using |
|
Password |
pass |
The password to use (optional) |
-
Click the import button and after a few moments the database structure will appear in new window