How to store 2D array in postgresql using C#?

Question

I want save 2-dim array in postgresql some like this: int[,] arr = {{1, 2}, {3, 4}};

I am using the following sql statement which is working fine to 1-dim array, but it is not work for 2-dim array.

try
{
    string sql1 = "INSERT INTO tbtest(col) VALUES (ARRAY[" + string.Join(", ", arr) + "])";

    dbcmd.CommandText = sql1;
    dbcmd.ExecuteNonQuery();
}
catch (NpgsqlException ex)
{
    if (ex.Data == null)
    {
        throw;
    }
    else
    {

    }
}

How can I do this?

See stackoverflow.com/questions/9159440/… for multidimensional arrays. The ARRAY[] should have adjusted for multidimensional format. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Jul 15, 2016 at 6:39
How can you retrieve the value back? please answer in this question: stackoverflow.com/questions/49489372/… — Umes Bastola
– Umes Bastola, Commented Mar 26, 2018 at 11:10

Justin CI · Accepted Answer · 2016-07-15 06:44:43Z

0

Try this method

 int[,] arr = { { 1, 2 }, { 3, 4 } };   
 var arrayOutput = JsonConvert.SerializeObject(arr);
 string query = "INSERT INTO tbtest(col) VALUES (ARRAY" + arrayOutput + ")";

Output

INSERT INTO tbtest(col) VALUES (ARRAY[[1,2],[3,4]])

edited Jul 15, 2016 at 6:44

answered Jul 15, 2016 at 6:38

Justin CI

2,7411 gold badge18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Justin CI Over a year ago

what was the error in JsonConvert? You need to add NewtonSoft.Json from Nuget package .

Kurd Over a year ago

error: the name JsonConver does not exit in the current context

Justin CI Over a year ago

you need to add NewtonSoft.Json Dll.

Kurd Over a year ago

I did not find NewtonSoft.Json Dll Net 4.5. Can you send the link

Justin CI Over a year ago

you can add this package using Nuget

|

Collectives™ on Stack Overflow

How to store 2D array in postgresql using C#?

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related