How to upload cell data to PostgreSQL database table?

I am trying to upload a MATLAB table to PostgreSQL database. But the columns which contain cell datatypes are not showing up in PostgreSQL table. I have tried to convert the cell data into various other datatypes, none of them worked so far. Do you have any suggestions on how to handle cell data which contain double array? I have attached the MATLAB table for reference. I also have attached my .m file if you want to check.

[Siddharth Bhutiya]

I am not well versed in databased but I think the problem is you dont have a predefined data type for the cell array of doubles in PostgreSQL. So you might need to get rid of the cell array and only have numeric data. Here's something you can use as a strating point.

>> data

data =

  10×3 table

    id     run_time        average_position  
    __    ___________    ____________________

     1    {[ 3.1000]}    {[22.8000 -25.5000]}
     2    {[ 0.3000]}    {[      -67 4.3900]}
     3    {[ 8.5000]}    {[      70.6000 28]}
     4    {[10.1000]}    {[-47.6000 -8.2000]}
     5    {[ 7.9000]}    {[22.8000 -25.5000]}
     6    {[    NaN]}    {[      -67 4.3900]}
     7    {[    NaN]}    {[      70.6000 28]}
     8    {[    NaN]}    {[-47.6000 -8.2000]}
     9    {[    NaN]}    {[22.8000 -25.5000]}
    10    {[ 5.3000]}    {[      -67 4.3900]}

>> data.(2) = cell2mat(data.(2));
>> data.(3) = cell2mat(data.(3))

data =

  10×3 table

    id    run_time    average_position
    __    ________    ________________

     1       3.1        22.8    -25.5 
     2       0.3         -67     4.39 
     3       8.5        70.6       28 
     4      10.1       -47.6     -8.2 
     5       7.9        22.8    -25.5 
     6       NaN         -67     4.39 
     7       NaN        70.6       28 
     8       NaN       -47.6     -8.2 
     9       NaN        22.8    -25.5 
    10       5.3         -67     4.39 

I dont know if multi-column doubles would work but you can try to see if that is supported in PostgreSQL, if that does not work then you can split that into two double columns using splitvars.

    >> data = splitvars(data)

data =

  10×4 table

    id    run_time    average_position_1    average_position_2
    __    ________    __________________    __________________

     1       3.1             22.8                 -25.5       
     2       0.3              -67                  4.39       
     3       8.5             70.6                    28       
     4      10.1            -47.6                  -8.2       
     5       7.9             22.8                 -25.5       
     6       NaN              -67                  4.39       
     7       NaN             70.6                    28       
     8       NaN            -47.6                  -8.2       
     9       NaN             22.8                 -25.5       
    10       5.3              -67                  4.39