{"id":6756,"date":"2026-07-12T02:06:52","date_gmt":"2026-07-12T10:06:52","guid":{"rendered":"https:\/\/www.gudusoft.com\/postgresql-data-lineage\/"},"modified":"2026-07-12T02:06:52","modified_gmt":"2026-07-12T10:06:52","slug":"postgresql-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/ko\/%ed%8f%ac%ec%8a%a4%ed%8a%b8%ea%b7%b8%eb%a0%88%ec%8a%a4-sql-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b3%84%eb%b3%b4\/","title":{"rendered":"PostgreSQL \ub370\uc774\ud130 \uacc4\ubcf4: \ubdf0 \ubc0f SQL\uc744 \uc0ac\uc6a9\ud55c \uc5f4 \uc218\uc900 \uacc4\ubcf4"},"content":{"rendered":"

PostgreSQL \ub370\uc774\ud130 \uacc4\ubcf4<\/strong> PostgreSQL \ubdf0, CTE \ubc0f DML\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uac00 \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc744 \uceec\ub7fc \uc218\uc900\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \ub9f5\uc785\ub2c8\ub2e4. \uc989, \uc5b4\ub5a4 \uae30\ubcf8 \ud14c\uc774\ube14 \uceec\ub7fc\uc774 \uac01 \ubdf0 \ub610\ub294 \ubcf4\uace0\uc11c \uceec\ub7fc\uc5d0 \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud558\uace0, \uc5b4\ub5a4 \uc870\uc778, \ud544\ud130, \ud615\ubcc0\ud658 \ubc0f \uc9d1\uacc4\uac00 \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294\uc9c0 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. PostgreSQL \uce74\ud0c8\ub85c\uadf8 \uc790\uccb4\uc5d0\uc11c\ub3c4 \uac1d\uccb4\ub4e4\uc774 \uc11c\ub85c \uc758\uc874\ud55c\ub2e4\ub294 \uac83\uc744 \uc54c\ub824\uc90d\ub2c8\ub2e4. pg_depend<\/code> \ubdf0\uac00 \ud14c\uc774\ube14\uc744 \ucc38\uc870\ud55c\ub2e4\ub294 \uae30\ub85d\uc740 \uc788\uc9c0\ub9cc, \uc5f4\uc774 \uc5b4\ub5bb\uac8c \ubcc0\ud658\ub418\ub294\uc9c0\uc5d0 \ub300\ud55c \uc815\ubcf4\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc9c4\uc815\ud55c \uacc4\ubcf4\ub97c \uad6c\ucd95\ud558\ub824\uba74 SQL \uc790\uccb4\ub97c \ubd84\uc11d\ud574\uc57c \ud558\uba70, \ubc14\ub85c \uadf8\uac83\uc774 \uc774 \uc791\uc5c5\uc758 \ud575\uc2ec\uc785\ub2c8\ub2e4. Gudu SQLFlow<\/strong> \uc77c\ubc18\uc801\uc778 ANSI \ubb38\ubc95 \ub300\uc2e0 PostgreSQL \ubc29\uc5b8 \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\n\n

30\ucd08 \uc548\uc5d0 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694:<\/strong> PostgreSQL \ucffc\ub9ac \ub610\ub294 \ubdf0 \uc815\uc758\ub97c \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694. \ubb34\ub8cc SQLFlow \uacc4\ubcf4 \uc2dc\uac01\ud654 \ub3c4\uad6c<\/a> \uc5f4 \uc218\uc900\uc758 \uc0c1\ud638 \uc791\uc6a9 \uac00\ub2a5\ud55c \uacc4\ubcf4\ub3c4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \ubc84\uc804\uc740 \ubb34\ub8cc \ud2f0\uc5b4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n<\/div><\/div>\n\n\n\n

pg_depend\uac00 \uacc4\ubcf4 \uad00\ub828 \uc9c8\ubb38\uc5d0 \ub2f5\ud560 \uc218 \uc5c6\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n\n\n\n

PostgreSQL\uc740 \uc138\ubd80\uc801\uc778 \uc885\uc18d\uc131 \uae30\ub85d\uc744 \uc720\uc9c0\ud569\ub2c8\ub2e4. pg_depend<\/code> \uadf8\ub9ac\uace0 pg_rewrite<\/code> \uadf8\uac83\uc744 \uc54c\uace0 \uc788\ub2e4 v_\uc9c0\uc5ed_\uc218\uc775<\/code> \ucc38\uc870\ud558\ub294 \ub3d9\uc548\uc5d0\ub294 \uc0ad\uc81c\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. v_orders_enriched<\/code>, \uadf8\ub9ac\uace0 \uc815\ubcf4 \uc2a4\ud0a4\ub9c8<\/code> \ubdf0\ub294 \ud574\ub2f9 \ubdf0\uac00 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc5d0 \uc811\uadfc\ud558\ub294\uc9c0 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc774\ub294 \uac1d\uccb4 \uc218\uc900\uc758 \uc885\uc18d\uc131 \ucd94\uc801 \uae30\ub2a5\uc73c\ub85c, \ub2e4\uc74c\uacfc \uac19\uc740 \ubaa9\uc801\uc73c\ub85c \uac1c\ubc1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub4dc\ub86d... \uce90\uc2a4\ucf00\uc774\ub4dc<\/code> \ud608\ud1b5\uc774 \uc544\ub2cc \uc548\uc804.<\/p>\n\n\n\n

\uce74\ud0c8\ub85c\uadf8\uc5d0\uc11c \uc54c \uc218 \uc5c6\ub294 \uac83: \uc5b4\ub5a4 \ud2b9\uc815 \uc5f4\uc774 \uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \uacf5\uae09\ub418\ub294\uc9c0 \uc218\uc775<\/code>, \uc774\ub4e0 \uc591<\/code> \ub3c4\uc911\uc5d0 \uc8fc\uc870\ub418\uc5c8\uac70\ub098 \uc9d1\ud569\ub418\uc5c8\ub294\uc9c0 \uc5ec\ubd80 \uc0c1\ud0dc<\/code> \uacb0\uacfc\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc73c\uba74\uc11c \uacb0\uacfc\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uacfc \ubdf0\uac00 3~4\ub2e8\uacc4 \uae4a\uc774\ub85c \uc313\uc77c \ub54c \uc804\uccb4 \uacbd\ub85c\uac00 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4. "\uc774 \uc22b\uc790\ub294 \uc5b4\ub514\uc5d0\uc11c \uc628 \uac83\uc778\uac00?" \ub610\ub294 "\uc774 \uc5f4\uc744 \uc0ad\uc81c\ud558\uba74 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294\uac00?"\uc640 \uac19\uc740 \uc9c8\ubb38\uc5d0 \ub2f5\ud558\ub824\uba74 \ubdf0 \uc815\uc758\uc5d0 \uc800\uc7a5\ub41c SQL \ud14d\uc2a4\ud2b8\uc5d0\uc11c \ubcc0\ud658 \ub85c\uc9c1\uc744 \uc7ac\uad6c\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub294 \uce74\ud0c8\ub85c\uadf8 \ucffc\ub9ac\uac00 \uc544\ub2c8\ub77c \uad6c\ubb38 \ubd84\uc11d \ubb38\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

SQLFlow\ub294 PostgreSQL \ub370\uc774\ud130 \uacc4\ubcf4\ub97c \uc5b4\ub5bb\uac8c \uad6c\ucd95\ud560\uae4c\uc694?<\/h2>\n\n\n\n
  1. SQL\uc744 \uc218\uc9d1\ud569\ub2c8\ub2e4.<\/strong> \ucffc\ub9ac\ub97c \ubd99\uc5ec\ub123\uace0, \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uace0, JDBC\ub97c \ud1b5\ud574 PostgreSQL\uc5d0 \uc5f0\uacb0\ud558\uc5ec DDL\uacfc \ubdf0 \uc815\uc758\ub97c \uc9c1\uc811 \uac00\uc838\uc624\uac70\ub098, dbt-on-Postgres \ud504\ub85c\uc81d\ud2b8\ub97c \uc704\ud574 dbt \ub9e4\ub2c8\ud398\uc2a4\ud2b8\ub97c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  2. PostgreSQL \uc804\uc6a9 \ubb38\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \uad6c\ubb38 \ubd84\uc11d\ud569\ub2c8\ub2e4.<\/strong> SQLFlow\ub294 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \uad6c\ucd95\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc77c\ubc18 SQL \ud30c\uc11c(GSP)<\/a>, a commercial SQL compiler front-end developed since the mid-2000s and validated against roughly 13,600 per-dialect test fixtures. Its PostgreSQL parser handles the dialect’s own constructs \u2014 writable CTEs, \ucda9\ub3cc \uc2dc \uc0bd\uc785...<\/code>, \uadf8 ::<\/code> \ud615\ubcc0\ud658 \uc5f0\uc0b0\uc790, \uc0c1\uc18d \ubc0f \ud30c\ud2f0\uc154\ub2dd DDL \u2014 \uadf8\ub9ac\uace0 \uadf8 \uc758\ubbf8\ub860\uc801 \ud574\uc11d\uae30\uac00 \ud655\uc7a5\ub429\ub2c8\ub2e4 \uc120\ud0dd\ud558\ub2e4 *<\/code>\uc774 \uae30\ub2a5\uc740 CTE, \ud558\uc704 \ucffc\ub9ac \ubc0f \ubdf0 \uc815\uc758\ub97c \ud1b5\ud574 \uc5f4 \ucc38\uc870\ub97c \ud574\uacb0\ud55c \ub2e4\uc74c \uc5f4 \ub2e8\uc704\ub85c \uc18c\uc2a4-\ub300\uc0c1 \uad00\uacc4\ub97c \ucd94\ucd9c\ud569\ub2c8\ub2e4.<\/li>\n
  3. \uc2dc\uac01\ud654\ud558\uace0 \ub0b4\ubcf4\ub0b4\uae30.<\/strong> \ucd9c\ub825 \uacb0\uacfc\ub294 \ubaa8\ub4e0 \uc5f4\uc5d0\uc11c \uc0c1\uc704 \ubc0f \ud558\uc704 \uacbd\ub85c\ub97c \ucd94\uc801\ud560 \uc218 \uc788\ub294 \ub300\ud654\ud615 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc774\uba70, JSON, CSV \ub610\ub294 PNG \ud615\uc2dd\uc73c\ub85c \ub0b4\ubcf4\ub0b4\uac70\ub098 REST API\ub97c \ud1b5\ud574 \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ol>\n\n\n\n

    PostgreSQL\uc740 SQLFlow\uc5d0\uc11c \ud30c\uc11c\ub97c \uc81c\uacf5\ud558\ub294 39\uac1c \ubc29\uc5b8 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 Greenplum, Amazon Redshift, EDB Postgres\uc640 \uac19\uc740 Postgres \uacc4\uc5f4 \uc5d4\uc9c4\uc774 \ud3ec\ud568\ub418\uba70, \uac01 \uc5d4\uc9c4\uc740 \ud575\uc2ec PostgreSQL\uacfc \uacc4\ubcf4 \uc5d4\uc9c4\uc5d0 \uc911\uc694\ud55c \ubc29\uc2dd\uc73c\ub85c \ucc28\uc774\uac00 \uc788\uae30 \ub54c\ubb38\uc5d0 \uac01\uac01 \uace0\uc720\ud55c \ud30c\uc11c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc804\uccb4 \ubc29\ubc95\ub860\uc740 \ub2e4\uc74c\uc5d0\uc11c \ub2e4\ub8f9\ub2c8\ub2e4. SQL \ub370\uc774\ud130 \uacc4\ubcf4 \ub3c4\uad6c \uac1c\uc694<\/a>.<\/p>\n\n\n\n

    \uc911\ucca9\ub41c \ubdf0 \uccb4\uc778\uc744 \uae30\ubcf8 \ud14c\uc774\ube14\uae4c\uc9c0 \ucd94\uc801\ud558\uae30<\/h2>\n\n\n\n

    PostgreSQL\uc5d0\uc11c \ub85c\uc9c1\uc774 \ub204\uc801\ub418\ub294 \uae30\ubcf8 \ubc29\uc2dd\uc740 \ubdf0-\uc628-\ubdf0 \uc2a4\ud0dd\uc774\uba70, \uc218\ub3d9 \uacc4\ubcf4 \ucd94\uc801\uc774 \ud55c\uacc4\uc5d0 \ub3c4\ub2ec\ud558\ub294 \uc9c0\uc810\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4. 2\ub2e8\uacc4 \uccb4\uc778\uc744 \uc608\ub85c \ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

    CREATE VIEW v_orders_enriched AS SELECT o.order_id, o.customer_id, o.amount::numeric(12,2) AS amount, c.region FROM orders o JOIN customers c ON c.customer_id = o.customer_id WHERE o.status = 'shipped'; CREATE VIEW v_region_revenue AS SELECT region, SUM(amount) AS revenue FROM v_orders_enriched GROUP BY region;<\/code><\/pre>\n\n\n\n
    SQLFlow\uc5d0 \ubb38\uc758\ud558\uc138\uc694 v_\uc9c0\uc5ed_\uc218\uc775.\uc218\uc775<\/code> \ub2e4\uc74c\uc5d0\uc11c \uc720\ub798\ud558\uba70 \uc804\uccb4 \uccb4\uc778\uc744 \ud574\uacb0\ud569\ub2c8\ub2e4. \uc218\uc775<\/code> ~\uc774\ub2e4 \ud569\uc9d1\ud569()<\/code> ~ \uc704\uc5d0 v_orders_enriched.amount<\/code>\uc774\uac83\uc740 \uc22b\uc790(12,2)<\/code> \ucd9c\uc5f0\uc9c4 \uc8fc\ubb38 \uae08\uc561<\/code>\uc774 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \uae30\ubcf8 \ud14c\uc774\ube14, \uc911\uac04 \ubcf4\uae30, \uc9d1\uacc4 \ub4f1 \uac01 \ub2e8\uacc4\ub97c \ud3c9\uba74\uc801\uc778 \ucd94\uce21\uc774 \uc544\ub2cc, \uc790\uc138\ud788 \uc0b4\ud3b4\ubcfc \uc218 \uc788\ub294 \uacbd\ub85c\ub85c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ub610\ud55c, \ub2e8\uc21c\ud55c \ud574\uc11d\uc73c\ub85c\ub294 \ub193\uce60 \uc218 \uc788\ub294 \ubd80\ubd84\uc744 \uba85\ud655\ud788 \ub4dc\ub7ec\ub0c5\ub2c8\ub2e4. \uc8fc\ubb38 \uc0c1\ud0dc<\/code> \ucd9c\ub825 \uacb0\uacfc\uc5d0\ub294 \uc804\ud600 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc9c0\ub9cc \ubaa8\ub4e0 \uc218\uc775 \uc218\uce58\ub294 \uc774\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. o.status\uac00 'shipped'\uc778 \uacbd\uc6b0<\/code> \ud544\ud130. SQLFlow\ub294 \uc774\ub97c \uac04\uc811 \uacc4\ubcf4\ub85c \uae30\ub85d\ud569\ub2c8\ub2e4(\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc544\ub798 \ucc38\uc870).<\/p>\n\n\n\n
    \uc5b4\ub5a4 \uae4a\uc774\uc5d0\uc11c\ub3c4 \ub3d9\uc77c\ud55c \ud574\uc0c1\ub3c4\uac00 \uc801\uc6a9\ub429\ub2c8\ub2e4. \ubdf0\uac00 5\ub2e8\uacc4 \uae4a\uc774\ub85c \uc313\uc774\uace0 \uadf8\uc911 \uc808\ubc18\uc774 \uc774 \ud574\uc0c1\ub3c4\ub97c \uc0ac\uc6a9\ud558\ub294 \uc2e4\uc81c \uc2a4\ud0a4\ub9c8\uc5d0\uc11c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4. \uc120\ud0dd\ud558\ub2e4 *<\/code>SQLFlow\ub294 JDBC\ub97c \ud1b5\ud574 \uac00\uc838\uc628 \uc2e4\uc81c \ud14c\uc774\ube14 \uc815\uc758\ub97c \uae30\uc900\uc73c\ub85c \ubcc4\ud45c\ub97c \ud655\uc7a5\ud558\ubbc0\ub85c SQL \ud14d\uc2a4\ud2b8\uc5d0 \uc5f4 \uc774\ub984\uc774 \uc5c6\ub354\ub77c\ub3c4 \uc5f4\ubcc4 \uc815\ud655\ud55c \uacc4\ubcf4\ub97c \uc720\uc9c0\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc77c\ubc18 \ud30c\uc11c\ub97c \ubb34\ub825\ud654\uc2dc\ud0a4\ub294 PostgreSQL \uad6c\ubb38<\/h2>\n\n\n\n
    PostgreSQL\uc744 "\ub300\ub7b5 ANSI SQL"\ub85c \ucde8\uae09\ud558\ub294 \ub3c4\uad6c\ub294 \ub370\uc774\ud130 \ud750\ub984\uc774 \uac00\uc7a5 \ub9ce\uc740 \uad6c\ubb38\uc5d0\uc11c \uc815\ud655\ud788 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uad6c\ubb38\uc740 \ubaa8\ub450 SQLFlow\uc758 PostgreSQL \ubc29\uc5b8 \ud30c\uc11c\uc5d0\uc11c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n
    \n
    \uac74\uc124\ud558\ub2e4<\/th>\ud608\ud1b5\uc5d0 \uc911\uc694\ud55c \uc774\uc720<\/th><\/tr><\/thead>
    \uc4f0\uae30 \uac00\ub2a5\ud55c CTE(... \uc0bd\uc785\/\uc5c5\ub370\uc774\ud2b8\/\uc0ad\uc81c ... \ubc18\ud658<\/code>)<\/td>\ub2e8\uc77c \uba85\ub839\ubb38\uc73c\ub85c \uc77d\uae30\uc640 \uc4f0\uae30 \uc791\uc5c5\uc744 \ubaa8\ub450 \uc218\ud589\ud569\ub2c8\ub2e4. CTE\uc758 DML \ucd9c\ub825\uc740 \uc678\ubd80 \ucffc\ub9ac\uc5d0 \uc804\ub2ec\ub429\ub2c8\ub2e4. \ub370\uc774\ud130 \uacc4\ubcf4\ub294 \uc218\uc815\ub41c \ud14c\uc774\ube14\uacfc \uc5f0\uacb0\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub3cc\uc544\uc624\ub294 \uc911<\/code> \uc5ec\ub7ec \uc5f4\ub85c \ud45c\uc2dc\ud558\uace0 \ucd5c\uc885 \ubaa9\ud45c\ub97c \ud558\ub098\uc758 \uadf8\ub798\ud504\ub85c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr>\n
    \ucda9\ub3cc \ubc1c\uc0dd \uc2dc \uc5c5\ub370\uc774\ud2b8... \uc0bd\uc785<\/code><\/td>\uc5c5\uc11c\ud2b8(Upsert)\ub294 \ub370\uc774\ud130\ub97c \ub450 \uacbd\ub85c, \uc989 \uc0bd\uc785 \uacbd\ub85c\uc640 \uc5c5\ub370\uc774\ud2b8 \uacbd\ub85c\ub97c \ud1b5\ud574 \uc804\ub2ec\ud569\ub2c8\ub2e4. \uc81c\uc678\ub41c<\/code> \uac00\uc0c1 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4. \ub458 \ub2e4 \ub300\uc0c1 \ud14c\uc774\ube14\ub85c\uc758 \uc2e4\uc81c \uc5f4 \ud750\ub984\uc785\ub2c8\ub2e4.<\/td><\/tr>\n
    \ud14c\uc774\ube14 \uc0c1\uc18d \ubc0f \uc120\uc5b8\uc801 \ud30c\ud2f0\uc154\ub2dd<\/td>\ubd80\ubaa8 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub294 \uc554\ubb35\uc801\uc73c\ub85c \uc790\uc2dd \ud14c\uc774\ube14\uc744 \uc77d\uc2b5\ub2c8\ub2e4. SQLFlow\ub294 \uc0c1\uc18d \ubc0f \ud30c\ud2f0\uc154\ub2dd DDL\uc744 \uad6c\ubb38 \ubd84\uc11d\ud558\uc5ec \ud30c\ud2f0\uc158\ubcc4\ub85c \ubd84\ud560\ub418\uc9c0 \uc54a\uace0 \ubd80\ubaa8 \uc218\uc900\uc5d0\uc11c \uc62c\ubc14\ub974\uac8c \uacc4\ubcf4\uac00 \uc5f0\uacb0\ub418\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/td><\/tr>\n
    \uc5f0\uacb0\ub41c CTE \ubc0f \uc911\ucca9 \ubdf0<\/td>\uceec\ub7fc \ucc38\uc870\ub294 \uc774\uc804 CTE\ub97c \ucc38\uc870\ud558\ub294 CTE\ub97c \ud3ec\ud568\ud558\uc5ec \ubaa8\ub4e0 \uc911\uac04 \uacc4\uce35\uc744 \uac70\uccd0 \ubb3c\ub9ac\uc801 \uae30\ubcf8 \ud14c\uc774\ube14\uae4c\uc9c0 \ud574\uacb0\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/td><\/tr>\n
    ::<\/code> \uce90\uc2a4\ud305 \ubc0f \ud45c\ud604 \uce7c\ub7fc<\/td>\ubaa8\ub4e0 \ucd9c\ub825 \uc5f4\uc740 \uc801\uc6a9\ub41c \ud568\uc218\uc640 \ud615\ubcc0\ud658\uc744 \ud1b5\ud574 \ud574\ub2f9 \uc18c\uc2a4\uc5d0 \ub9e4\ud551\ub418\ubbc0\ub85c, \ub2e8\uc21c\ud788 \ucd9c\ub825 \uc5f4\ubfd0\ub9cc \uc544\ub2c8\ub77c \uc18c\uc2a4 \uc5f4\uc758 \uacb0\uacfc\ub3c4 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5b4\ub514<\/em> \uc5b4\ub5a4 \uac12\uc774 \ub098\uc654\uc9c0\ub9cc \uadf8\uac83\uc5d0 \ubb34\uc2a8 \uc77c\uc774 \uc77c\uc5b4\ub0ac\ub098\uc694?<\/em>.<\/td><\/tr>\n<\/tbody><\/table><\/figure>\n\n\n\n
    \uc9c1\uc811 \ud608\ud1b5 vs. \uac04\uc811 \ud608\ud1b5: \ub193\uce60 \uc218 \uc788\ub294 \ud544\ud130 \uc5f4<\/h2>\n\n\n\n
    SQLFlow\ub294 \uad6c\ubcc4\ud569\ub2c8\ub2e4 \uc9c1\uacc4 \ud608\ud1b5<\/strong> \u2014 \ucd9c\ub825\uc73c\ub85c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc804\ub2ec\ub418\ub294 \uc5f4 \uac12 \u2014 \uc5d0\uc11c \uac04\uc811\uc801 (\uc601\ud5a5) \uacc4\ubcf4<\/strong> \u2014 \uc0ac\uc6a9\ub41c \uc5f4 \uc5b4\ub514<\/code> \uc870\ud56d, \uac00\uc785\ud558\ub2e4<\/code> \uc870\uac74 \ubc0f \uadf8\ub8f9\ud654 \uae30\uc900<\/code> \uacb0\uacfc\uc5d0 \uc9c1\uc811\uc801\uc73c\ub85c \ub3c4\ub2ec\ud558\uc9c0 \uc54a\uace0 \uacb0\uacfc\ub97c \ud615\uc131\ud558\ub294 \ud0a4\uc785\ub2c8\ub2e4. \uc704 \uc608\uc2dc\uc5d0\uc11c, \uc8fc\ubb38 \uae08\uc561<\/code> \uc9c1\uacc4 \ud608\ud1b5\uc785\ub2c8\ub2e4 \uc218\uc775<\/code>; \uc8fc\ubb38 \uc0c1\ud0dc<\/code> \uadf8\ub9ac\uace0 \ub458 \ub2e4 \uace0\uac1d ID<\/code> \uc870\uc778 \ud0a4\ub294 \uac04\uc811\uc801\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0\uc11c \uc774 \uad6c\ubd84\uc740 \ud65c\uc131\ud654\/\ube44\ud65c\uc131\ud654\ud560 \uc218 \uc788\uc73c\uba70, \uc2e4\uc81c \uacb0\uc815\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ub3c4\uba54\uc778\uc744 \ubcc0\uacbd\ud558\ub824\ub294 \uacbd\uc6b0 \uc8fc\ubb38 \uc0c1\ud0dc<\/code>\uc9c1\uc811 \uacc4\ubcf4\ub9cc \ubcf4\uc5ec\uc8fc\ub294 \ubc29\uc2dd\uc740 \uadf8 \uc5b4\ub5a4 \uac83\ub3c4 \uc758\uc874\ud558\uc9c0 \uc54a\ub294\ub2e4\uace0 \ub9d0\ud558\uc9c0\ub9cc, \uac04\uc811 \uacc4\ubcf4\ub294 \ud544\ud130\ub9c1\ub41c \ubaa8\ub4e0 \uc218\uc775 \ubcf4\uace0\uc11c\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ub300\ubd80\ubd84\uc758 \uacc4\ubcf4 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uad00\uacc4 \uc720\ud615\uc744 \uc804\ud600 \ubaa8\ub378\ub9c1\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \ub2e8\uc77c \ucffc\ub9ac\ubd80\ud130 \uc804\uccb4 PostgreSQL \ud658\uacbd\uae4c\uc9c0<\/h2>\n\n\n\n
    \ubcf5\uc7a1\ud55c \ubdf0 \uccb4\uc778 \ud558\ub098 \uc815\ub3c4\uc758 \uc791\uc5c5\uc5d0\ub294 SQLFlow Cloud \ubb34\ub8cc \ud2f0\uc5b4\uac00 \ucda9\ubd84\ud569\ub2c8\ub2e4. \ubd99\uc5ec\ub123\uae30, \ubd84\uc11d, \ub4dc\ub9b4\ub2e4\uc6b4 \uae30\ub2a5\ub9cc \uc788\uc73c\uba74 \ub418\uc8e0. \uadf8 \uc774\uc0c1\uc740 \ub2e4\ub985\ub2c8\ub2e4.<\/p>\n\n\n\n