API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 27th, 2014
214
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.41 KB | None | 0 0
raw download clone embed print report
  1. List of functions
  2. Schema | Name | Result data type | Argument data types | Type
  3. ------------+------------------------------+------------------+-------------------------------------------------------------------------------+--------
  4. pg_catalog | array_to_json | json | anyarray | normal
  5. pg_catalog | array_to_json | json | anyarray, boolean | normal
  6. pg_catalog | gin_compare_jsonb | integer | text, text | normal
  7. pg_catalog | gin_consistent_jsonb | boolean | internal, smallint, anyarray, integer, internal, internal, internal, internal | normal
  8. pg_catalog | gin_consistent_jsonb_path | boolean | internal, smallint, anyarray, integer, internal, internal, internal, internal | normal
  9. pg_catalog | gin_extract_jsonb | internal | internal, internal, internal | normal
  10. pg_catalog | gin_extract_jsonb_path | internal | internal, internal, internal | normal
  11. pg_catalog | gin_extract_jsonb_query | internal | anyarray, internal, smallint, internal, internal, internal, internal | normal
  12. pg_catalog | gin_extract_jsonb_query_path | internal | anyarray, internal, smallint, internal, internal, internal, internal | normal
  13. pg_catalog | gin_triconsistent_jsonb | boolean | internal, smallint, anyarray, integer, internal, internal, internal | normal
  14. pg_catalog | gin_triconsistent_jsonb_path | boolean | internal, smallint, anyarray, integer, internal, internal, internal | normal
  15. pg_catalog | json_agg | json | anyelement | agg
  16. pg_catalog | json_agg_finalfn | json | internal | normal
  17. pg_catalog | json_agg_transfn | internal | internal, anyelement | normal
  18. pg_catalog | json_array_element | json | from_json json, element_index integer | normal
  19. pg_catalog | json_array_element_text | text | from_json json, element_index integer | normal
  20. pg_catalog | json_array_elements | SETOF json | from_json json, OUT value json | normal
  21. pg_catalog | json_array_elements_text | SETOF text | from_json json, OUT value text | normal
  22. pg_catalog | json_array_length | integer | json | normal
  23. pg_catalog | json_build_array | json | | normal
  24. pg_catalog | json_build_array | json | VARIADIC "any" | normal
  25. pg_catalog | json_build_object | json | | normal
  26. pg_catalog | json_build_object | json | VARIADIC "any" | normal
  27. pg_catalog | json_each | SETOF record | from_json json, OUT key text, OUT value json | normal
  28. pg_catalog | json_each_text | SETOF record | from_json json, OUT key text, OUT value text | normal
  29. pg_catalog | json_extract_path | json | from_json json, VARIADIC path_elems text[] | normal
  30. pg_catalog | json_extract_path_text | text | from_json json, VARIADIC path_elems text[] | normal
  31. pg_catalog | json_in | json | cstring | normal
  32. pg_catalog | json_object | json | text[] | normal
  33. pg_catalog | json_object | json | text[], text[] | normal
  34. pg_catalog | json_object_agg | json | "any", "any" | agg
  35. pg_catalog | json_object_agg_finalfn | json | internal | normal
  36. pg_catalog | json_object_agg_transfn | internal | internal, "any", "any" | normal
  37. pg_catalog | json_object_field | json | from_json json, field_name text | normal
  38. pg_catalog | json_object_field_text | text | from_json json, field_name text | normal
  39. pg_catalog | json_object_keys | SETOF text | json | normal
  40. pg_catalog | json_out | cstring | json | normal
  41. pg_catalog | json_populate_record | anyelement | base anyelement, from_json json, use_json_as_text boolean DEFAULT false | normal
  42. pg_catalog | json_populate_recordset | SETOF anyelement | base anyelement, from_json json, use_json_as_text boolean DEFAULT false | normal
  43. pg_catalog | json_recv | json | internal | normal
  44. pg_catalog | json_send | bytea | json | normal
  45. pg_catalog | json_to_record | record | json | normal
  46. pg_catalog | json_to_recordset | SETOF record | json | normal
  47. pg_catalog | json_typeof | text | json | normal
  48. pg_catalog | jsonb_array_element | jsonb | from_json jsonb, element_index integer | normal
  49. pg_catalog | jsonb_array_element_text | text | from_json jsonb, element_index integer | normal
  50. pg_catalog | jsonb_array_elements | SETOF jsonb | from_json jsonb, OUT value jsonb | normal
  51. pg_catalog | jsonb_array_elements_text | SETOF text | from_json jsonb, OUT value text | normal
  52. pg_catalog | jsonb_array_length | integer | jsonb | normal
  53. pg_catalog | jsonb_cmp | integer | jsonb, jsonb | normal
  54. pg_catalog | jsonb_contained | boolean | jsonb, jsonb | normal
  55. pg_catalog | jsonb_contains | boolean | jsonb, jsonb | normal
  56. pg_catalog | jsonb_each | SETOF record | from_json jsonb, OUT key text, OUT value jsonb | normal
  57. pg_catalog | jsonb_each_text | SETOF record | from_json jsonb, OUT key text, OUT value text | normal
  58. pg_catalog | jsonb_eq | boolean | jsonb, jsonb | normal
  59. pg_catalog | jsonb_exists | boolean | jsonb, text | normal
  60. pg_catalog | jsonb_exists_all | boolean | jsonb, text[] | normal
  61. pg_catalog | jsonb_exists_any | boolean | jsonb, text[] | normal
  62. pg_catalog | jsonb_extract_path | jsonb | from_json jsonb, VARIADIC path_elems text[] | normal
  63. pg_catalog | jsonb_extract_path_text | text | from_json jsonb, VARIADIC path_elems text[] | normal
  64. pg_catalog | jsonb_ge | boolean | jsonb, jsonb | normal
  65. pg_catalog | jsonb_gt | boolean | jsonb, jsonb | normal
  66. pg_catalog | jsonb_hash | integer | jsonb | normal
  67. pg_catalog | jsonb_in | jsonb | cstring | normal
  68. pg_catalog | jsonb_le | boolean | jsonb, jsonb | normal
  69. pg_catalog | jsonb_lt | boolean | jsonb, jsonb | normal
  70. pg_catalog | jsonb_ne | boolean | jsonb, jsonb | normal
  71. pg_catalog | jsonb_object_field | jsonb | from_json jsonb, field_name text | normal
  72. pg_catalog | jsonb_object_field_text | text | from_json jsonb, field_name text | normal
  73. pg_catalog | jsonb_object_keys | SETOF text | jsonb | normal
  74. pg_catalog | jsonb_out | cstring | jsonb | normal
  75. pg_catalog | jsonb_populate_record | anyelement | anyelement, jsonb | normal
  76. pg_catalog | jsonb_populate_recordset | SETOF anyelement | anyelement, jsonb | normal
  77. pg_catalog | jsonb_recv | jsonb | internal | normal
  78. pg_catalog | jsonb_send | bytea | jsonb | normal
  79. pg_catalog | jsonb_to_record | record | jsonb | normal
  80. pg_catalog | jsonb_to_recordset | SETOF record | jsonb | normal
  81. pg_catalog | jsonb_typeof | text | jsonb | normal
  82. pg_catalog | row_to_json | json | record | normal
  83. pg_catalog | row_to_json | json | record, boolean | normal
  84. pg_catalog | to_json | json | anyelement | normal
  85. (81 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!