Best column data type for JSON data in PostgreSQL < 9.2?

Question

I'm going to store records with arbitrary fields, and the custom ones will automatically go into a separate serialized field. I don't care that they're not searchable nor sortable.

I've chosen the JSON serialization format. What is the best column data type, provided I don't have the new json type?

GreyBeardedGeek · Accepted Answer · 2013-11-06 23:41:17Z

1

The underlying data type in 9.2 is TEXT, so you should be able to use that - see http://michael.otacoo.com/postgresql-2/postgres-9-2-highlight-json-data-type/

answered Nov 6, 2013 at 23:41

GreyBeardedGeek

30.3k2 gold badges51 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

Best column data type for JSON data in PostgreSQL < 9.2?

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