{"id":235455,"date":"2024-04-15T12:20:28","date_gmt":"2024-04-15T12:20:28","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235455"},"modified":"2024-04-15T12:20:28","modified_gmt":"2024-04-15T12:20:28","slug":"how-to-get-value-from-json-column-in-postgresql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/","title":{"rendered":"How to get value from JSON column in PostgreSQL?"},"content":{"rendered":"<p>Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using the appropriate operators and functions provided by PostgreSQL.<\/p>\n<p>**To get value from a JSON column in PostgreSQL, you can use the &#8220;->&#8221; operator or the JSON functions such as json_extract_path() or jsonb_extract_path(). With these functions, you can easily navigate through the JSON structure and retrieve specific values based on keys or paths.**<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_check_if_a_JSON_column_exists_in_a_PostgreSQL_table\" title=\"How to check if a JSON column exists in a PostgreSQL table?\">How to check if a JSON column exists in a PostgreSQL table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_insert_JSON_data_into_a_JSON_column_in_PostgreSQL\" title=\"How to insert JSON data into a JSON column in PostgreSQL?\">How to insert JSON data into 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-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_update_a_value_in_a_JSON_column_in_PostgreSQL\" title=\"How to update a value in a JSON column in PostgreSQL?\">How to update a value 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-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_query_a_JSON_column_in_PostgreSQL\" title=\"How to query a JSON column in PostgreSQL?\">How to query 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-value-from-json-column-in-postgresql\/#How_to_filter_results_based_on_a_JSON_column_in_PostgreSQL\" title=\"How to filter results based on a JSON column in PostgreSQL?\">How to filter results based on 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-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_convert_a_JSON_column_to_a_different_data_type_in_PostgreSQL\" title=\"How to convert a JSON column to a different data type in PostgreSQL?\">How to convert a JSON column to a different 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-value-from-json-column-in-postgresql\/#How_to_order_results_based_on_values_in_a_JSON_column_in_PostgreSQL\" title=\"How to order results based on values in a JSON column in PostgreSQL?\">How to order results based on values 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-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_aggregate_values_from_a_JSON_column_in_PostgreSQL\" title=\"How to aggregate values from a JSON column in PostgreSQL?\">How to aggregate 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-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_extract_specific_data_from_a_nested_JSON_column_in_PostgreSQL\" title=\"How to extract specific data from a nested JSON column in PostgreSQL?\">How to extract specific data from a nested 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-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_deal_with_missing_keys_in_a_JSON_column_in_PostgreSQL\" title=\"How to deal with missing keys in a JSON column in PostgreSQL?\">How to deal with missing keys 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-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_concatenate_values_from_a_JSON_column_in_PostgreSQL\" title=\"How to concatenate values from a JSON column in PostgreSQL?\">How to concatenate 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-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#How_to_index_a_JSON_column_in_PostgreSQL_for_better_performance\" title=\"How to index a JSON column in PostgreSQL for better performance?\">How to index a JSON column in PostgreSQL for better performance?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"How_to_check_if_a_JSON_column_exists_in_a_PostgreSQL_table\"><\/span>How to check if a JSON column exists in a PostgreSQL table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo check if a JSON column exists in a PostgreSQL table, you can query the information_schema.columns table to see if the column name and data type match the JSON type.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_insert_JSON_data_into_a_JSON_column_in_PostgreSQL\"><\/span>How to insert JSON data into a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can insert JSON data into a JSON column in PostgreSQL by using the CAST or :: operator to convert a string or JSON object into the JSON data type before inserting it into the column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_update_a_value_in_a_JSON_column_in_PostgreSQL\"><\/span>How to update a value in a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo update a value in a JSON column in PostgreSQL, you can use the jsonb_set() function to change the value of a specific key within the JSON object.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_query_a_JSON_column_in_PostgreSQL\"><\/span>How to query a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo query a JSON column in PostgreSQL, you can use the -> operator to access specific keys within the JSON object or use the JSON functions to extract values based on paths.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_filter_results_based_on_a_JSON_column_in_PostgreSQL\"><\/span>How to filter results based on a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can filter results based on a JSON column in PostgreSQL by using the WHERE clause with conditions that reference specific keys or values within the JSON object.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_convert_a_JSON_column_to_a_different_data_type_in_PostgreSQL\"><\/span>How to convert a JSON column to a different data type in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can convert a JSON column to a different data type in PostgreSQL by using the CAST operator to explicitly cast the JSON column to the desired data type.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_order_results_based_on_values_in_a_JSON_column_in_PostgreSQL\"><\/span>How to order results based on values in a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can order results based on values in a JSON column in PostgreSQL by using the ORDER BY clause with the -> operator or JSON functions to access and sort the values within the JSON object.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_aggregate_values_from_a_JSON_column_in_PostgreSQL\"><\/span>How to aggregate values from a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can aggregate values from a JSON column in PostgreSQL by using the JSON functions such as json_array_elements() or jsonb_array_elements() to unnest arrays within the JSON object and perform calculations on the values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_extract_specific_data_from_a_nested_JSON_column_in_PostgreSQL\"><\/span>How to extract specific data from a nested JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can extract specific data from a nested JSON column in PostgreSQL by using the -> operator or JSON functions to navigate through the nested structure and retrieve the desired values based on keys or paths.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_deal_with_missing_keys_in_a_JSON_column_in_PostgreSQL\"><\/span>How to deal with missing keys in a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf a key is missing in a JSON column in PostgreSQL, querying that key will return a NULL value. You can handle missing keys by using the IS NULL or IS NOT NULL conditions in your queries.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_concatenate_values_from_a_JSON_column_in_PostgreSQL\"><\/span>How to concatenate values from a JSON column in PostgreSQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can concatenate values from a JSON column in PostgreSQL by using the || operator to combine strings or using the json_agg() function to aggregate multiple values into a JSON array.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_index_a_JSON_column_in_PostgreSQL_for_better_performance\"><\/span>How to index a JSON column in PostgreSQL for better performance?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo index a JSON column in PostgreSQL for better performance, you can create a GIN or GIST index on the JSON column to speed up queries that involve searching or filtering based on keys or values within the JSON object.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using the appropriate operators and functions provided by PostgreSQL. **To get value from a JSON column in PostgreSQL, you can use the &#8220;->&#8221; operator or the JSON functions such &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get value from JSON column in PostgreSQL?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#more-235455\">Read more<span class=\"screen-reader-text\">How to get value from JSON column in PostgreSQL?<\/span><\/a><\/p>\n","protected":false},"author":59,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-235455","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 value from JSON column in PostgreSQL?<\/title>\n<meta name=\"description\" content=\"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using\" \/>\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-value-from-json-column-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 value from JSON column in PostgreSQL?\" \/>\n<meta property=\"og:description\" content=\"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-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-04-15T12:20:28+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=\"Francis French\" \/>\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=\"Francis French\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-value-from-json-column-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/\"},\"author\":{\"name\":\"Francis French\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48\"},\"headline\":\"How to get value from JSON column in PostgreSQL?\",\"datePublished\":\"2024-04-15T12:20:28+00:00\",\"dateModified\":\"2024-04-15T12:20:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/\"},\"wordCount\":628,\"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-value-from-json-column-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/\",\"name\":\"How to get value from JSON column in PostgreSQL?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-04-15T12:20:28+00:00\",\"dateModified\":\"2024-04-15T12:20:28+00:00\",\"description\":\"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get value from JSON column 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\/1622769be52c41a10d83bee2c48a8c48\",\"name\":\"Francis French\",\"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\":\"Francis French\"},\"description\":\"Guest author Francis French 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 value from JSON column in PostgreSQL?","description":"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using","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-value-from-json-column-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How to get value from JSON column in PostgreSQL?","og_description":"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-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-04-15T12:20:28+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":"Francis French","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Francis French","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/"},"author":{"name":"Francis French","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/1622769be52c41a10d83bee2c48a8c48"},"headline":"How to get value from JSON column in PostgreSQL?","datePublished":"2024-04-15T12:20:28+00:00","dateModified":"2024-04-15T12:20:28+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/"},"wordCount":628,"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-value-from-json-column-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/","name":"How to get value from JSON column in PostgreSQL?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-04-15T12:20:28+00:00","dateModified":"2024-04-15T12:20:28+00:00","description":"Getting values from a JSON column in PostgreSQL can be quite straightforward with the right syntax. The key to extracting data from a JSON column is using","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-value-from-json-column-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get value from JSON column 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\/1622769be52c41a10d83bee2c48a8c48","name":"Francis French","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":"Francis French"},"description":"Guest author Francis French 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\/235455","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\/59"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=235455"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/235455\/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=235455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=235455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=235455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}