Matlab connection string to a local Postgres Db

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

0 个投票

I have created a local Postgres Db on my computer, from where I am also running Matlab R2021b.
How can I set up a connection string to connect to my Db?

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

 采纳的回答

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

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

产品

版本

R2021b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by