{"id":201671,"date":"2024-11-12T11:26:42","date_gmt":"2024-11-12T11:26:42","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/"},"modified":"2024-11-12T11:26:42","modified_gmt":"2024-11-12T11:26:42","slug":"how-to-get-json-value-in-postgresql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/","title":{"rendered":"How to get JSON value in PostgreSQL?"},"content":{"rendered":"<p>PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON data in PostgreSQL, you may encounter the need to extract specific values from the JSON document. In this article, we will explore how to get JSON value in PostgreSQL and provide answers to some related questions.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#How_to_get_JSON_value_in_PostgreSQL\" title=\"How to get JSON value in PostgreSQL?\">How to get JSON value in PostgreSQL?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#FAQs_on_How_to_get_JSON_value_in_PostgreSQL\" title=\"FAQs on How to get JSON value in PostgreSQL\">FAQs on How to get JSON value in PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#1_Can_I_extract_nested_JSON_values_in_PostgreSQL\" title=\"1. Can I extract nested JSON values in PostgreSQL?\">1. Can I extract nested JSON values in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#2_How_can_I_check_if_a_JSON_key_exists_in_a_JSON_column_in_PostgreSQL\" title=\"2. How can I check if a JSON key exists in a JSON column in PostgreSQL?\">2. How can I check if a JSON key exists in a JSON column in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#3_Is_it_possible_to_extract_multiple_JSON_values_in_a_single_query_in_PostgreSQL\" title=\"3. Is it possible to extract multiple JSON values in a single query in PostgreSQL?\">3. Is it possible to extract multiple JSON values in a single query in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#4_How_can_I_convert_a_JSON_value_to_a_specific_data_type_in_PostgreSQL\" title=\"4. How can I convert a JSON value to a specific data type in PostgreSQL?\">4. How can I convert a JSON value to a specific data type in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#5_Can_I_filter_rows_based_on_JSON_values_in_PostgreSQL\" title=\"5. Can I filter rows based on JSON values in PostgreSQL?\">5. Can I filter rows based on JSON values in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#6_How_can_I_extract_all_keys_from_a_JSON_column_in_PostgreSQL\" title=\"6. How can I extract all keys from a JSON column in PostgreSQL?\">6. How can I extract all keys from a JSON column in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#7_Is_it_possible_to_update_JSON_values_in_PostgreSQL\" title=\"7. Is it possible to update JSON values in PostgreSQL?\">7. Is it possible to update JSON values in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#8_How_can_I_extract_values_from_an_array_within_a_JSON_column_in_PostgreSQL\" title=\"8. How can I extract values from an array within a JSON column in PostgreSQL?\">8. How can I extract values from an array within a JSON column in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#9_Can_I_perform_aggregation_functions_on_JSON_values_in_PostgreSQL\" title=\"9. Can I perform aggregation functions on JSON values in PostgreSQL?\">9. Can I perform aggregation functions on JSON values in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#10_How_can_I_fetch_distinct_JSON_values_from_a_JSON_column_in_PostgreSQL\" title=\"10. How can I fetch distinct JSON values from a JSON column in PostgreSQL?\">10. How can I fetch distinct JSON values from a JSON column in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#11_Is_it_possible_to_compare_JSON_values_in_PostgreSQL\" title=\"11. Is it possible to compare JSON values in PostgreSQL?\">11. Is it possible to compare JSON values in PostgreSQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#12_How_can_I_order_query_results_based_on_JSON_values_in_PostgreSQL\" title=\"12. How can I order query results based on JSON values in PostgreSQL?\">12. How can I order query results based on JSON values in PostgreSQL?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_get_JSON_value_in_PostgreSQL\"><\/span>How to get JSON value in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>**To get a JSON value in PostgreSQL, you can use the -> operator to extract a specific key from a JSON column in a table. For example, if you have a JSON column named &#8220;data&#8221; in a table &#8220;my_table&#8221; and you want to retrieve the value of key &#8220;name&#8221;, you can use the following query:**<\/p>\n<p>&#8220;`sql<br \/>\nSELECT data->&#8217;name&#8217; AS name<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<p>This query will return the value of the key &#8220;name&#8221; from the JSON column &#8220;data&#8221; as a text value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs_on_How_to_get_JSON_value_in_PostgreSQL\"><\/span>FAQs on How to get JSON value in PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_extract_nested_JSON_values_in_PostgreSQL\"><\/span>1. Can I extract nested JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can extract nested JSON values in PostgreSQL by using the -> operator multiple times to navigate through the JSON hierarchy.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_can_I_check_if_a_JSON_key_exists_in_a_JSON_column_in_PostgreSQL\"><\/span>2. How can I check if a JSON key exists in a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the ? operator to check if a JSON key exists in a JSON column. For example, to check if the key &#8220;age&#8221; exists in the JSON column &#8220;data&#8221;, you can use the following query: <br \/>\n&#8220;`sql <br \/>\nSELECT data ? &#8216;age&#8217; <br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Is_it_possible_to_extract_multiple_JSON_values_in_a_single_query_in_PostgreSQL\"><\/span>3. Is it possible to extract multiple JSON values in a single query in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can extract multiple JSON values in a single query by specifying multiple keys in the -> operator. For example, you can extract the values of keys &#8220;name&#8221; and &#8220;age&#8221; using the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT data->&#8217;name&#8217; AS name, data->&#8217;age&#8217; AS age<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_How_can_I_convert_a_JSON_value_to_a_specific_data_type_in_PostgreSQL\"><\/span>4. How can I convert a JSON value to a specific data type in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the :: operator to cast a JSON value to a specific data type in PostgreSQL. For example, to convert a JSON value to an integer, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT (data->>&#8217;age&#8217;)::int AS age<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_filter_rows_based_on_JSON_values_in_PostgreSQL\"><\/span>5. Can I filter rows based on JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can filter rows based on JSON values in PostgreSQL by using the -> operator in the WHERE clause. For example, to filter rows where the value of key &#8220;status&#8221; is &#8220;active&#8221;, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT *<br \/>\nFROM my_table<br \/>\nWHERE data->>&#8217;status&#8217; = &#8216;active&#8217;;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_can_I_extract_all_keys_from_a_JSON_column_in_PostgreSQL\"><\/span>6. How can I extract all keys from a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the json_object_keys function to extract all keys from a JSON column in PostgreSQL. For example, to extract all keys from the JSON column &#8220;data&#8221;, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT json_object_keys(data) AS keys<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Is_it_possible_to_update_JSON_values_in_PostgreSQL\"><\/span>7. Is it possible to update JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can update JSON values in PostgreSQL using the -> operator in the UPDATE statement. For example, to update the value of key &#8220;status&#8221; to &#8220;inactive&#8221;, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nUPDATE my_table<br \/>\nSET data = jsonb_set(data, &#8216;{status}&#8217;, &#8216;&#8221;inactive&#8221;&#8216;, true)<br \/>\nWHERE id = 1;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_can_I_extract_values_from_an_array_within_a_JSON_column_in_PostgreSQL\"><\/span>8. How can I extract values from an array within a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the json_array_elements function to extract values from an array within a JSON column in PostgreSQL. For example, to extract all values from an array stored in the key &#8220;items&#8221; within the JSON column &#8220;data&#8221;, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT json_array_elements(data->&#8217;items&#8217;) AS item<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_perform_aggregation_functions_on_JSON_values_in_PostgreSQL\"><\/span>9. Can I perform aggregation functions on JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can perform aggregation functions on JSON values in PostgreSQL by using the -> operator in combination with aggregate functions like SUM, AVG, COUNT, etc.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_How_can_I_fetch_distinct_JSON_values_from_a_JSON_column_in_PostgreSQL\"><\/span>10. How can I fetch distinct JSON values from a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the DISTINCT keyword in combination with the -> operator to fetch distinct JSON values from a JSON column in PostgreSQL. For example, to fetch distinct values of key &#8220;city&#8221; from the JSON column &#8220;data&#8221;, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT DISTINCT data->>&#8217;city&#8217; AS city<br \/>\nFROM my_table;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Is_it_possible_to_compare_JSON_values_in_PostgreSQL\"><\/span>11. Is it possible to compare JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can compare JSON values in PostgreSQL using comparison operators like =, <, >, etc. For example, to compare the values of key &#8220;age&#8221; between two JSON columns, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT *<br \/>\nFROM my_table<br \/>\nWHERE (data1->>&#8217;age&#8217;)::int > (data2->>&#8217;age&#8217;)::int;<br \/>\n&#8220;`<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_How_can_I_order_query_results_based_on_JSON_values_in_PostgreSQL\"><\/span>12. How can I order query results based on JSON values in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the -> operator in the ORDER BY clause to order query results based on JSON values in PostgreSQL. For example, to order query results by the value of key &#8220;name&#8221; in ascending order, you can use the following query:<br \/>\n&#8220;`sql<br \/>\nSELECT *<br \/>\nFROM my_table<br \/>\nORDER BY data->>&#8217;name&#8217; ASC;<br \/>\n&#8220;`<\/p>\n<p>In conclusion, extracting JSON values in PostgreSQL is a powerful feature that allows you to work with JSON data efficiently. By mastering the techniques discussed in this article, you can manipulate and query JSON data in PostgreSQL effectively for your projects.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON data in PostgreSQL, you may encounter the need to extract specific values from the JSON document. In this article, we will explore how to get JSON value in PostgreSQL and provide &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get JSON value in PostgreSQL?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#more-201671\">Read more<span class=\"screen-reader-text\">How to get JSON value in PostgreSQL?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-201671","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get JSON value in PostgreSQL?<\/title>\n<meta name=\"description\" content=\"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get JSON value in PostgreSQL?\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-12T11:26:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to get JSON value in PostgreSQL?\",\"datePublished\":\"2024-11-12T11:26:42+00:00\",\"dateModified\":\"2024-11-12T11:26:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\"},\"wordCount\":883,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\",\"name\":\"How to get JSON value in PostgreSQL?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-11-12T11:26:42+00:00\",\"dateModified\":\"2024-11-12T11:26:42+00:00\",\"description\":\"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get JSON value in PostgreSQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get JSON value in PostgreSQL?","description":"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How to get JSON value in PostgreSQL?","og_description":"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-11-12T11:26:42+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to get JSON value in PostgreSQL?","datePublished":"2024-11-12T11:26:42+00:00","dateModified":"2024-11-12T11:26:42+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/"},"wordCount":883,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/","name":"How to get JSON value in PostgreSQL?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-11-12T11:26:42+00:00","dateModified":"2024-11-12T11:26:42+00:00","description":"PostgreSQL is a powerful open-source relational database system that also offers support for storing and querying JSON data. If you are working with JSON","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-json-value-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get JSON value in PostgreSQL?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=201671"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201671\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=201671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=201671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=201671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}