{"id":516,"date":"2026-05-17T07:04:35","date_gmt":"2026-05-16T23:04:35","guid":{"rendered":"https:\/\/junai.ai\/blog\/pg-triggers-19\/"},"modified":"2026-05-17T07:04:35","modified_gmt":"2026-05-16T23:04:35","slug":"pg-triggers-19","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/pg-triggers-19\/","title":{"rendered":"\ud2b8\ub9ac\uac70 \u2014 BEFORE\u00b7AFTER\u00b7ROW (\uc911\uae09 19\ud3b8)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 316 -->\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 19\ud3b8 \/ 24\ud3b8<\/span>\n  <h1>\ud2b8\ub9ac\uac70 \u2014 BEFORE\u00b7AFTER\u00b7ROW\u00b7STATEMENT<\/h1>\n  <p class=\"sub\">\uc790\ub3d9\uc73c\ub85c \uc2e4\ud589\ub418\ub294 \ud568\uc218. \uac15\ub825\ud558\uc9c0\ub9cc \uc2e0\uc911\ud558\uac8c.<\/p>\n  <div class=\"meta\"><span>\uc911\uae09<\/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-90.jpg\" alt=\"INSERT\/UPDATE \ub9c8\ub2e4 \ud2b8\ub9ac\uac70 \ud568\uc218\uac00 \uc790\ub3d9 \uc2e4\ud589\ub418\ub294 \ud750\ub984 \ub3c4\uc2dd\">\n<\/header>\n\n<div class=\"container\">\n<article>\n\n<p>\ud2b8\ub9ac\uac70\ub294 INSERT\u00b7UPDATE\u00b7DELETE \ub9c8\ub2e4 \uc790\ub3d9\uc73c\ub85c \ud568\uc218\ub97c \uc2e4\ud589. 18\ud3b8\uc758 \ud2b8\ub9ac\uac70 \ud568\uc218\ub97c \ubcf8\uaca9\uc801\uc73c\ub85c \ub2e4\ub8f9\ub2c8\ub2e4. <code>updated_at<\/code> \uc790\ub3d9 \uac31\uc2e0\u00b7audit \ub85c\uadf8\u00b7\uac80\uc99d \u2014 \uc798 \uc4f0\uba74 \uac15\ub825\ud558\uc9c0\ub9cc \ub0a8\uc6a9\ud558\uba74 \ub514\ubc84\uae45 \uc9c0\uc625. 19\ud3b8\uc740 \ud2b8\ub9ac\uac70\uc758 \ubaa8\ub4e0 \uc885\ub958\uc640 \ud754\ud55c \uc548\ud2f0\ud328\ud134.<\/p>\n\n<h2>\ud2b8\ub9ac\uac70\uc758 4\uac00\uc9c0 \ucd95<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th>\ucd95<\/th><th>\uc635\uc158<\/th><th>\ucc28\uc774<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\">\uc2dc\uc810<\/td><td data-label=\"\">BEFORE \/ AFTER \/ INSTEAD OF<\/td><td data-label=\"\">\ubcc0\uacbd \uc804 \/ \ud6c4 \/ \ubdf0\uc5d0\uc11c<\/td><\/tr>\n    <tr><td data-label=\"\">\uc774\ubca4\ud2b8<\/td><td data-label=\"\">INSERT \/ UPDATE \/ DELETE \/ TRUNCATE<\/td><td data-label=\"\">\uc5b4\ub5a4 \ub3d9\uc791\uc5d0<\/td><\/tr>\n    <tr><td data-label=\"\">\ub808\ubca8<\/td><td data-label=\"\">FOR EACH ROW \/ STATEMENT<\/td><td data-label=\"\">\ud589\ub9c8\ub2e4 \/ \uba85\ub839\ub2f9 \ud55c \ubc88<\/td><\/tr>\n    <tr><td data-label=\"\">\uc870\uac74<\/td><td data-label=\"\">WHEN (\uc870\uac74)<\/td><td data-label=\"\">\ucda9\uc871\ud558\uba74\ub9cc<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<h2>updated_at \uc790\ub3d9 \uac31\uc2e0 \u2014 \uac00\uc7a5 \uc790\uc8fc \uc4f0\ub294 \ud328\ud134<\/h2>\n\n<pre><code>-- 1) \ud2b8\ub9ac\uac70 \ud568\uc218\nCREATE OR REPLACE FUNCTION set_updated_at()\nRETURNS trigger\nLANGUAGE plpgsql\nAS $$\nBEGIN\n  NEW.updated_at = NOW();\n  RETURN NEW;\nEND;\n$$;\n\n-- 2) \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0 \uac19\uc740 \ud2b8\ub9ac\uac70\nCREATE TRIGGER trg_users_upd\nBEFORE UPDATE ON users\nFOR EACH ROW\nEXECUTE FUNCTION set_updated_at();\n\nCREATE TRIGGER trg_posts_upd\nBEFORE UPDATE ON posts\nFOR EACH ROW\nEXECUTE FUNCTION set_updated_at();<\/code><\/pre>\n\n<h2>NEW \u00b7 OLD \u2014 \ubcc0\uacbd \uc804\/\ud6c4 \ud589<\/h2>\n\n<pre><code>CREATE OR REPLACE FUNCTION validate_change()\nRETURNS trigger\nLANGUAGE plpgsql\nAS $$\nBEGIN\n  -- TG_OP : 'INSERT', 'UPDATE', 'DELETE'\n  IF TG_OP = 'UPDATE' THEN\n    -- NEW.col : \ubcc0\uacbd \ud6c4 \uac12\n    -- OLD.col : \ubcc0\uacbd \uc804 \uac12\n    IF NEW.email != OLD.email THEN\n      INSERT INTO email_changes (user_id, old, new, changed_at)\n      VALUES (OLD.id, OLD.email, NEW.email, NOW());\n    END IF;\n  END IF;\n\n  RETURN NEW;       -- BEFORE \ud2b8\ub9ac\uac70\uc5d0\uc11c NEW \uc218\uc815 \uac00\ub2a5\n                    -- DELETE \uba74 OLD \ubc18\ud658\nEND;\n$$;<\/code><\/pre>\n\n<h2>BEFORE vs AFTER \u2014 \ud55c \uc904 \ucc28\uc774<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n  <thead>\n    <tr><th><\/th><th>BEFORE<\/th><th>AFTER<\/th><\/tr>\n  <\/thead>\n  <tbody>\n    <tr><td data-label=\"\">\uc2dc\uc810<\/td><td data-label=\"\">\ubcc0\uacbd\uc774 \uc2e4\uc81c \uc801\uc6a9\ub418\uae30 \uc804<\/td><td data-label=\"\">\uc801\uc6a9\ub41c \ub4a4<\/td><\/tr>\n    <tr><td data-label=\"\">NEW \uc218\uc815<\/td><td data-label=\"\">\uac00\ub2a5 (\ubc18\ud658\uac12\uc774 \uc2e4\uc81c \uc800\uc7a5)<\/td><td data-label=\"\">\ubd88\uac00<\/td><\/tr>\n    <tr><td data-label=\"\">\ucc28\ub2e8<\/td><td data-label=\"\">RETURN NULL \u2192 \ubcc0\uacbd \uc548 \ub428<\/td><td data-label=\"\">\ubd88\uac00<\/td><\/tr>\n    <tr><td data-label=\"\">\uc8fc \uc6a9\ub3c4<\/td><td data-label=\"\">\uc790\ub3d9 \uceec\ub7fc\u00b7\uac80\uc99d\u00b7\uc815\uaddc\ud654<\/td><td data-label=\"\">\ub85c\uadf8\u00b7\uc54c\ub9bc\u00b7\ub2e4\ub978 \ud14c\uc774\ube14 \uac31\uc2e0<\/td><\/tr>\n  <\/tbody>\n<\/table>\n<\/div>\n\n<h2>ROW vs STATEMENT<\/h2>\n\n<pre><code>-- ROW \ub808\ubca8 \u2014 \uc601\ud5a5\ubc1b\ub294 \uac01 \ud589\ub9c8\ub2e4 \uc2e4\ud589\nCREATE TRIGGER ... FOR EACH ROW EXECUTE FUNCTION fn();\n-- UPDATE \uac00 1\ub9cc \ud589 \uc601\ud5a5\uc774\uba74 fn() \ub3c4 1\ub9cc \ubc88 \uc2e4\ud589\n\n-- STATEMENT \ub808\ubca8 \u2014 \uba85\ub839 \ud55c \ubc88\uc5d0 \ud55c \ubc88\nCREATE TRIGGER ... FOR EACH STATEMENT EXECUTE FUNCTION fn();\n-- UPDATE \ud55c \ubc88\uc5d0 fn() \ub3c4 \ud55c \ubc88\n\n-- STATEMENT \uc5d0\uc11c \uc601\ud5a5\ubc1b\uc740 \ud589 \uc804\uccb4 \ubcf4\ub824\uba74 transition table (PG10+)\nCREATE TRIGGER trg_audit_batch\nAFTER UPDATE ON orders\nREFERENCING NEW TABLE AS new_rows OLD TABLE AS old_rows\nFOR EACH STATEMENT\nEXECUTE FUNCTION audit_changes();<\/code><\/pre>\n\n<div class=\"databox\">\n  <p><strong>\uc131\ub2a5 \uacb0\uc815.<\/strong> 1\ub9cc \ud589 UPDATE \uc5d0\uc11c ROW \ud2b8\ub9ac\uac70\ub294 1\ub9cc \ubc88 \ud638\ucd9c. \ud070 \ubcc0\uacbd\uc5d0 \ud2b8\ub9ac\uac70\uac00 \ud544\uc694\ud558\uba74 <strong>STATEMENT + transition table<\/strong> \uc774 \ud6e8\uc52c \ube60\ub984.<\/p>\n<\/div>\n\n<h2>WHEN \uc870\uac74 \u2014 \uc77c\ubd80\ub9cc \ubc1c\ub3d9<\/h2>\n\n<pre><code>-- balance \uac00 \uc2e4\uc81c\ub85c \ubc14\ub010 \uacbd\uc6b0\ub9cc\nCREATE TRIGGER trg_balance_change\nAFTER UPDATE OF balance ON accounts\nFOR EACH ROW\nWHEN (OLD.balance IS DISTINCT FROM NEW.balance)\nEXECUTE FUNCTION log_balance_change();\n\n-- UPDATE OF balance \u2014 balance \uceec\ub7fc\uc774 SET \uc808\uc5d0 \uc788\ub294 \uacbd\uc6b0\ub9cc<\/code><\/pre>\n\n<h2>\uc2e4\uc804 \u2014 audit \ub85c\uadf8 \ud328\ud134<\/h2>\n\n<pre><code>-- 1) audit \ud14c\uc774\ube14\nCREATE TABLE audit_log (\n  id        BIGSERIAL PRIMARY KEY,\n  table_name TEXT NOT NULL,\n  op        TEXT NOT NULL,        -- INSERT\/UPDATE\/DELETE\n  row_id    BIGINT,\n  before    JSONB,\n  after     JSONB,\n  changed_by TEXT,\n  changed_at TIMESTAMPTZ DEFAULT NOW()\n);\n\n-- 2) \ubc94\uc6a9 \ud2b8\ub9ac\uac70 \ud568\uc218\nCREATE OR REPLACE FUNCTION audit_changes()\nRETURNS trigger\nLANGUAGE plpgsql\nAS $$\nBEGIN\n  IF TG_OP = 'DELETE' THEN\n    INSERT INTO audit_log (table_name, op, row_id, before, changed_by)\n    VALUES (TG_TABLE_NAME, 'DELETE', OLD.id, row_to_json(OLD)::jsonb, current_user);\n    RETURN OLD;\n  ELSIF TG_OP = 'INSERT' THEN\n    INSERT INTO audit_log (table_name, op, row_id, after, changed_by)\n    VALUES (TG_TABLE_NAME, 'INSERT', NEW.id, row_to_json(NEW)::jsonb, current_user);\n  ELSE\n    INSERT INTO audit_log (table_name, op, row_id, before, after, changed_by)\n    VALUES (TG_TABLE_NAME, 'UPDATE', NEW.id,\n            row_to_json(OLD)::jsonb, row_to_json(NEW)::jsonb, current_user);\n  END IF;\n  RETURN NEW;\nEND;\n$$;\n\n-- 3) \ucd94\uc801 \ub300\uc0c1 \ud14c\uc774\ube14\uc5d0 \ubd99\uc774\uae30\nCREATE TRIGGER trg_users_audit\nAFTER INSERT OR UPDATE OR DELETE ON users\nFOR EACH ROW EXECUTE FUNCTION audit_changes();\n\nCREATE TRIGGER trg_orders_audit\nAFTER INSERT OR UPDATE OR DELETE ON orders\nFOR EACH ROW EXECUTE FUNCTION audit_changes();<\/code><\/pre>\n\n<h2>\ud2b8\ub9ac\uac70 \ubaa9\ub85d \ud655\uc778<\/h2>\n\n<pre><code>-- \ud14c\uc774\ube14\uc758 \ud2b8\ub9ac\uac70\n\\d+ users\n\n-- \uc804\uccb4 \uc0ac\uc6a9\uc790 \ud2b8\ub9ac\uac70\nSELECT trigger_name, event_manipulation, action_timing, action_statement\nFROM   information_schema.triggers\nWHERE  trigger_schema = 'public'\nORDER BY event_object_table, trigger_name;\n\n-- \ud2b8\ub9ac\uac70 \ube44\ud65c\uc131\ud654 (\uc2e4\ud5d8\u00b7\ubcf5\uad6c)\nALTER TABLE users DISABLE TRIGGER trg_users_audit;\nALTER TABLE users ENABLE  TRIGGER trg_users_audit;\n\n-- \ubaa8\ub450\nALTER TABLE users DISABLE TRIGGER ALL;<\/code><\/pre>\n\n<h2>\ud754\ud55c \uc548\ud2f0\ud328\ud134 5\uac00\uc9c0<\/h2>\n\n<div class=\"warnbox\">\n  <p><strong>1. &#8220;\ub9c8\ubc95&#8221;\uc73c\ub85c \ub2e4\ub978 \ud14c\uc774\ube14 \ubcc0\uacbd.<\/strong> A \ud14c\uc774\ube14 UPDATE \uac00 \ud2b8\ub9ac\uac70\ub85c B\u00b7C \ub3c4 \uc790\ub3d9 \ubcc0\uacbd. \ub514\ubc84\uae45 \uc2dc &#8220;\ub0b4\uac00 \uc548 \ub9cc\uc9c4 \ub370\uc774\ud130\uac00 \uc65c \ubc14\ub00c\uc5c8\uc9c0&#8221; \uc9c0\uc625. \uba85\uc2dc\uc801 \ud568\uc218 \ud638\ucd9c\uc774 \ucd94\uc801\ud558\uae30 \uc88b\uc74c.<\/p>\n  <p><strong>2. \ud2b8\ub9ac\uac70 \uc548\uc5d0\uc11c \uc678\ubd80 API \ud638\ucd9c.<\/strong> \ud2b8\ub9ac\uac70\ub294 \ud2b8\ub79c\uc7ad\uc158 \uc548\uc5d0\uc11c \ub3c4\ub294\ub370 HTTP \ud638\ucd9c\uc774 \ub07c\uba74 \ubaa8\ub4e0 \uac8c \uba48\ucda4. \ud050(15\ud3b8 SKIP LOCKED) \uc5d0 \ud589 INSERT \ub9cc \ud558\uace0 \uc678\ubd80\ub294 \ubcc4\ub3c4 \uc6cc\ucee4\uac00.<\/p>\n  <p><strong>3. \ubb34\uac70\uc6b4 \ub85c\uc9c1.<\/strong> \ud2b8\ub9ac\uac70\uac00 5\ucd08 \uac78\ub9ac\uba74 INSERT \ub3c4 5\ucd08. \ub85c\uc9c1\uc740 \uac00\ubccd\uac8c \ub610\ub294 \ube44\ub3d9\uae30\ub85c.<\/p>\n  <p><strong>4. \ub2e4\ub2e8\uacc4 \uce90\uc2a4\ucf00\uc774\ub4dc.<\/strong> \ud2b8\ub9ac\uac70 A \uac00 B \ub97c \uae68\uc6b0\uace0, B \uac00 C \ub97c \uae68\uc6b0\uace0&#8230; \ucd94\uc801 \ubd88\uac00\ub2a5. \ud55c \ub2e8\uacc4\uae4c\uc9c0\ub9cc.<\/p>\n  <p><strong>5. application \ub85c\uc9c1\uc744 DB \uc5d0 \ubc15\uae30.<\/strong> \ud2b8\ub9ac\uac70\ub294 \ub370\uc774\ud130 \ubb34\uacb0\uc131\u00b7audit \uac19\uc740 &#8220;DB \uac00 \ud574\uc57c \uac00\uc7a5 \uc790\uc5f0\uc2a4\ub7ec\uc6b4 \uac83&#8221; \uae4c\uc9c0. \ube44\uc988\ub2c8\uc2a4 \ub8f0\uc740 \uc571 \ub808\uc774\uc5b4.<\/p>\n<\/div>\n\n<h2>\ud2b8\ub9ac\uac70\uc758 \uc88b\uc740 \uc6a9\ub3c4 \u2014 3\uac00\uc9c0<\/h2>\n\n<ul>\n  <li><strong>\uc790\ub3d9 \uceec\ub7fc<\/strong> \u2014 updated_at, version, search_vector \uc790\ub3d9 \uac31\uc2e0.<\/li>\n  <li><strong>audit \ub85c\uadf8<\/strong> \u2014 \ub204\uac00\u00b7\uc5b8\uc81c\u00b7\ubb58 \ubc14\uafe8\ub098 \ucd94\uc801.<\/li>\n  <li><strong>\uc81c\uc57d\u00b7\uac80\uc99d<\/strong> \u2014 CHECK \ub85c \ud45c\ud604 \ubabb\ud558\ub294 \ubcf5\uc7a1\ud55c \uac80\uc99d (\ub2e4\ub978 \ud14c\uc774\ube14 \ucc38\uc870 \ub4f1).<\/li>\n<\/ul>\n\n<div class=\"cta\">\n  <h3>20\ud3b8 \u2014 \ubc31\uc5c5\uacfc \ubcf5\uad6c (\uace0\uae09 \uc2dc\uc791)<\/h3>\n  <p>pg_dump\u00b7pg_basebackup\u00b7PITR \u2014 \ub370\uc774\ud130\ub97c \uc783\uc9c0 \uc54a\ub294 \ud45c\uc900.<\/p>\n<\/div>\n\n<div class=\"series-nav\">\n  <strong>\ud83d\udcda PostgreSQL \ubc30\uc6b0\uae30 \uad50\uc7ac<\/strong><br>\n  \uc774\uc804: 18\ud3b8 \ud568\uc218 \u00b7 \ud604\uc7ac: <strong>19\ud3b8 (\uc911\uae09 \ub9c8\uc9c0\ub9c9)<\/strong> \u00b7 \ub2e4\uc74c \u2192 20\ud3b8 \ubc31\uc5c5\/\ubcf5\uad6c (\uace0\uae09 \uc2dc\uc791) \u00b7 \uc9c4\ud589: <strong>19\/24<\/strong>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\ud2b8\ub9ac\uac70 BEFORE\/AFTER\u00b7ROW\/STATEMENT\u00b7audit. 24\ud3b8 \uad50\uc7ac 19\ud3b8.<\/p>\n","protected":false},"author":1,"featured_media":316,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-516","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\/516","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=516"}],"version-history":[{"count":0,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/516\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/316"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}