How to update a Jsonb type column in postgres database using normal sql query?

Asked Feb 11 '22 at 11:37

Active Feb 11 '22 at 11:37

Viewed 227 times

I have defined a Class KeyValue as jsonb type in one of tables in Postgres.

Public Class KeyValue
{
public string Key { get; set; }
public string Value { get; set; }
}

Public Class Table
{
  [Column("tags", TypeName = "jsonb")]
  public KeyValue Tags { get; set; }
}

I am getting error "KeyValue isn't natively supported by Npgsql or your PostgreSQL. To use it with a PostgreSQL composite you need to specify DataTypeName or to map it, please refer to the documentation"

asked Feb 11 '22 at 11:37

Sumesh Es

In which case did you get this error? Could you please provide more information? – Dmitry Grebennikov Feb 11 '22 at 11:43
I am trying to update my table like "Update Table set Tags='KeyValue Class Data' where Id=someid" – Sumesh Es Feb 11 '22 at 11:47
In this case you can't update jsonb data in table like this. First you need to fetch the required data, make some changes inside it and after that update the whole jsonb object in table. – Dmitry Grebennikov Feb 11 '22 at 11:53
1

Check this post: https://stackoverflow.com/questions/26703476/how-to-perform-update-operations-on-columns-of-type-jsonb-in-postgres-9-4 – Dmitry Grebennikov Feb 11 '22 at 11:53

How to update a Jsonb type column in postgres database using normal sql query?

0 Answers0