'How to query property on object while the object inside column of table in postgresql? Typeorm

I'm working with PostgreSQL as data storage. I have one column that filling text type and object oriented. For an instance,

company {
  name: "A Inc",
  companySize: "10000",
  address: "A Street",
}

The case, is could I get one of them one by one with orm or querybuilder? such of

where company.companySize = "10000"

enter image description here

javascripttypescriptpostgresqlnestjstypeorm


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions