{"id":502,"date":"2026-05-17T07:03:41","date_gmt":"2026-05-16T23:03:41","guid":{"rendered":"https:\/\/junai.ai\/blog\/pg-jsonb-12\/"},"modified":"2026-05-17T07:03:41","modified_gmt":"2026-05-16T23:03:41","slug":"pg-jsonb-12","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/pg-jsonb-12\/","title":{"rendered":"JSON\u00b7jsonb \ub2e4\ub8e8\uae30 \u2014 -&gt;\u00b7-&gt;&gt;\u00b7@&gt; (\uae30\ucd08 12\ud3b8)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 290 -->\n<div style=\"max-width:800px;margin:0 auto;\">\n<style>\n:root{--color-primary:#336791;--color-accent:#60a5fa;--color-bg:#fafafa;--color-bg-card:#ffffff;--color-text:#1e293b;--color-text-muted:#64748b;--hero-start:#0f172a;--hero-end:#336791;--font-body:-apple-system,BlinkMacSystemFont,'Apple SD Gothic Neo','Noto Sans KR',sans-serif;--size-body:17px;--line-height:1.75;}\n*{box-sizing:border-box;}\n.container{max-width:760px;margin:0 auto;padding:0 22px 80px;}\n.hero{background:linear-gradient(135deg,var(--hero-start) 0%,var(--hero-end) 100%);color:#fff;padding:72px 22px 56px;text-align:center;}\n.hero .badge{display:inline-block;background:rgba(96,165,250,0.18);color:var(--color-accent);padding:6px 14px;border-radius:999px;font-size:13px;font-weight:600;letter-spacing:0.5px;margin-bottom:18px;}\n.hero h1{margin:0 0 18px;font-size:36px;line-height:1.3;letter-spacing:-0.3px;}\n.hero p.sub{margin:0 auto;max-width:580px;font-size:17px;color:#bfdbfe;}\n.hero img{width:100%;max-width:720px;height:auto;margin:36px auto 0;display:block;border-radius:10px;box-shadow:0 8px 32px rgba(0,0,0,0.3);}\n.meta{display:flex;gap:14px;justify-content:center;margin-top:20px;font-size:13px;color:#93c5fd;flex-wrap:wrap;}\n.meta span::before{content:\"\u00b7\";margin-right:14px;color:#1e3a8a;}\n.meta span:first-child::before{content:\"\";margin:0;}\narticle{background:var(--color-bg-card);margin-top:-36px;padding:44px 28px;border-radius:14px;box-shadow:0 2px 18px rgba(0,0,0,0.06);}\narticle p{margin:0 0 18px;}\nh2{font-size:28px;line-height:1.35;letter-spacing:-0.3px;margin:48px 0 18px;padding-bottom:10px;border-bottom:2px solid var(--color-primary);}\nh2:first-of-type{margin-top:8px;}\nh3{font-size:21px;line-height:1.4;margin:30px 0 12px;color:var(--color-primary);}\ncode{background:#f1f5f9;color:#0f172a;padding:2px 6px;border-radius:4px;font-family:'SFMono-Regular',Menlo,Consolas,monospace;font-size:0.92em;}\npre{background:#0f172a;color:#e2e8f0;padding:18px 20px;border-radius:10px;overflow-x:auto;font-size:14.5px;line-height:1.65;margin:18px 0;}\npre code{background:transparent;color:inherit;padding:0;}\nul,ol{margin:0 0 18px;padding-left:24px;}\nli{margin-bottom:8px;}\nstrong{color:#0f172a;}\n.databox{background:#eff6ff;border-left:4px solid var(--color-primary);padding:18px 20px;border-radius:6px;margin:22px 0;}\n.databox p{margin:0 0 8px;}\n.databox p:last-child{margin:0;}\n.databox strong{color:var(--color-primary);}\n.warnbox{background:linear-gradient(135deg,#fef3c7 0%,#fde68a 100%);border-left:4px solid #d97706;padding:18px 20px;border-radius:6px;margin:22px 0;}\n.warnbox strong{color:#92400e;}\n.tablewrap{overflow-x:auto;-webkit-overflow-scrolling:touch;margin:22px 0;}\ntable{width:100%;border-collapse:collapse;font-size:15px;background:var(--color-bg-card);}\nth,td{padding:11px 12px;text-align:left;border-bottom:1px solid #e2e8f0;vertical-align:top;}\nth{background:#f1f5f9;font-weight:700;color:#0f172a;}\ntd:first-child,th:first-child{font-weight:700;}\n.cta{background:linear-gradient(135deg,#336791 0%,#60a5fa 100%);color:#fff;padding:30px 24px;border-radius:12px;margin-top:44px;text-align:center;}\n.cta h3{color:#fff;margin:0 0 10px;}\n.cta p{margin:0;color:#dbeafe;}\n.series-nav{background:#eff6ff;padding:18px 22px;border-radius:10px;margin-top:24px;font-size:14.5px;color:var(--color-text-muted);}\n.series-nav strong{color:var(--color-primary);}\n@media (max-width:480px){.hero{padding:52px 18px 44px;}.hero h1{font-size:26px;}.hero p.sub{font-size:15px;}article{padding:28px 18px;border-radius:10px;}h2{font-size:22px;}h3{font-size:18px;}body{font-size:16px;}pre{font-size:13px;padding:14px 16px;}}\n@media (max-width:560px){.tablewrap table,.tablewrap thead,.tablewrap tbody,.tablewrap tr,.tablewrap th,.tablewrap td{display:block;width:auto;}.tablewrap thead{display:none;}.tablewrap tr{margin:0 0 14px;border:1px solid #e2e8f0;border-radius:10px;overflow:hidden;}.tablewrap td{border:none;border-bottom:1px solid #f1f5f9;padding:9px 14px;}.tablewrap td:first-child{background:#eff6ff;font-weight:800;font-size:15.5px;}.tablewrap td:last-child{border-bottom:none;}.tablewrap td[data-label]::before{content:attr(data-label) \" \u2014 \";font-weight:700;color:var(--color-primary);}}\n<\/style>\n<header class=\"hero\">\n  <span class=\"badge\">PostgreSQL \uad50\uc7ac \u00b7 12\ud3b8 \/ 24\ud3b8<\/span>\n  <h1>JSON\u00b7jsonb \ub2e4\ub8e8\uae30 \u2014 ->\u00b7->>\u00b7@><\/h1>\n  <p class=\"sub\">\uc2a4\ud0a4\ub9c8 \uc5c6\ub294 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \u2014 \uc5f0\uc0b0\uc790 5\uac1c\uc640 GIN \uc778\ub371\uc2a4.<\/p>\n  <div class=\"meta\"><span>SQL \uae30\ucd08<\/span><span>\uc77d\ub294 \uc2dc\uac04 7\ubd84<\/span><span>2026-05-17<\/span><\/div>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-69.jpg\" alt=\"jsonb \uc758 \ub2e4\uc591\ud55c \uc5f0\uc0b0\uc790\uac00 JSON \uac1d\uccb4\uc5d0\uc11c \uac12\uc744 \ucd94\ucd9c\ud558\ub294 \ub3c4\uc2dd\">\n<\/header>\n\n<div class=\"container\">\n<article>\n\n<p>API \uc751\ub2f5\u00b7\ub85c\uadf8\u00b7\uc124\uc815\u00b7\uba54\ud0c0\ub370\uc774\ud130 \u2014 &#8220;\uc2a4\ud0a4\ub9c8\uac00 \uc790\uc8fc \ubc14\ub00c\uac70\ub098 \ubaa8\uc591\uc774 \ub4e4\ucb49\ub0a0\ucb49&#8221; \ud55c \ub370\uc774\ud130\ub97c \uc815\uc2dd \uceec\ub7fc\uc73c\ub85c \ub9cc\ub4e4\uae30 \ubd80\ub2f4\uc2a4\ub7ec\uc6b8 \ub54c <strong>jsonb<\/strong> \uac00 \ub2f5\uc785\ub2c8\ub2e4. 12\ud3b8\uc740 \ud575\uc2ec \uc5f0\uc0b0\uc790 5\uac1c, jsonb_set, GIN \uc778\ub371\uc2a4, \uadf8\ub9ac\uace0 &#8220;\uc5b8\uc81c jsonb \uac00 \uc801\uc808\ud55c\uac00&#8221; \uc758 \uac00\uc774\ub4dc\uae4c\uc9c0.<\/p>\n\n<h2>json vs jsonb \u2014 \ud56d\uc0c1 jsonb<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th><\/th><th>json<\/th><th>jsonb<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\">\uc800\uc7a5<\/td><td data-label=\"json\">\uc6d0\ubcf8 \ud14d\uc2a4\ud2b8 \uadf8\ub300\ub85c<\/td><td data-label=\"jsonb\">\ud30c\uc2f1\ub41c \ubc14\uc774\ub108\ub9ac<\/td><\/tr>\n    <tr><td data-label=\"\">\uc785\ub825<\/td><td data-label=\"json\">\uc870\uae08 \ube60\ub984<\/td><td data-label=\"jsonb\">\uc870\uae08 \ub290\ub9bc (\ud30c\uc2f1)<\/td><\/tr>\n    <tr><td data-label=\"\">\uc870\ud68c\u00b7\uc5f0\uc0b0<\/td><td data-label=\"json\">\ub290\ub9bc (\ub9e4\ubc88 \ud30c\uc2f1)<\/td><td data-label=\"jsonb\">\ube60\ub984<\/td><\/tr>\n    <tr><td data-label=\"\">\ud0a4 \uc21c\uc11c \ubcf4\uc874<\/td><td data-label=\"json\">\uc608<\/td><td data-label=\"jsonb\">\uc544\ub2c8\uc624<\/td><\/tr>\n    <tr><td data-label=\"\">\uc911\ubcf5 \ud0a4<\/td><td data-label=\"json\">\uc720\uc9c0<\/td><td data-label=\"jsonb\">\ub9c8\uc9c0\ub9c9 \uac83\ub9cc<\/td><\/tr>\n    <tr><td data-label=\"\">\uc778\ub371\uc2f1<\/td><td data-label=\"json\">\uc81c\ud55c\uc801<\/td><td data-label=\"jsonb\">GIN \uac15\ub825<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<p>\uac70\uc758 \ud56d\uc0c1 <code>jsonb<\/code>. json \uc740 &#8220;\uc6d0\ubcf8\uc744 \uae00\uc790 \ub2e8\uc704\ub85c \ubcf4\uc874\ud574\uc57c \ud55c\ub2e4&#8221; \uac19\uc740 \ud2b9\uc218 \uc0ac\ub840\uc5d0\ub9cc.<\/p>\n\n<h2>\ud14c\uc774\ube14 \ub9cc\ub4e4\uace0 \ub370\uc774\ud130 \ub123\uae30<\/h2>\n\n<pre><code>CREATE TABLE products (\n  id   BIGSERIAL PRIMARY KEY,\n  name TEXT NOT NULL,\n  meta JSONB NOT NULL DEFAULT '{}'::jsonb\n);\n\nINSERT INTO products (name, meta) VALUES\n  ('\ud2f0\uc154\uce20', '{\"size\": \"L\", \"color\": \"black\", \"tags\": [\"sale\", \"new\"]}'),\n  ('\ucef5',     '{\"size\": \"M\", \"color\": \"white\", \"tags\": [\"hot\"], \"stock\": 5}'),\n  ('\ubcfc\ud39c',   '{\"color\": \"blue\"}');<\/code><\/pre>\n\n<h2>5\uac00\uc9c0 \ud575\uc2ec \uc5f0\uc0b0\uc790<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th>\uc5f0\uc0b0\uc790<\/th><th>\ubc18\ud658<\/th><th>\uc608\uc2dc<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"op\">-&gt;<\/td><td data-label=\"ret\">jsonb<\/td><td data-label=\"ex\">meta-&gt;&#8217;size&#8217; \u2192 &#8220;L&#8221;::jsonb<\/td><\/tr>\n    <tr><td data-label=\"op\">-&gt;&gt;<\/td><td data-label=\"ret\">text<\/td><td data-label=\"ex\">meta-&gt;&gt;&#8217;size&#8217; \u2192 &#8216;L&#8217; (\ub530\uc634\ud45c \uc5c6\uc74c)<\/td><\/tr>\n    <tr><td data-label=\"op\">#&gt;<\/td><td data-label=\"ret\">jsonb (\uacbd\ub85c)<\/td><td data-label=\"ex\">meta#&gt;'{tags,0}&#8217; \u2192 &#8220;sale&#8221;::jsonb<\/td><\/tr>\n    <tr><td data-label=\"op\">#&gt;&gt;<\/td><td data-label=\"ret\">text (\uacbd\ub85c)<\/td><td data-label=\"ex\">meta#&gt;&gt;'{tags,0}&#8217; \u2192 &#8216;sale&#8217;<\/td><\/tr>\n    <tr><td data-label=\"op\">@&gt;<\/td><td data-label=\"ret\">boolean<\/td><td data-label=\"ex\">meta @&gt; &#8216;{&#8220;color&#8221;:&#8221;black&#8221;}&#8217; \u2192 true<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<pre><code>-- \uc0c9\uae54\ub9cc \ubf51\uae30\nSELECT name, meta-&gt;&gt;'color' AS color FROM products;\n\n-- \uc0ac\uc774\uc988 L \ub9cc\nSELECT name FROM products WHERE meta-&gt;&gt;'size' = 'L';\n\n-- \ub610\ub294 contains \uc5f0\uc0b0\uc790\nSELECT name FROM products WHERE meta @&gt; '{\"size\":\"L\"}';\n\n-- \ud0dc\uadf8 \uccab \ubc88\uc9f8 \ud56d\ubaa9\nSELECT name, meta#&gt;&gt;'{tags,0}' AS first_tag FROM products;\n\n-- \ud2b9\uc815 \ud0dc\uadf8 \ud3ec\ud568 \uac80\uc0ac (jsonb \ubc30\uc5f4)\nSELECT name FROM products WHERE meta-&gt;'tags' ? 'sale';<\/code><\/pre>\n\n<div class=\"databox\">\n  <p><strong>-&gt; vs -&gt;&gt; \ud55c \uc904 \ucc28\uc774.<\/strong> <code>-&gt;<\/code> \ub294 jsonb \uadf8\ub300\ub85c(\ub530\uc634\ud45c \uc0b4\uc544\uc788\uc74c), <code>-&gt;&gt;<\/code> \ub294 text \ub85c \ud480\uc5b4\uc90c. WHERE \ube44\uad50\ub294 \ubcf4\ud1b5 <code>-&gt;&gt;<\/code>, \ub354 \uae4a\uc774 \ub4e4\uc5b4\uac00\uc57c \ud558\uba74 <code>-&gt;<\/code>.<\/p>\n<\/div>\n\n<h2>jsonb_set \u2014 \ubd80\ubd84 \uc218\uc815<\/h2>\n\n<pre><code>-- meta.color \ub97c 'red' \ub85c \ubc14\uafb8\uae30\nUPDATE products\nSET    meta = jsonb_set(meta, '{color}', '\"red\"')\nWHERE  id = 1;\n\n-- \uae4a\uc740 \uacbd\ub85c\nUPDATE products\nSET    meta = jsonb_set(meta, '{address,city}', '\"\uc11c\uc6b8\"', true)\nWHERE  id = 1;\n-- create_missing=true \u2192 \uacbd\ub85c \uc5c6\uc73c\uba74 \ub9cc\ub4e6\n\n-- \ud0a4 \uc0ad\uc81c\nUPDATE products SET meta = meta - 'stock' WHERE id = 2;\nUPDATE products SET meta = meta #- '{address,city}' WHERE id = 1;\n\n-- \uac1d\uccb4 \ud569\uce58\uae30 (||)\nUPDATE products SET meta = meta || '{\"featured\":true}' WHERE id = 1;<\/code><\/pre>\n\n<h2>GIN \uc778\ub371\uc2a4 \u2014 jsonb \uac80\uc0c9 \uac00\uc18d<\/h2>\n\n<pre><code>-- \uc804\uccb4 jsonb \uc5d0 \uc778\ub371\uc2a4 (\ubaa8\ub4e0 \ud0a4\u00b7\uac12 \uac80\uc0c9)\nCREATE INDEX ix_products_meta ON products USING GIN (meta);\n\n-- @&gt; ? ?| ?&amp; \uc5f0\uc0b0\uc790\uac00 \uc778\ub371\uc2a4 \uc0ac\uc6a9\nSELECT * FROM products WHERE meta @&gt; '{\"color\":\"black\"}';   -- \ube60\ub984\n\n-- \ud2b9\uc815 \ud0a4\ub9cc (path ops \ub354 \uc791\uc74c)\nCREATE INDEX ix_products_meta_path ON products USING GIN (meta jsonb_path_ops);\n\n-- \ud2b9\uc815 \ud0a4\ub9cc \ub530\ub85c \u2014 B-tree \ud45c\ud604\uc2dd \uc778\ub371\uc2a4\nCREATE INDEX ix_products_color ON products ((meta-&gt;&gt;'color'));<\/code><\/pre>\n\n<div class=\"warnbox\">\n  <p><strong>GIN \uc778\ub371\uc2a4\uc758 \ube44\uc6a9.<\/strong> \uac15\ub825\ud558\uc9c0\ub9cc \uc785\ub825 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c0\uace0, \uc778\ub371\uc2a4 \ud06c\uae30\ub3c4 \ud07d\ub2c8\ub2e4. <strong>\uc2e4\uc81c\ub85c \uac80\uc0c9\uc5d0 \uc4f0\ub294 jsonb \uceec\ub7fc\uc5d0\ub9cc<\/strong> \ub450\uace0, \uc790\uc8fc \uac80\uc0c9\ud558\ub294 \ub2e8\uc77c \ud0a4\ub294 \ud45c\ud604\uc2dd \uc778\ub371\uc2a4(B-Tree) \uac00 \ub354 \uac00\ubcbc\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n\n<h2>jsonb \uc9d1\uacc4 \u2014 \ubc30\uc5f4\ub85c \ubaa8\uc73c\uae30<\/h2>\n\n<pre><code>-- \uce74\ud14c\uace0\ub9ac\ubcc4 jsonb \ubc30\uc5f4\ub85c \ud569\uce58\uae30\nSELECT category_id,\n       jsonb_agg(meta) AS all_meta,\n       jsonb_object_agg(name, meta) AS by_name\nFROM   products\nGROUP BY category_id;\n\n-- \ubc30\uc5f4 \ud480\uae30 (jsonb_array_elements)\nSELECT id, t.tag\nFROM   products,\n       jsonb_array_elements_text(meta-&gt;'tags') AS t(tag);\n-- \ud55c \uc0c1\ud488\uc758 \ud0dc\uadf8 N \uac1c\ub97c N \ud589\uc73c\ub85c \ud480\uc5b4\uc90c<\/code><\/pre>\n\n<h2>jsonb \uc758 \ud568\uc815 4\uac00\uc9c0<\/h2>\n\n<div class=\"warnbox\">\n  <p><strong>1. \uc790\uc8fc \uac80\uc0c9\ud558\ub294 \ud544\ub4dc\ub294 \uc815\uc2dd \uceec\ub7fc\uc73c\ub85c.<\/strong> &#8220;\uc9c0\ub09c 1\ub144 \uac80\uc0c9 \ud1b5\uacc4&#8221; \uac19\uc740 \ud575\uc2ec \ub370\uc774\ud130\ub97c jsonb \uc5d0 \ubc15\uc73c\uba74 \ub450\uace0\ub450\uace0 \ud6c4\ud68c\ud569\ub2c8\ub2e4. \uc815\uaddc \uceec\ub7fc\uc774 \uc815\ub82c\u00b7\uc778\ub371\uc2a4\u00b7\uc81c\uc57d \ubaa8\ub450\uc5d0 \uc720\ub9ac.<\/p>\n  <p><strong>2. \ud0c0\uc785 \uc548\uc804\uc131 \uc5c6\uc74c.<\/strong> \uc5b4\ub5a4 \ud0a4\uac00 \uc5b4\ub5a4 \ud0c0\uc785\uc778\uc9c0 DB \uac00 \ubaa8\ub984. \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c zod \uac19\uc740 \ub3c4\uad6c\ub85c \uac80\uc99d \ud544\uc694.<\/p>\n  <p><strong>3. \ubd80\ubd84 \uc5c5\ub370\uc774\ud2b8 \uc131\ub2a5.<\/strong> jsonb_set \uc740 \uc804\uccb4 jsonb \ub97c \ub2e4\uc2dc \uc501\ub2c8\ub2e4(MVCC \uc0c8 \ubc84\uc804). \ud070 jsonb \uc758 \uc791\uc740 \ud544\ub4dc \uc790\uc8fc \ubc14\uafb8\uba74 \ubd80\ud558 \ud07c.<\/p>\n  <p><strong>4. \uc778\ub371\uc2a4 \ud06c\uae30 \ud3ed\ubc1c.<\/strong> \ubb34\ubd84\ubcc4\ud55c GIN \uc778\ub371\uc2a4\ub294 DB \ud06c\uae30\ub97c \ud0a4\uc6c1\ub2c8\ub2e4. \uc815\ub9d0 \uac80\uc0c9\ud558\ub294 \ud328\ud134\ub9cc \uc778\ub371\uc2f1.<\/p>\n<\/div>\n\n<h2>&#8220;\uc774 \ub370\uc774\ud130 jsonb \ub85c \uac08\uae4c \uc815\uc2dd \uceec\ub7fc\uc73c\ub85c \uac08\uae4c&#8221; \uac00\uc774\ub4dc<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th>\ud2b9\uc131<\/th><th>\uc815\uc2dd \uceec\ub7fc<\/th><th>jsonb<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\ud2b9\uc131\">\uc790\uc8fc \uac80\uc0c9\u00b7\uc815\ub82c<\/td><td data-label=\"C\">\u2705<\/td><td data-label=\"J\">\uc560\ub9e4<\/td><\/tr>\n    <tr><td data-label=\"\ud2b9\uc131\">JOIN\/FK \uac00\ub2a5<\/td><td data-label=\"C\">\u2705<\/td><td data-label=\"J\">\u274c<\/td><\/tr>\n    <tr><td data-label=\"\ud2b9\uc131\">DB \ub808\ubca8 \uc81c\uc57d (NOT NULL\/CHECK)<\/td><td data-label=\"C\">\u2705<\/td><td data-label=\"J\">\uc81c\ud55c\uc801<\/td><\/tr>\n    <tr><td data-label=\"\ud2b9\uc131\">\uc2a4\ud0a4\ub9c8 \uc790\uc8fc \ubcc0\uacbd<\/td><td data-label=\"C\">\u274c (ALTER)<\/td><td data-label=\"J\">\u2705<\/td><\/tr>\n    <tr><td data-label=\"\ud2b9\uc131\">\ud76c\uc18c \ub370\uc774\ud130 (\ub300\ubd80\ubd84 \uc5c6\uc74c)<\/td><td data-label=\"C\">\u274c (NULL \uceec\ub7fc)<\/td><td data-label=\"J\">\u2705<\/td><\/tr>\n    <tr><td data-label=\"\ud2b9\uc131\">\uc911\ucca9 \uad6c\uc870<\/td><td data-label=\"C\">\uad00\uacc4 \ud14c\uc774\ube14<\/td><td data-label=\"J\">\uc790\uc5f0\uc2a4\ub7ec\uc6c0<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<div class=\"cta\">\n  <h3>13\ud3b8 \u2014 \ubdf0\u00b7\uba38\ud2f0\ub9ac\uc5bc\ub77c\uc774\uc988\ub4dc \ubdf0<\/h3>\n  <p>CREATE VIEW vs MATERIALIZED VIEW, REFRESH \uc640 \ud45c\ud604\uc2dd \uc778\ub371\uc2a4.<\/p>\n<\/div>\n\n<div class=\"series-nav\">\n  <strong>\ud83d\udcda PostgreSQL \ubc30\uc6b0\uae30 \uad50\uc7ac<\/strong><br>\n  \uc774\uc804: 11\ud3b8 \uc708\ub3c4\uc6b0 \ud568\uc218 \u00b7 \ud604\uc7ac: <strong>12\ud3b8 (SQL \uae30\ucd08)<\/strong> \u00b7 \ub2e4\uc74c \u2192 13\ud3b8 \ubdf0 \u00b7 \uc9c4\ud589: <strong>12\/24<\/strong>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>jsonb \uc5f0\uc0b0\uc790\u00b7jsonb_set\u00b7GIN \uc778\ub371\uc2a4. 24\ud3b8 \uad50\uc7ac 12\ud3b8.<\/p>\n","protected":false},"author":1,"featured_media":290,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/290"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}