Hello,

I have (let us say) an abject and hypothetically let us say CAR, this object can have attribute and these attributes might have different type domains. for example, the car speed is 200 and the car does not have an airbag

So I can have something like this

Attribute (attribute_id attribute name)
1 speed
2 has air bag
....

and I have

table car_attribute (car_id .., attribute_id.., attribute_value boolean ) or

table car_attribute (car_id .., attribute_id.., attribute_value real ) or

.....

What are the design options and is there is a special features in postgres helps in this design.

Regards

This is what the hstore module is for.

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: hstore