Matlab connection string to a local Postgres Db

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?

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