MATLAB: How to specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database

Database Toolbox

I am trying to connect to POSTGRESQL database. I am not able to find the JDBC Driver and URL string to use them in DATABASE command to connect to my database. I would like some help on this issue.

Best Answer

For a PostGreSQL database the driver and the URL specifications are as follows:

JDBC driver: org.postgresql.DriverDatabase
URL: jdbc:postgresql://masd/DatabaseName

Please note that the Database URL string needs to have the Database name "DatabaseName" appended at the end of it.

Related Solutions

MATLAB: Can I query a PostgreSQL/PostGIS database from MATLAB

It is possible using Database Toolbox as described in this technical note :

How do I specify the Database URL String in the DATABASE function of Database Toolbox 3.4(R2007b) to connect to a POSTGRESQL database?

MATLAB: Do I receive the error “Unable to connect to data source” with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)

This information has been incorporated into the documentation for Database Toolbox 3.0.2 (R14SP2). For previous releases, please read below for any additional information:

When connecting to the new versions of Oracle (10) database via JDBC, the database 'Name' should be the same as the suffix after the port number in the database 'URL'

For the DATABASE function DATABASEURL argument, for example, instead of running

conn = database('oracle','scott','tiger','oracle.jdbc.driver.OracleDriver',...
'jdbc:oracle:thin:@144.212.123.24:1822:')

you should use

conn = database('databasename','username','password','oracle.jdbc.driver.OracleDriver',jdbc:oracle:thin:@IP_ADDRESS_OF_DATABASE_SERVER:1521:databasename');

Best Answer

Related Solutions

MATLAB: Can I query a PostgreSQL/PostGIS database from MATLAB

MATLAB: Do I receive the error “Unable to connect to data source” with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)

Related Question