Matlab connection to Postgre DB

2012 7 3
1 个回答
更新时间：2023 5 15
7 次查看（30 天）

0 个投票

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

请先登录，再回答此问题。

回答（1 个）

Paul Efford
Paul Efford 2023-5-15

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Enterprise Deployment with MATLAB Production Server 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by