Matlab connection to Postgre DB

Hi all,

Please, can you suggest me how to connect Matlab to a DB? I have a PostgreSQL DB and I need to import data quite often. Is there any toolbox that I'm missing? I have Matlab 2008

Many thanks

Davide

Answer 1

[Paul Efford]

dbname = 'myDbName'; % = datasource

username = "postgres";

password = 'admin';

server = 'localhost'; % 127.0.0.1'; % 'server' = 'hostname'

port = '5432';

driver = 'org.postgresql.Driver';

url = ['jdbc:postgresql://' server ':' port '/' dbname];

try

conn = database(dbname, username, password, driver, url);

conn.AutoCommit = "off";

%conn.LoginTimeout = 0;

%conn.MaxDatabaseConnections = 100;

if isopen(conn)

disp('Database connection successful');

%... put your queries here

close(conn); % close the database connection

else

disp('Database connection failed');

end

catch ME

disp(['Error while processing data from file ' ': ' ME.message]);

end