How to convert PgArray to Matlab array?

Question

Atanu 2022-3-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1670369-how-to-convert-pgarray-to-matlab-array

编辑： Atanu 2022-4-23

I have written a SQL query to import a table into MATLAB. There is 2 two PgArrays ('org.postgresql.jdbc.PgArray') in the workspace. I need to plot those arrays. How do I convert PgArrays to numeric array so that it is in more manageable format?

datasource = 'live_database';
conn = database(datasource,'postgres','1234');
tablename = "live_table";
query = "SELECT date, coordinatetimes," + ...
    " xcoordinates, ycoordinates FROM live_Table WHERE subjectid = 'andrea';";
data = fetch(conn,query);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Atanu 2022-4-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1670369-how-to-convert-pgarray-to-matlab-array#answer_948955

编辑：Atanu 2022-4-23

在 MATLAB Online 中打开

This piece of code will convert PGArray data to double

all_coordinatetimes = cell(length(data_on_date.coordinatetimes),1);
for idx = 1:length(data_on_date.coordinatetimes)
    string_all_coordinatetimes = string(data_on_date.coordinatetimes(idx,1));
    reg_all_coordinatetimes = regexprep(string_all_coordinatetimes,'{|}','');
    split_all_coordinatetimes = split(reg_all_coordinatetimes,',');
    all_coordinatetimes{idx,1} = str2double(split_all_coordinatetimes);
    data_on_date.coordinatetimes{idx,1} = all_coordinatetimes{idx,1};
end