PostgreSQL hstore - Error when storing data with different types

Question

I am using PostGreSQL 9.2 with the hstore extension 1.1

I have a python dict which is containing data with different types ie. integer and char.

dict = {"type": 1 , "precision": 0 , "width": 20 , "name": "test" }

When saving this dict into an hstore field, I got an error with the data "test" because its not an integer.

If I save all data in char, there would be no error

dict = {"type": "1" , "precision": "0" , "width": "20" , "name": "test" }

Is it normal that I could only have data with a unique type in an hstore field? Is there a way to store data with different types?

Nigel Tufnel · Accepted Answer · 2013-10-01 15:50:35Z

2

Hstore Documentation says:

This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value. Keys and values are simply text strings.

If you want to interpret keys/values as not strings you should do it in Python:

convert your keys/values to string before saving them to db
do the reverse operation when fetching data from db

answered Oct 1, 2013 at 15:50

Nigel Tufnel

11.6k4 gold badges38 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL hstore - Error when storing data with different types

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related