{"id":2382,"date":"2024-03-12T09:42:42","date_gmt":"2024-03-12T09:42:42","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/"},"modified":"2024-03-19T13:30:38","modified_gmt":"2024-03-19T13:30:38","slug":"how-are-json-and-xml-data-types-handled-in-postgresql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/","title":{"rendered":"How are JSON and XML data types handled in PostgreSQL?"},"content":{"rendered":"

In PostgreSQL, JSON and XML data types can be used to store and manipulate data in the respective formats.<\/p>\n

Handle JSON data type<\/p>\n

    \n
  1. Create a table called “table_name” with a column named “data_column” that stores JSON data.<\/li>\n
  2. Add a new entry to the table with the specified data column value.<\/li>\n
  3. Retrieve all rows from the table where the value in the data_column key matches the specified value.<\/li>\n
  4. Update the table by adding a new key-value pair to the existing data column.<\/li>\n<\/ol>\n

    Manage XML data types.<\/p>\n

      \n
    1. Create a table named table_name with a column named data_column of data type XML.<\/li>\n
    2. Add the value ‘value’ into the specified data column of the table named table_name.<\/li>\n
    3. Retrieve all rows from the table where the data in the specified column matches the provided value.<\/li>\n
    4. Modify the data_column in the table_name to have the value ‘new_value<\/new_data>‘.<\/li>\n<\/ol>\n

      It is important to note that when dealing with JSON and XML data types, it is necessary to ensure that the input data format conforms to the corresponding JSON and XML formats. Additionally, PostgreSQL also provides some built-in functions and operators to facilitate manipulation and querying of JSON and XML data.<\/p>\n","protected":false},"excerpt":{"rendered":"

      In PostgreSQL, JSON and XML data types can be used to store and manipulate data in the respective formats. Handle JSON data type Create a table called “table_name” with a column named “data_column” that stores JSON data. Add a new entry to the table with the specified data column value. Retrieve all rows from the […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2382","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow are JSON and XML data types handled in PostgreSQL? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How are JSON and XML data types handled in PostgreSQL?\" \/>\n<meta property=\"og:description\" content=\"In PostgreSQL, JSON and XML data types can be used to store and manipulate data in the respective formats. Handle JSON data type Create a table called “table_name” with a column named “data_column” that stores JSON data. Add a new entry to the table with the specified data column value. Retrieve all rows from the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-12T09:42:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-19T13:30:38+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How are JSON and XML data types handled in PostgreSQL?\",\"datePublished\":\"2024-03-12T09:42:42+00:00\",\"dateModified\":\"2024-03-19T13:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\"},\"wordCount\":211,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\",\"name\":\"How are JSON and XML data types handled in PostgreSQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-12T09:42:42+00:00\",\"dateModified\":\"2024-03-19T13:30:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How are JSON and XML data types handled in PostgreSQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How are JSON and XML data types handled in PostgreSQL? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How are JSON and XML data types handled in PostgreSQL?","og_description":"In PostgreSQL, JSON and XML data types can be used to store and manipulate data in the respective formats. Handle JSON data type Create a table called “table_name” with a column named “data_column” that stores JSON data. Add a new entry to the table with the specified data column value. Retrieve all rows from the […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-12T09:42:42+00:00","article_modified_time":"2024-03-19T13:30:38+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How are JSON and XML data types handled in PostgreSQL?","datePublished":"2024-03-12T09:42:42+00:00","dateModified":"2024-03-19T13:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/"},"wordCount":211,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/","url":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/","name":"How are JSON and XML data types handled in PostgreSQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-12T09:42:42+00:00","dateModified":"2024-03-19T13:30:38+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-are-json-and-xml-data-types-handled-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How are JSON and XML data types handled in PostgreSQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/2382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=2382"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/2382\/revisions"}],"predecessor-version":[{"id":35233,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/2382\/revisions\/35233"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=2382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=2382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=2382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}