Size limit of JSON data type in PostgreSQL

by

Looking at the source for PostgreSQL 9.2.1:

Source: postgresql-9.2.1\src\backend\utils\adt\json.c:
/*
 * Input.
 */
Datum
json_in(PG_FUNCTION_ARGS)
{
    char       *text = PG_GETARG_CSTRING(0);

    json_validate_cstring(text);

    /* Internal representation is the same as text, for now */
    PG_RETURN_TEXT_P(cstring_to_text(text));
}

Update for PostgreSQL 9.3.5:

The code has changed in the json_in function, but the json internal representation is still text:

Source: postgresql-9.3.5\src\backend\utils\adt\json.c:
/*
 * Input.
 */
Datum
json_in(PG_FUNCTION_ARGS)
{
    char       *json = PG_GETARG_CSTRING(0);
    text       *result = cstring_to_text(json);
    JsonLexContext *lex;

    /* validate it */
    lex = makeJsonLexContext(result, false);
    pg_parse_json(lex, &nullSemAction);

    /* Internal representation is the same as text, for now */
    PG_RETURN_TEXT_P(result);
}

So it appears that, for now at least, json is the same as a text datatype but with JSON validation. The text datatype’s maximum size is 1GB.

More Related Contents:

  1. How do I modify fields inside the new PostgreSQL JSON datatype?
  2. How do I query using fields inside the new PostgreSQL JSON datatype?
  3. Flatten aggregated key/value pairs from a JSONB field?
  4. Explanation of JSONB introduced by PostgreSQL
  5. Postgres: How to convert a json string to text?
  6. How to query a json column for empty objects?
  7. PostgreSQL return result set as JSON array?
  8. How to create index on JSON field in Postgres?
  9. How to convert postgres json to integer
  10. Postgres JSON data type Rails query
  11. Check if a Postgres JSON array contains a string
  12. Merging JSONB values in PostgreSQL?
  13. Collect Recursive JSON Keys In Postgres
  14. In postgresql, how can I return a boolean value instead of string on a jsonb key?
  15. How do I initialize a TypeScript Object with a JSON-Object?
  16. How to escape double quotes in JSON
  17. With JSONDecoder in Swift 4, can missing keys use a default value instead of having to be optional properties?
  18. Using curl POST with variables defined in bash script functions
  19. How to parse a JSON object to a TypeScript Object
  20. jq: print key and value for each entry in an object
  21. How to parse nested JSON object in Delphi XE2?
  22. Which JSON content type do I use?
  23. Can a JSON value contain a multiline string
  24. How can I tell RestTemplate to POST with UTF-8 encoding?
  25. how to parse json using groovy
  26. Operator does not exist: json = json
  27. gson: Treat null as empty String
  28. Convert JSON String to Lua Table?
  29. JsonMappingException: could not initialize proxy – no Session
  30. JSON Parser -java.lang.NoSuchFieldError: defaultReader

Leave a Comment