It works with PostgreSQL. At least I tried some simple queries in the FreeQueryBuilder, and they all worked.
Here is how connect to PostgreSQL:
1) download postgresql-8.0-315.jdbc.jar from jdbc.postgresql.org/download.html (it depends on the Java SDK and Postgresql server version installed on the machine.)
2) follow the instructions to add a new server
3) The jdbc driver is org.postgresql.Driver
4) the url is "jdbc:postgresql://host:port/database"
I will let you know what I get from SQLeonardo+PostgreSQL.
Hao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Nicky,
Can you give me some help about how to connect SQLeonardo to a PostgreSQL server?
thanks,
Hao
Never mind, I have figured out how to do it.
Thanks,
Hao
Hello,
I have never tried it with SQLeonardo.
It would be interesting to know if it works...
Thanks
Yes, Nicky,
It works with PostgreSQL. At least I tried some simple queries in the FreeQueryBuilder, and they all worked.
Here is how connect to PostgreSQL:
1) download postgresql-8.0-315.jdbc.jar from jdbc.postgresql.org/download.html (it depends on the Java SDK and Postgresql server version installed on the machine.)
2) follow the instructions to add a new server
3) The jdbc driver is org.postgresql.Driver
4) the url is "jdbc:postgresql://host:port/database"
I will let you know what I get from SQLeonardo+PostgreSQL.
Hao