-- Your SQL goes here CREATE TABLE CATEGORY_TREE( id SERIAL PRIMARY KEY, -- SERIAL es AUTO INCREMENT en PostgreSQL -- PRIMARY KEY ya es NOT NULL por defecto siempre parent_id INTEGER NOT NULL, child_id INTEGER NOT NULL ); INSERT INTO CATEGORY_TREE (id,parent_id,child_id) VALUES (1,1037,1773), (2,1907,2525), (3,1907,1090), (4,1907,2526), (5,1907,1087), (6,1907,1076), (7,1907,1080), (8,1907,1834), (9,1037,1907), (10,1037,2524), (11,1908,2527), (12,1908,1078), (13,1908,1079), (14,1908,2528), (15,1908,1086), (16,1908,2614), (17,1908,2596), (18,1908,2529), (19,1908,2530), (20,1908,2531), (21,1908,2532), (22,1037,1908), (23,4,1037), (24,13,196), (25,1917,190), (26,1917,191), (27,1917,192), (28,1917,529), (29,1917,193), (30,1917,1066), (31,13,1917), (32,13,1067), (33,13,194), (34,13,195), (35,13,1874), (36,13,197), (37,4,13), (38,8,532), (39,8,1125), (40,8,1126), (41,8,1128), (42,8,1129), (43,4,8), (44,10,178), (45,10,1056), (46,10,1055), (47,1774,1775), (48,1774,1776), (49,1774,1777), (50,1774,1778), (51,1774,1060), (52,10,1774), (53,10,1065), (54,10,1779), (55,10,1057), (56,10,1059), (57,10,1061), (58,10,1058), (59,10,179), (60,10,176), (61,4,10), (62,11,198), (63,11,199), (64,11,200), (65,11,1092), (66,11,1093), (67,11,1094), (68,11,540), (69,11,1097), (70,11,539), (71,11,541), (72,11,542), (73,11,201), (74,4,11), (75,12,222), (76,12,1043), (77,12,14), (78,12,221), (79,12,534), (80,12,227), (81,12,1041), (82,12,223), (83,12,225), (84,12,224), (85,12,1835), (86,12,1042), (87,12,1045), (88,12,1837), (89,12,1044), (90,12,228), (91,4,12), (92,183,1839), (93,183,1840), (94,183,1841), (95,183,1842), (96,183,1843), (97,183,1844), (98,183,1845), (99,183,1864), (100,4,183), (101,9,1070), (102,9,1071), (103,9,185), (104,9,187), (105,9,1846), (106,9,184), (107,9,525), (108,9,526), (109,9,189), (110,4,9), (111,15,1838), (112,15,1099), (113,15,203), (114,15,538), (115,15,1101), (116,15,1100), (117,15,1103), (118,15,204), (119,15,205), (120,4,15), (121,1035,1131), (122,1035,1132), (123,1035,1134), (124,4,1035), (125,28,218), (126,28,219), (127,28,1780), (128,28,220), (129,4,28), (130,29,119), (131,29,120), (132,29,229), (133,29,1781), (134,29,123), (135,29,1030), (136,29,1263), (137,29,1262), (138,29,1847), (139,29,124), (140,4,29), (141,1176,1179), (142,1176,1182), (143,1176,1178), (144,1176,1177), (145,1176,1185), (146,1176,1181), (147,1176,1184), (148,1176,1183), (149,1176,1186), (150,1614,1615), (151,1614,1616), (152,1614,1617), (153,1614,1618), (154,1176,1614), (155,1176,2084), (156,4,1176), (157,73,571), (158,73,572), (159,73,573), (160,73,578), (161,73,574), (162,73,575), (163,73,576), (164,73,577), (165,579,1440), (166,579,1441), (167,579,1442), (168,579,1443), (169,579,1444), (170,579,1445), (171,579,1446), (172,73,579), (173,73,1439), (174,73,580), (175,4,73), (176,4,1782), (177,4,18), (178,1904,4), (179,1049,2618), (180,1049,2619), (181,1049,211), (182,1049,2620), (183,1049,2621), (184,1049,213), (185,1049,2622), (186,16,1049), (187,16,2623), (188,1909,548), (189,1909,2633), (190,1909,2634), (191,1909,2635), (192,1909,2689), (193,16,1909), (194,2624,2637), (195,2624,2636), (196,2624,2638), (197,16,2624), (198,543,2687), (199,543,2688), (200,16,543), (201,16,215), (202,2630,2639), (203,2630,2640), (204,2630,2641), (205,2630,2642), (206,2630,2643), (207,2630,2644), (208,2630,2645), (209,2630,2646), (210,2630,2647), (211,2630,2648), (212,2630,2649), (213,2630,2650), (214,2630,2651), (215,2630,2652), (216,2630,2653), (217,2630,2654), (218,2630,2655), (219,16,2630), (220,16,2632), (221,1904,16), (222,19,156), (223,19,158), (224,19,157), (225,19,552), (226,19,159), (227,19,160), (228,19,161), (229,19,1784), (230,19,1848), (231,19,1493), (232,19,1849), (233,19,1850), (234,19,155), (235,1904,19), (236,21,553), (237,21,163), (238,21,165), (239,21,164), (240,21,166), (241,21,1785), (242,21,167), (243,21,162), (244,1187,21), (245,1187,22), (246,1187,20), (247,1187,26), (248,89,236), (249,89,237), (250,89,238), (251,89,239), (252,89,240), (253,1187,89), (254,1187,90), (255,88,230), (256,88,231), (257,88,232), (258,88,233), (259,88,234), (260,88,235), (261,1187,88), (262,1187,1123), (263,1187,1221), (264,1187,1851), (265,1187,1852), (266,1187,1140), (267,1904,1187), (268,146,964), (269,146,152), (270,146,948), (271,1906,1903), (272,1906,950), (273,1906,958), (274,1906,962), (275,1906,967), (276,146,1906), (277,146,1264), (278,146,960), (279,146,956), (280,146,1902), (281,146,153), (282,1904,146), (283,257,1816), (284,257,1817), (285,257,1818), (286,257,1819), (287,2050,257), (288,2051,1225), (289,2051,2533), (290,2051,1227), (291,2051,1861), (292,2051,1859), (293,2051,1230), (294,1206,2051), (295,1206,2553), (296,2052,2534), (297,2052,1223), (298,2052,1224), (299,2052,2535), (300,2052,1858), (301,2052,1226), (302,2052,2536), (303,2052,2537), (304,2052,2538), (305,2052,2539), (306,2052,2550), (307,2052,2551), (308,1206,2052), (309,1206,2552), (310,2050,1206), (311,536,1801), (312,536,1802), (313,536,1803), (314,536,1804), (315,536,1805), (316,536,1865), (317,76,536), (318,77,1806), (319,77,1807), (320,77,1808), (321,77,1809), (322,77,1810), (323,77,1868), (324,76,77), (325,76,560), (326,2050,76), (327,32,1786), (328,32,1787), (329,32,1788), (330,32,1789), (331,32,1790), (332,32,1866), (333,2050,32), (334,79,1811), (335,79,267), (336,79,1812), (337,79,266), (338,79,1813), (339,79,264), (340,79,265), (341,79,1814), (342,79,1815), (343,79,1825), (344,79,268), (345,2050,79), (346,34,1820), (347,34,1821), (348,34,259), (349,34,271), (350,34,261), (351,34,260), (352,34,263), (353,2050,34), (354,80,1822), (355,80,1823), (356,80,1824), (357,80,272), (358,2050,80), (359,85,1829), (360,85,1828), (361,85,1830), (362,85,1867), (363,2050,85), (364,2050,84), (365,30,581), (366,30,582), (367,30,583), (368,30,586), (369,30,584), (370,30,585), (371,587,1470), (372,587,1471), (373,587,1472), (374,587,1473), (375,587,1474), (376,587,1475), (377,587,1476), (378,30,587), (379,30,588), (380,2050,30), (381,2050,92), (382,2050,83), (383,5,2050), (384,1231,2656), (385,1233,2661), (386,1233,2662), (387,1233,2663), (388,1233,1795), (389,1233,2664), (390,1231,1233), (391,1231,2657), (392,2658,2665), (393,2658,2666), (394,2658,2667), (395,2658,2668), (396,1231,2658), (397,1238,2669), (398,1238,2671), (399,1238,2670), (400,1231,1238), (401,1231,2659), (402,1452,2672), (403,1452,2673), (404,1452,2674), (405,1452,2675), (406,1452,2676), (407,1452,2677), (408,1452,2678), (409,1452,2679), (410,1452,2680), (411,1452,1467), (412,1452,2681), (413,1452,2682), (414,1452,1453), (415,1452,2683), (416,1452,2684), (417,1452,2685), (418,1452,2686), (419,1231,1452), (420,1231,1242), (421,5,1231), (422,82,93), (423,94,245), (424,94,247), (425,94,246), (426,94,1797), (427,94,1798), (428,94,1799), (429,94,248), (430,94,1862), (431,94,249), (432,82,94), (433,95,241), (434,95,242), (435,95,243), (436,95,244), (437,95,1800), (438,82,95), (439,82,96), (440,82,97), (441,82,98), (442,86,287), (443,86,288), (444,86,289), (445,86,290), (446,86,291), (447,82,86), (448,87,283), (449,87,284), (450,87,285), (451,87,286), (452,82,87), (453,82,91), (454,82,99), (455,5,82), (456,139,143), (457,2055,1826), (458,2055,1827), (459,2055,971), (460,139,2055), (461,139,140), (462,139,141), (463,139,142), (464,139,145), (465,139,144), (466,139,1863), (467,139,968), (468,5,139), (469,1243,1514), (470,1243,1515), (471,1243,1516), (472,1243,1517), (473,1243,1875), (474,1195,1243), (475,1255,1525), (476,1530,2695), (477,1530,2696), (478,1530,2697), (479,1530,2698), (480,1255,1530), (481,1255,2690), (482,1526,2753), (483,1526,2701), (484,1526,2702), (485,1255,1526), (486,2691,2704), (487,2691,2705), (488,2691,2707), (489,1255,2691), (490,1255,1528), (491,1255,2692), (492,1255,1534), (493,2693,2708), (494,2693,2709), (495,2693,2710), (496,2693,2711), (497,2693,2712), (498,2693,2713), (499,2693,2714), (500,2693,2715), (501,2693,2716), (502,2693,2717), (503,1255,2693), (504,1533,2718), (505,1533,2719), (506,1533,2720), (507,1255,1533), (508,1195,1255), (509,1519,2540), (510,1519,2541), (511,1519,2542), (512,1519,2543), (513,1244,1519), (514,1244,1518), (515,1521,2544), (516,1521,2545), (517,1521,2546), (518,1521,2547), (519,1521,2548), (520,1521,2549), (521,1244,1521), (522,2554,2556), (523,2554,2557), (524,2554,2555), (525,2554,2558), (526,1244,2554), (527,2559,2560), (528,2559,2565), (529,2559,2582), (530,1244,2559), (531,1195,1244), (532,1246,1542), (533,1246,1543), (534,1246,1544), (535,1246,1548), (536,1246,1549), (537,1246,1550), (538,1246,1551), (539,1246,1877), (540,1195,1246), (541,1245,1535), (542,1245,1536), (543,1245,1537), (544,1245,1538), (545,1245,1539), (546,1245,1540), (547,1245,1541), (548,1245,1878), (549,1195,1245), (550,1247,1554), (551,1247,1553), (552,1195,1247), (553,1195,1248), (554,1249,1559), (555,1249,1560), (556,1249,1562), (557,1249,1565), (558,1249,1568), (559,1249,1250), (560,1249,2079), (561,1249,1880), (562,1195,1249), (563,1195,1258), (564,1574,1577), (565,1574,1578), (566,1574,1580), (567,1574,1581), (568,1574,1582), (569,1574,1584), (570,1574,1586), (571,1574,1881), (572,1195,1574), (573,1251,1590), (574,1251,1592), (575,1251,1593), (576,1195,1251), (577,1252,1600), (578,1252,1601), (579,1252,1602), (580,1252,1872), (581,1195,1252), (582,1594,1596), (583,1594,1597), (584,1594,1598), (585,1195,1594), (586,1195,1253), (587,1195,1510), (588,1195,1604), (589,1195,1606), (590,1195,2080), (591,1195,1254), (592,1193,1195), (593,1196,1642), (594,1196,1643), (595,1196,1644), (596,1196,1645), (597,1196,1883), (598,1194,1196), (599,1256,1653), (600,1256,2721), (601,1657,2726), (602,1657,2727), (603,1657,2728), (604,1657,2729), (605,1256,1657), (606,1256,2722), (607,2723,2730), (608,2723,2732), (609,2723,2733), (610,2723,2734), (611,1256,2723), (612,1256,1655), (613,1256,1661), (614,2724,2735), (615,2724,2737), (616,2724,2738), (617,2724,2742), (618,2724,2743), (619,2724,2744), (620,2724,2745), (621,2724,2746), (622,2724,2748), (623,2724,2749), (624,1256,2724), (625,1660,2750), (626,1660,2751), (627,1660,2752), (628,1256,1660), (629,1194,1256), (630,1647,2561), (631,1647,2562), (632,1647,2563), (633,1647,2564), (634,1197,1647), (635,1197,1646), (636,1649,2571), (637,1649,2573), (638,1649,2574), (639,1649,2575), (640,1649,2576), (641,1649,2577), (642,1197,1649), (643,2583,2604), (644,2583,2609), (645,2583,2602), (646,2583,2606), (647,1197,2583), (648,2590,2610), (649,2590,2613), (650,2590,2612), (651,1197,2590), (652,1194,1197), (653,1199,1668), (654,1199,1669), (655,1199,1670), (656,1199,1671), (657,1199,1672), (658,1199,1673), (659,1199,1887), (660,1194,1199), (661,1198,1662), (662,1198,1663), (663,1198,1664), (664,1198,1665), (665,1198,1666), (666,1198,1667), (667,1198,1886), (668,1194,1198), (669,1200,1696), (670,1200,1697), (671,1200,1698), (672,1200,1701), (673,1200,1702), (674,1200,1201), (675,1200,2082), (676,1200,1870), (677,1194,1200), (678,1194,1257), (679,1714,1749), (680,1714,1740), (681,1714,1741), (682,1714,1743), (683,1714,1745), (684,1714,1746), (685,1714,1748), (686,1194,1714), (687,1202,1750), (688,1202,1751), (689,1194,1202), (690,1203,1757), (691,1203,1758), (692,1203,1759), (693,1203,1871), (694,1194,1203), (695,1752,1754), (696,1752,1755), (697,1194,1752), (698,1194,1204), (699,1194,1760), (700,1194,1761), (701,1194,1762), (702,1194,2083), (703,1194,1205), (704,1193,1194), (705,1499,1730), (706,1499,1725), (707,1499,1731), (708,1499,1763), (709,1499,1764), (710,1499,1765), (711,1499,1766), (712,1499,1767), (713,1499,1768), (714,1499,1769), (715,1499,1770), (716,1499,1771), (717,1499,2085), (718,1499,2086), (719,1193,1499), (720,1620,1622), (721,1620,1623), (722,1620,1624), (723,1620,1625), (724,1620,1626), (725,1620,1627), (726,1500,1620), (727,1621,1628), (728,1621,1629), (729,1621,1630), (730,1621,1631), (731,1621,1633), (732,1621,1640), (733,1621,2088), (734,1500,1621), (735,1500,1674), (736,1500,1675), (737,1676,1678), (738,1676,1679), (739,1676,1680), (740,1676,2087), (741,1500,1676), (742,1681,1682), (743,1681,1683), (744,1681,1684), (745,1681,1685), (746,1681,1686), (747,1500,1681), (748,1687,1688), (749,1687,1689), (750,1500,1687), (751,1500,1690), (752,1500,1691), (753,1692,1695), (754,1692,1700), (755,1692,1703), (756,1692,1772), (757,1500,1692), (758,1193,1500), (759,1496,1512), (760,1496,1611), (761,1496,1612), (762,1496,1613), (763,1496,1511), (764,1193,1496), (765,1497,1599), (766,1497,1603), (767,1497,1595), (768,1497,1605), (769,1497,1607), (770,1497,1608), (771,1497,1609), (772,1497,1610), (773,1193,1497), (774,1495,1503), (775,1495,1504), (776,1193,1495), (777,1498,1561), (778,1498,1563), (779,1498,1566), (780,1567,1569), (781,1567,1570), (782,1567,1571), (783,1498,1567), (784,1498,1572), (785,1498,1573), (786,1498,1575), (787,1576,1579), (788,1576,1585), (789,1576,1587), (790,1576,1588), (791,1576,1589), (792,1576,1591), (793,1498,1576), (794,1193,1498), (795,1501,1508), (796,1501,1509), (797,1193,1501), (798,1193,1502), (799,1924,1942), (800,1924,1943), (801,1924,1944), (802,1924,1945), (803,1919,1924), (804,1919,1925), (805,1926,1946), (806,1926,1955), (807,1919,1926), (808,1919,1974), (809,1927,1953), (810,1927,1954), (811,1919,1927), (812,1919,1928), (813,1919,1929), (814,1930,1947), (815,1930,1948), (816,1930,1949), (817,1919,1930), (818,1918,1919), (819,1935,1957), (820,1935,1956), (821,1934,1935), (822,1936,1966), (823,1936,1967), (824,1934,1936), (825,1934,1941), (826,1934,1937), (827,1938,1969), (828,1938,1968), (829,1934,1938), (830,1939,1962), (831,1939,1963), (832,1939,2012), (833,1939,1964), (834,1939,1965), (835,1934,1939), (836,1934,1940), (837,1918,1934), (838,1931,1950), (839,1931,1951), (840,1931,1970), (841,1931,1952), (842,1920,1931), (843,1932,1958), (844,1932,1959), (845,1932,1960), (846,1932,1961), (847,1920,1932), (848,2005,2006), (849,2005,2007), (850,2005,2008), (851,2005,2009), (852,2005,2010), (853,2005,2011), (854,1920,2005), (855,1918,1920), (856,2371,2378), (857,2371,2379), (858,2371,2380), (859,2313,2371), (860,2372,2381), (861,2372,2382), (862,2372,2383), (863,2313,2372), (864,2373,2384), (865,2373,2385), (866,2373,2386), (867,2313,2373), (868,2374,2390), (869,2374,2391), (870,2374,2392), (871,2313,2374), (872,2375,2399), (873,2375,2402), (874,2375,2405), (875,2313,2375), (876,2377,2406), (877,2377,2407), (878,2377,2409), (879,2313,2377), (880,2376,2412), (881,2376,2420), (882,2376,2421), (883,2313,2376), (884,2422,2431), (885,2422,2447), (886,2422,2448), (887,2313,2422), (888,2323,2449), (889,2323,2450), (890,2323,2451), (891,2313,2323), (892,2324,2452), (893,2324,2453), (894,2324,2454), (895,2313,2324), (896,2366,2455), (897,2366,2456), (898,2366,2458), (899,2313,2366), (900,2367,2474), (901,2367,2475), (902,2367,2476), (903,2313,2367), (904,2313,2368), (905,2369,2465), (906,2369,2466), (907,2369,2469), (908,2313,2369), (909,2370,2459), (910,2370,2460), (911,2370,2461), (912,2370,2462), (913,2370,2463), (914,2370,2464), (915,2313,2370), (916,2309,2313), (917,2311,2321), (918,2311,2477), (919,2311,2322), (920,2311,2478), (921,2311,2479), (922,2311,2480), (923,2311,2481), (924,2311,2482), (925,2311,2483), (926,2309,2311), (927,2314,2328), (928,2314,2329), (929,2314,2330), (930,2314,2332), (931,2310,2314), (932,2315,2521), (933,2315,2333), (934,2315,2334), (935,2310,2315), (936,2309,2310), (937,2319,2336), (938,2319,2337), (939,2319,2338), (940,2319,2339), (941,2319,2340), (942,2319,2341), (943,2319,2342), (944,2319,2343), (945,2319,2344), (946,2312,2319), (947,2320,2345), (948,2320,2346), (949,2320,2347), (950,2320,2348), (951,2320,2349), (952,2320,2350), (953,2320,2351), (954,2320,2352), (955,2320,2353), (956,2320,2354), (957,2320,2355), (958,2320,2356), (959,2320,2357), (960,2320,2358), (961,2320,2359), (962,2320,2360), (963,2320,2361), (964,2320,2362), (965,2312,2320), (966,2318,2363), (967,2318,2364), (968,2318,2365), (969,2312,2318), (970,2309,2312), (971,2109,2512), (972,2109,2511), (973,2095,2109), (974,2112,2119), (975,2112,2484), (976,2112,2517), (977,2112,2518), (978,2112,2120), (979,2112,2121), (980,2095,2112), (981,2115,2515), (982,2115,2514), (983,2115,2513), (984,2095,2115), (985,2113,2122), (986,2113,2124), (987,2113,2123), (988,2113,2516), (989,2095,2113), (990,2488,2510), (991,2488,2509), (992,2095,2488), (993,2110,2117), (994,2110,2118), (995,2095,2110), (996,2111,2508), (997,2111,2507), (998,2095,2111), (999,2114,2506), (1000,2114,2505), (1001,2095,2114), (1002,2093,2095), (1003,2098,2099), (1004,2098,2126), (1005,2096,2098), (1006,2137,2500), (1007,2137,2501), (1008,2137,2502), (1009,2137,2503), (1010,2137,2504), (1011,2096,2137), (1012,2131,2133), (1013,2131,2134), (1014,2096,2131), (1015,2096,2097), (1016,2125,2499), (1017,2125,2498), (1018,2096,2125), (1019,2127,2128), (1020,2127,2129), (1021,2127,2130), (1022,2096,2127), (1023,2096,2489), (1024,2136,2496), (1025,2136,2497), (1026,2096,2136), (1027,2093,2096), (1028,2138,2140), (1029,2138,2142), (1030,2093,2138), (1031,2485,2491), (1032,2485,2490), (1033,2093,2485), (1034,2486,2492), (1035,2486,2493), (1036,2093,2486), (1037,2487,2494), (1038,2487,2495), (1039,2093,2487);