Export MATLAB data to postgesql database

I have a table with data that i created through calculations in Matlab. I want this table to be exported into Posgresql table which has the same columns as the table i created (number of columns and names of columns). But I get this error Error using database.jdbc.connection/datainsert (line 106) Variable fields and insert fields do not match
Do you know how to fix this? The names between the table and the database table look the same

4 Kommentare

the cyclist
the cyclist am 26 Jan. 2017
Please post the code you are using.
Have you done anything successfully, connecting to a postgres database via MATLAB? For example, have you successfully issued a query and gotten results back? Or is this the very first time you have tried to do anything?
Are you using the Database Toolbox?
Fragkiskos Nikolakis
Fragkiskos Nikolakis am 26 Jan. 2017
Bearbeitet: the cyclist am 26 Jan. 2017
Yes I have issued a query from postgres, i got results and now i want to export the results in an another table in posgres.
%Make connection to database. Note that the password has been omitted.
%Using ODBC driver.
conn = database('PostgreSQL30', '', '');
colnames = {'"x_RecordId_"','VESSEL_NAME','x_DGNo_','x_LocalTimeStamp_','RealPowerTotal','PF','Frequency','BALLAST_FLAG','TEL_TYPE','LF','THD_A','THD_B','THD_C','Curr_Unbalance','Volt_Unbalance','SFOC_corrected','consumption',};
data=kwhmeters;
datainsert(conn,'"Kwhmeters5min"',colnames,data)
%Close database connection.
close(conn);
the cyclist
the cyclist am 26 Jan. 2017
Is kwhmeters an object of data type table, or something else? Any chance you can upload a MAT file with an example of the data?
kwhmeters is a table

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by