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
