如何在没有matlabs数据库工具箱的情况下从matlab访问postgresql数据库？ [英] How can I access a postgresql database from matlab with without matlabs database toolbox?

问题描述

我已尝试使用 pgmex 。不幸的是它不适用于libpq5（matlab立即崩溃）。

I tried already to use pgmex. Unfortunately it doesn't work with libpq5 (matlab immediately crashes).

推荐答案

从matlab连接到postgres而不使用数据库工具箱类似于：

To connect to postgres from matlab without the database toolbox do something similar to:

% Add jar file to classpath (ensure it is present in your current dir)
javaclasspath('postgresql-9.0-801.jdbc4.jar');

% Username and password you chose when installing postgres
props=java.util.Properties;
props.setProperty('user', '<your_postgres_username>');
props.setProperty('password', '<your_postgres_password>');

% Create the database connection (port 5432 is the default postgres chooses
% on installation)
driver=org.postgresql.Driver;
url = 'jdbc:postgresql://<yourhost>:<yourport>\<yourdb>';
conn=driver.connect(url, props);

% A test query
sql='select * from <table>'; % Gets all records
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();

% Read the results into an array of result structs
count=0;
result=struct;
while rs.next()
    count=count+1;
    result(count).var1=char(rs.getString(2));
    result(count).var2=char(rs.getString(3));
    ...
end

这篇关于如何在没有matlabs数据库工具箱的情况下从matlab访问postgresql数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！