/usr/share/postgresql/9.6/contrib/postgis-2.3/postgis_restore.pl is in postgresql-9.6-postgis-2.3-scripts 2.3.1+dfsg-2.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761 2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 | #!/usr/bin/perl
#
# PostGIS - Spatial Types for PostgreSQL
# http://postgis.net
#
# Copyright (C) 2011 OpenGeo.org
# Copyright (C) 2009 Paul Ramsey <pramsey@cleverelephant.ca>
#
# This is free software; you can redistribute and/or modify it under
# the terms of the GNU General Public Licence. See the COPYING file.
#
#---------------------------------------------------------------------
#
# This script is aimed at restoring postgis data
# from a dumpfile produced by pg_dump -Fc
#
# Basically it will restore all but things known to belong
# to postgis. Will also convert some old known constructs
# into new ones.
#
# Tested on:
#
# pg-8.4.9/pgis-1.4.3 => pg-8.4.9/pgis-2.0.0SVN
# pg-8.4.9/pgis-2.0.0SVN => pg-8.4.9/pgis-2.0.0SVN
# pg-8.4.9/pgis-2.0.0SVN => pg-9.1.2/pgis-2.0.0SVN
# pg-9.1b3/pgis-1.5.3 => pg-9.1.1/pgis-2.0.0SVN
#
#---------------------------------------------------------------------
use warnings;
use strict;
my $me = $0;
my $usage = qq{
Usage: $me [-v] [-L TOC] [-s schema] <dumpfile>
Restore a custom dump (pg_dump -Fc) of a PostGIS-enabled database.
First dump the old database: pg_dump -Fc MYDB > MYDB.dmp
Then create a new database: createdb NEWDB
Then install PostGIS in the new database:
psql -f postgis/postgis.sql NEWDB
Also install PostGIS topology and raster, if you were using them:
psql -f topology/topology.sql NEWDB
psql -f raster/rtpostgis.sql NEWDB
Finally, pass the dump to this script and feed output to psql:
$me MYDB.dmp | psql NEWDB
The -v switch writes detailed report on stderr.
Use -L to provide a TOC rather than extracting it from the dump.
Use -s if you installed PostGIS in a custom schema.
};
my $DEBUG = 0;
my $POSTGIS_SCHEMA;
my $POSTGIS_TOC;
# NOTE: the SRID limits here are being discussed:
# http://lists.osgeo.org/pipermail/postgis-devel/2012-February/018440.html
my $SRID_MAXIMUM = 999999;
my $SRID_USER_MAXIMUM = 998999;
while (@ARGV && $ARGV[0] =~ /^-/) {
my $arg = shift(@ARGV);
if ( $arg eq '-v' ) {
$DEBUG = 1;
}
elsif ( $arg eq '-s' ) {
$POSTGIS_SCHEMA = shift(@ARGV);
}
elsif ( $arg eq '-L' ) {
$POSTGIS_TOC = shift(@ARGV);
}
elsif ( $arg eq '--' ) {
last;
}
else {
print STDERR "Unknown switch " . $arg;
die $usage;
}
}
die $usage if (@ARGV < 1);
my $dumpfile = $ARGV[0];
my $manifest = $dumpfile . ".lst";
my $hasTopology = 0;
die "$me:\tUnable to find 'pg_dump' on the path.\n" if ! `pg_dump --version`;
die "$me:\tUnable to find 'pg_restore' on the path.\n" if ! `pg_restore --version`;
die "$me:\tUnable to open dump file '$dumpfile'.\n" if ! -f $dumpfile;
print STDERR "Converting $dumpfile to ASCII on stdout...\n";
######################################################################
# Load the signatures of things to skip.
#
print STDERR " Reading list of functions to ignore...\n";
my %skip = ();
while(my $l = <DATA>) {
chop($l);
print STDERR "DATA: $l\n" if $DEBUG;
$l =~ s/\s//g;
$skip{$l} = 1;
}
######################################################################
# Write a new manifest for the dump file, skipping the things that
# are part of PostGIS
#
if(!defined($POSTGIS_TOC)) {
print STDERR " Writing manifest of things to read from dump file...\n";
open( DUMP, "pg_restore -l $dumpfile |" ) || die "$me:\tCannot open dump file '$dumpfile'\n";
} else {
open( DUMP, '<' . $POSTGIS_TOC) || die "$me:\tCannot open TOC file '$POSTGIS_TOC'\n";
}
open( MANIFEST, ">$manifest" ) || die "$me:\tCannot open manifest file '$manifest'\n";
while( my $l = <DUMP> ) {
next if $l =~ /^\;/;
my $sigHR = linesignature($l);
my $sig = $sigHR; $sig =~ s/\s//g;
$hasTopology = 1 if $sig eq 'SCHEMAtopology';
if ( $skip{$sig} ) {
print STDERR "SKIP: $sigHR\n" if $DEBUG;
next
}
print STDERR "KEEP: $sigHR\n" if $DEBUG;
print MANIFEST $l;
}
close(MANIFEST);
close(DUMP) || die "$me: pg_restore returned an error\n";
######################################################################
# Convert the dump file into an ASCII file, stripping out the
# unwanted bits.
#
print STDERR " Writing ASCII to stdout...\n";
open( INPUT, "pg_restore -L $manifest $dumpfile |") || die "$me:\tCan't run pg_restore\n";
if ( defined $POSTGIS_SCHEMA ) {
print STDOUT "SET search_path = \"" . $POSTGIS_SCHEMA . "\";\n";
}
#
# Disable topology metadata tables triggers to allow for population
# in arbitrary order.
#
if ( $hasTopology ) {
print STDOUT "ALTER TABLE topology.layer DISABLE TRIGGER ALL;\n";
}
# Drop the spatial_ref_sys_srid_check to allow for custom invalid SRIDs in the dump
print STDOUT "ALTER TABLE spatial_ref_sys DROP constraint "
. "spatial_ref_sys_srid_check;\n";
# Drop the spatial_ref_sys primary key to allow for SRID conversions
# which possibly end up taking the same spot
print STDOUT "ALTER TABLE spatial_ref_sys DROP constraint "
. "spatial_ref_sys_pkey;\n";
# Backup entries found in new spatial_ref_sys for later updating the
print STDOUT "CREATE TEMP TABLE _pgis_restore_spatial_ref_sys AS "
."SELECT * FROM spatial_ref_sys;\n";
print STDOUT "DELETE FROM spatial_ref_sys;\n";
my $inCopy;
while( my $l = <INPUT> ) {
if ( $l =~ /^COPY .+ FROM stdin;$/ ) {
$inCopy = 1;
}
elsif ( $inCopy && $l =~ /^\\\.$/ ) {
$inCopy = 0;
}
next if !$inCopy && $l =~ /^ *--/;
if ( $l =~ /^SET search_path/ ) {
$l =~ s/; *$/, public;/;
}
# This is to avoid confusing OPERATOR CLASS and OPERATOR FAMILY
# with OPERATOR below
elsif ( $l =~ /CREATE OPERATOR CLASS/ || $l =~ /CREATE OPERATOR FAMILY/ )
{
}
# We can't skip OPERATORS from the manifest file
# because it doesn't contain enough informations
# about the type the operator is for
elsif ( $l =~ /CREATE OPERATOR *([^ ,]*)/)
{
my $name = canonicalize_typename($1);
my $larg = undef;
my $rarg = undef;
my @sublines = ($l);
while( my $subline = <INPUT>)
{
push(@sublines, $subline);
last if $subline =~ /;[\t ]*$/;
if ( $subline =~ /leftarg *= *([^ ,]*)/i )
{
$larg=canonicalize_typename($1);
}
if ( $subline =~ /rightarg *= *([^ ,]*)/i )
{
$rarg=canonicalize_typename($1);
}
}
if ( ! $larg ) {
print STDERR "No larg, @sublines: [" . @sublines . "]\n";
}
my $sigHR = "OPERATOR " . $name .' ('.$larg.', '.$rarg.')';
my $sig = $sigHR; $sig =~ s/\s//g;
if ( $skip{$sig} )
{
print STDERR "SKIP: $sig\n" if $DEBUG;
next;
}
print STDERR "KEEP: $sig\n" if $DEBUG;
print STDOUT @sublines;
next;
}
# Rewrite spatial table constraints
#
# Example 1:
# CREATE TABLE geos_in (
# id integer NOT NULL,
# g public.geometry,
# CONSTRAINT enforce_dims_g CHECK ((public.st_ndims(g) = 2)),
# CONSTRAINT enforce_geotype_g CHECK (((public.geometrytype(g) = 'MULTILINESTRING'::text) OR (g IS NULL))),
# CONSTRAINT enforce_srid_g CHECK ((public.st_srid(g) = (-1)))
# );
#
# Example 2:
# CREATE TABLE boszip (
# gid integer NOT NULL,
# zip5 character(5),
# the_geom geometry,
# CONSTRAINT enforce_dims_the_geom CHECK ((ndims(the_geom) = 2)),
# CONSTRAINT enforce_geotype_the_geom CHECK (((geometrytype(the_geom) = 'MULTIPOLYGON'::text) OR (the_geom IS NULL))),
# CONSTRAINT enforce_srid_the_geom CHECK ((srid(the_geom) = 2249))
# );
#
# Example 3:
# CREATE TABLE "PIANIFICAZIONE__ELEMENTO_LINEA" (
# soft_gis_serial integer NOT NULL,
# "G" public.geometry,
# CONSTRAINT "enforce_dims_G" CHECK ((public.st_ndims("G") = 2)),
# CONSTRAINT "enforce_geotype_G" CHECK (((public.geometrytype("G") = 'MULTICURVE'::text) OR ("G" IS NULL))),
# CONSTRAINT "enforce_srid_G" CHECK ((public.st_srid("G") = (-1)))
# );
#
#
elsif ( $l =~ /CREATE TABLE *([^ ,]*)/)
{
my @sublines = ($l);
while( my $subline = <INPUT>)
{
if ( $subline =~ /CONSTRAINT "?enforce_dims_/i ) {
$subline =~ s/\bndims\(/st_ndims(/;
}
if ( $subline =~ /CONSTRAINT "?enforce_srid_/i ) {
$subline =~ s/\bsrid\(/st_srid(/;
if ( $subline =~ /=\s\(?([-0-9][0-9]*)\)/ ) {
my $oldsrid = $1;
my $newsrid = clamp_srid($oldsrid);
$subline =~ s/=\s*(\(?)[-0-9][0-9]*/= $1$newsrid/;
} else {
print STDERR "WARNING: could not find SRID value in: $subline";
}
}
push(@sublines, $subline);
last if $subline =~ /;[\t ]*$/;
}
print STDOUT @sublines;
next;
}
# Parse comments, to avoid skipping quoted comments
# See http://trac.osgeo.org/postgis/ticket/2759
elsif ( $l =~ /^COMMENT ON .* IS '(.*)/)
{
my @sublines = ($l);
my $comment = $1;
# A comment ends with an odd number of single quotes and a semicolon
while( $comment !~ /('*)[\t ]*;[\t ]*$/ || length($1) % 2 == 0)
{
$comment = <INPUT>;
push(@sublines, $comment);
}
print STDOUT @sublines;
next;
}
# Clamp SRIDS in spatial_ref_sys
elsif ( $l =~ /COPY spatial_ref_sys /)
{
print STDOUT $l;
while( my $subline = <INPUT>)
{
if ( $subline =~ /([0-9]*)\t/ ) {
my $oldsrid = $1;
my $newsrid = clamp_srid($oldsrid);
$subline =~ s/^[0-9]*\t/${newsrid}\t/;
}
print STDOUT $subline;
last if $subline =~ /^\\.$/;
}
next;
}
print STDOUT $l;
}
if ( defined $POSTGIS_SCHEMA ) {
print STDOUT "SET search_path = \"" . $POSTGIS_SCHEMA . "\";\n";
}
if ( $hasTopology ) {
# Re-enable topology.layer table triggers
print STDOUT "ALTER TABLE topology.layer ENABLE TRIGGER ALL;\n";
# Update topology SRID from geometry_columns view.
# This is mainly to fix srids of -1
# May be worth providing a "populate_topology_topology"
print STDOUT "UPDATE topology.topology t set srid = g.srid "
. "FROM geometry_columns g WHERE t.name = g.f_table_schema "
. "AND g.f_table_name = 'face' and f_geometry_column = 'mbr';\n";
}
# Update spatial_ref_sys with entries found in new table
print STDOUT "UPDATE spatial_ref_sys o set auth_name = n.auth_name, "
. "auth_srid = n.auth_srid, srtext = n.srtext, "
. "proj4text = n.proj4text FROM "
. "_pgis_restore_spatial_ref_sys n WHERE o.srid = n.srid;\n";
# Insert entries only found in new table
print STDOUT "INSERT INTO spatial_ref_sys SELECT * FROM "
. "_pgis_restore_spatial_ref_sys n WHERE n.srid "
. "NOT IN ( SELECT srid FROM spatial_ref_sys );\n";
# DROP TABLE _pgis_restore_spatial_ref_sys;
print STDOUT "DROP TABLE _pgis_restore_spatial_ref_sys;\n";
# Try re-enforcing spatial_ref_sys_srid_check, would fail if impossible
# but you'd still have your data
print STDOUT "ALTER TABLE spatial_ref_sys ADD constraint "
. "spatial_ref_sys_srid_check check "
. "( srid > 0 and srid < " . ($SRID_USER_MAXIMUM+1) ." ) ;\n";
# Try re-enforcing spatial_ref_sys primary key, would fail if impossible
# but you'd still have your data
print STDOUT "ALTER TABLE spatial_ref_sys ENABLE TRIGGER ALL;\n";
print STDOUT "ALTER TABLE spatial_ref_sys ADD PRIMARY KEY(srid);\n";
print STDERR "Done.\n";
######################################################################
# Strip a dump file manifest line down to the unique elements of
# type and signature.
#
sub linesignature {
my $line = shift;
my $sig;
$line =~ s/\n$//;
$line =~ s/\r$//;
$line =~ s/OPERATOR CLASS/OPERATORCLASS/;
$line =~ s/TABLE DATA/TABLEDATA/;
$line =~ s/SHELL TYPE/SHELLTYPE/;
$line =~ s/PROCEDURAL LANGUAGE/PROCEDURALLANGUAGE/;
if( $line =~ /^(\d+)\; (\d+) (\d+) FK (\w+) (\w+) (.*) (\w*)/ ) {
$sig = "FK " . $4 . " " . $6;
}
elsif( $line =~ /^(\d+)\; (\d+) (\d+) (\w+) (\w+) (.*) (\w*)/ ) {
$sig = $4 . " " . $6;
}
elsif( $line =~ /PROCEDURALLANGUAGE.*plpgsql/ ) {
$sig = "PROCEDURAL LANGUAGE plpgsql";
}
elsif ( $line =~ /SCHEMA - (\w+)/ ) {
$sig = "SCHEMA $1";
}
elsif ( $line =~ /SEQUENCE - (\w+)/ ) {
$sig = "SEQUENCE $1";
}
else {
# TODO: something smarter here...
$sig = $line
}
return $sig;
}
#
# Canonicalize type names (they change between dump versions).
# Here we also strip schema qualification
#
sub
canonicalize_typename
{
my $arg=shift;
# Lower case
$arg = lc($arg);
# Trim whitespaces
$arg =~ s/^\s*//;
$arg =~ s/\s*$//;
# Strip schema qualification
#$arg =~ s/^public.//;
$arg =~ s/^.*\.//;
# Handle type name changes
if ( $arg eq 'opaque' ) {
$arg = 'internal';
} elsif ( $arg eq 'boolean' ) {
$arg = 'bool';
} elsif ( $arg eq 'oldgeometry' ) {
$arg = 'geometry';
}
# Timestamp with or without time zone
if ( $arg =~ /timestamp .* time zone/ ) {
$arg = 'timestamp';
}
return $arg;
}
# Change SRID to be within allowed ranges
sub
clamp_srid
{
my $oldsrid = shift;
my $newsrid = $oldsrid;
if ( $oldsrid < 0 ) {
$newsrid = 0;
printf STDERR " WARNING: SRID $oldsrid converted to $newsrid (official UNKNOWN)\n";
} elsif ( $oldsrid > $SRID_MAXIMUM ) {
$newsrid = $SRID_USER_MAXIMUM + 1 +
# -1 is to reduce likelyhood of clashes
# NOTE: must match core implementation (lwutil.c)
( $oldsrid % ( $SRID_MAXIMUM - $SRID_USER_MAXIMUM - 1 ) );
printf STDERR " WARNING: SRID $oldsrid converted to $newsrid (in reserved zone)\n";
} elsif ( $oldsrid > $SRID_USER_MAXIMUM ) {
printf STDERR " WARNING: SRID $newsrid is in reserved zone\n";
}
return $newsrid;
}
######################################################################
# Here are all the signatures we want to skip.
#
__END__
AGGREGATE accum(geometry)
AGGREGATE accum_old(geometry)
AGGREGATE collect(geometry)
AGGREGATE extent3d(geometry)
AGGREGATE extent(geometry)
AGGREGATE geomunion(geometry)
AGGREGATE geomunion_old(geometry)
AGGREGATE makeline(geometry)
AGGREGATE memcollect(geometry)
AGGREGATE memgeomunion(geometry)
AGGREGATE polygonize(geometry)
AGGREGATE st_3dextent(geometry)
AGGREGATE st_accum(geometry)
AGGREGATE st_accum_old(geometry)
AGGREGATE st_collect(geometry)
AGGREGATE st_extent3d(geometry)
AGGREGATE st_extent(geometry)
AGGREGATE st_makeline(geometry)
AGGREGATE st_memcollect(geometry)
AGGREGATE st_memunion(geometry)
AGGREGATE st_polygonize(geometry)
AGGREGATE st_union(geometry)
AGGREGATE st_union_old(geometry)
AGGREGATE st_union(raster)
AGGREGATE st_union(raster,integer)
AGGREGATE st_union(raster,integer,text)
AGGREGATE st_union(raster,text)
AGGREGATE st_union(raster,text,text)
AGGREGATE st_union(raster,text,text,text)
AGGREGATE st_union(raster,text,text,text,double precision)
AGGREGATE st_union(raster,text,text,text,double precision,text,text,text,double precision)
AGGREGATE st_union(raster,text,text,text,double precision,text,text,text,double precision,text,text,text,double precision)
AGGREGATE topoelementarray_agg(topoelement)
CAST CAST (boolean AS text)
CAST CAST (bytea AS public.geography)
CAST CAST (bytea AS public.geometry)
CAST CAST (public.box2d AS public.box3d)
CAST CAST (public.box2d AS public.geometry)
CAST CAST (public.box3d AS box)
CAST CAST (public.box3d AS public.box2d)
CAST CAST (public.box3d AS public.geometry)
CAST CAST (public.box3d_extent AS public.box2d)
CAST CAST (public.box3d_extent AS public.box3d)
CAST CAST (public.box3d_extent AS public.geometry)
CAST CAST (public.chip AS public.geometry)
CAST CAST (public.geography AS bytea)
CAST CAST (public.geography AS public.geography)
CAST CAST (public.geography AS public.geometry)
CAST CAST (public.geometry AS box)
CAST CAST (public.geometry AS bytea)
CAST CAST (public.geometry AS public.box2d)
CAST CAST (public.geometry AS public.box3d)
CAST CAST (public.geometry AS public.geography)
CAST CAST (public.geometry AS public.geometry)
CAST CAST (public.geometry AS text)
CAST CAST (public.raster AS box2d)
CAST CAST (public.raster AS bytea)
CAST CAST (public.raster AS public.box2d)
CAST CAST (public.raster AS public.box3d)
CAST CAST (public.raster AS public.geometry)
CAST CAST (raster AS bytea)
CAST CAST (raster AS geometry)
CAST CAST (text AS public.geometry)
CAST CAST (topology.topogeometry AS geometry)
CAST CAST (topology.topogeometry AS public.geometry)
COMMENT AGGREGATE st_3dextent(geometry)
COMMENT AGGREGATE st_accum(geometry)
COMMENT AGGREGATE st_collect(geometry)
COMMENT AGGREGATE st_extent3d(geometry)
COMMENT AGGREGATE st_extent(geometry)
COMMENT AGGREGATE st_makeline(geometry)
COMMENT AGGREGATE st_memunion(geometry)
COMMENT AGGREGATE st_polygonize(geometry)
COMMENT AGGREGATE st_union(geometry)
COMMENT AGGREGATE st_union(raster)
COMMENT AGGREGATE st_union(raster,integer)
COMMENT AGGREGATE st_union(raster,integer,text)
COMMENT AGGREGATE st_union(raster,text)
COMMENT AGGREGATE topoelementarray_agg(topoelement)
COMMENT DOMAIN topoelement
COMMENT DOMAIN topoelementarray
COMMENT FUNCTION addauth(text)
COMMENT FUNCTION addedge(atopology character varying,aline public.geometry)
COMMENT FUNCTION addedge(character varying,public.geometry)
COMMENT FUNCTION addface(atopology character varying,apoly public.geometry,force_new boolean)
COMMENT FUNCTION addgeometrycolumn(catalog_namecharacter varying,schema_namecharacter varying,table_namecharacter varying,column_namecharacter varying,new_srid_ininteger,new_typecharacter varying,new_diminteger,use_typmodboolean)
COMMENT FUNCTION addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer)
COMMENT FUNCTION addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer)
COMMENT FUNCTION addgeometrycolumn(character varying,character varying,integer,character varying,integer)
COMMENT FUNCTION addgeometrycolumn(schema_name character varying,table_name character varying,column_name character varying,new_srid integer,new_type character varying,new_dim integer,use_typmod boolean)
COMMENT FUNCTION addgeometrycolumn(table_name character varying,column_name character varying,new_srid integer,new_type character varying,new_dim integer,use_typmod boolean)
COMMENT FUNCTION addnode(atopology character varying,apoint public.geometry,allowedgesplitting boolean,setcontainingface boolean)
COMMENT FUNCTION addnode(character varying,public.geometry)
COMMENT FUNCTION addrasterconstraints(rastschema name,rasttable name,rastcolumn name,srid boolean,scale_x boolean,scale_y boolean,blocksize_x boolean,blocksize_y boolean,same_alignment boolean,regular_blocking boolean,num_bands boolean,pixel_types boolean,nodata_values boolean,extent boolean)
COMMENT FUNCTION addrasterconstraints(rastschema name,rasttable name,rastcolumn name,variadic constraints text[])
COMMENT FUNCTION addrasterconstraints(rasttable name,rastcolumn name,srid boolean,scale_x boolean,scale_y boolean,blocksize_x boolean,blocksize_y boolean,same_alignment boolean,regular_blocking boolean,num_bands boolean,pixel_types boolean,nodata_values boolean,extent boolean)
COMMENT FUNCTION addrasterconstraints(rasttable name,rastcolumn name,variadic constraints text[])
COMMENT FUNCTION addtopogeometrycolumn(character varying,character varying,character varying,character varying,character varying)
COMMENT FUNCTION addtopogeometrycolumn(character varying,character varying,character varying,character varying,character varying,integer)
COMMENT FUNCTION addtopogeometrycolumn(toponame character varying,schema character varying,tbl character varying,col character varying,ltype character varying,child integer)
COMMENT FUNCTION asgml(tgtopogeometry)
COMMENT FUNCTION asgml(tgtopogeometry,nsprefix_in text,precision_in integer,options_in integer,visitedtable regclass,idprefix text,gmlver integer)
COMMENT FUNCTION asgml(tgtopogeometry,nsprefix text)
COMMENT FUNCTION asgml(tgtopogeometry,nsprefix text,prec integer,options integer,visitedtable regclass,idprefix text)
COMMENT FUNCTION asgml(tgtopogeometry,nsprefix text,prec integer,options integer,vis regclass)
COMMENT FUNCTION asgml(tgtopogeometry,nsprefix text,prec integer,opts integer)
COMMENT FUNCTION asgml(tgtopogeometry,visitedtable regclass)
COMMENT FUNCTION asgml(tgtopogeometry,visitedtable regclass,nsprefix text)
COMMENT FUNCTION box2d(geometry)
COMMENT FUNCTION box3d(geometry)
COMMENT FUNCTION box3d(raster)
COMMENT FUNCTION checkauth(text,text)
COMMENT FUNCTION checkauth(text,text,text)
COMMENT FUNCTION copytopology(atopologycharacter varying,newtopocharacter varying)
COMMENT FUNCTION createtopogeom(character varying,integer,integer,topoelementarray)
COMMENT FUNCTION createtopogeom(toponame character varying,tg_type integer,layer_id integer)
COMMENT FUNCTION createtopogeom(toponame character varying,tg_type integer,layer_id integer,tg_objs topoelementarray)
COMMENT FUNCTION createtopology(atopology character varying,srid integer,prec double precision,hasz boolean)
COMMENT FUNCTION createtopology(character varying)
COMMENT FUNCTION createtopology(character varying,integer)
COMMENT FUNCTION createtopology(toponame character varying,sridinteger,precdouble precision)
COMMENT FUNCTION disablelongtransactions()
COMMENT FUNCTION dropgeometrycolumn(catalog_namecharacter varying,schema_namecharacter varying,table_namecharacter varying,column_namecharacter varying)
COMMENT FUNCTION dropgeometrycolumn(character varying,character varying)
COMMENT FUNCTION dropgeometrycolumn(character varying,character varying,character varying)
COMMENT FUNCTION dropgeometrycolumn(character varying,character varying,character varying,character varying)
COMMENT FUNCTION dropgeometrycolumn(schema_namecharacter varying,table_namecharacter varying,column_namecharacter varying)
COMMENT FUNCTION dropgeometrycolumn(table_namecharacter varying,column_namecharacter varying)
COMMENT FUNCTION dropgeometrytable(catalog_namecharacter varying,schema_namecharacter varying,table_namecharacter varying)
COMMENT FUNCTION dropgeometrytable(character varying)
COMMENT FUNCTION dropgeometrytable(character varying,character varying)
COMMENT FUNCTION dropgeometrytable(character varying,character varying,character varying)
COMMENT FUNCTION dropgeometrytable(schema_namecharacter varying,table_namecharacter varying)
COMMENT FUNCTION dropgeometrytable(table_namecharacter varying)
COMMENT FUNCTION droprasterconstraints(rastschema name,rasttable name,rastcolumn name,variadic constraints text[])
COMMENT FUNCTION droprasterconstraints(rasttablename,rastcolumnname,sridboolean,scale_xboolean,scale_yboolean,blocksize_xboolean,blocksize_yboolean,same_alignmentboolean,regular_blockingboolean,num_bandsboolean,pixel_typesboolean,nodata_valuesboolean,extentboolean)
COMMENT FUNCTION droptopogeometrycolumn(character varying,character varying,character varying)
COMMENT FUNCTION droptopogeometrycolumn(schema character varying,tbl character varying,col character varying)
COMMENT FUNCTION droptopology(atopology character varying)
COMMENT FUNCTION droptopology(character varying)
COMMENT FUNCTION enablelongtransactions()
COMMENT FUNCTION find_srid(character varying,character varying,character varying)
COMMENT FUNCTION geometrytype(geometry)
COMMENT FUNCTION getedgebypoint(atopologycharacter varying,apointpublic.geometry,tol1double precision)
COMMENT FUNCTION getfacebypoint(atopologycharacter varying,apointpublic.geometry,tol1double precision)
COMMENT FUNCTION getnodebypoint(atopologycharacter varying,apointpublic.geometry,tol1double precision)
COMMENT FUNCTION gettopogeomelementarray(character varying,integer,integer)
COMMENT FUNCTION gettopogeomelementarray(tg topogeometry)
COMMENT FUNCTION gettopogeomelementarray(topogeometry)
COMMENT FUNCTION gettopogeomelementarray(toponame character varying,layer_id integer,tgid integer)
COMMENT FUNCTION gettopogeomelements(character varying,integer,integer)
COMMENT FUNCTION gettopogeomelements(tg topogeometry)
COMMENT FUNCTION gettopogeomelements(topogeometry)
COMMENT FUNCTION gettopogeomelements(toponame character varying,layerid integer,tgid integer)
COMMENT FUNCTION gettopologyid(character varying)
COMMENT FUNCTION gettopologyid(toponame character varying)
COMMENT FUNCTION gettopologyname(integer)
COMMENT FUNCTION gettopologyname(topoid integer)
COMMENT FUNCTION lockrow(text,text,text)
COMMENT FUNCTION lockrow(text,text,text,text,timestampwithouttimezone)
COMMENT FUNCTION lockrow(text,text,text,timestampwithouttimezone)
COMMENT FUNCTION polygonize(toponame character varying)
COMMENT FUNCTION populate_geometry_columns()
COMMENT FUNCTION populate_geometry_columns(tbl_oidoid)
COMMENT FUNCTION populate_geometry_columns(tbl_oidoid,use_typmodboolean)
COMMENT FUNCTION populate_geometry_columns(use_typmodboolean)
COMMENT FUNCTION postgis_addbbox(geometry)
COMMENT FUNCTION postgis_dropbbox(geometry)
COMMENT FUNCTION postgis_full_version()
COMMENT FUNCTION postgis_geos_version()
COMMENT FUNCTION postgis_hasbbox(geometry)
COMMENT FUNCTION postgis_lib_build_date()
COMMENT FUNCTION postgis_lib_version()
COMMENT FUNCTION postgis_libxml_version()
COMMENT FUNCTION postgis_proj_version()
COMMENT FUNCTION postgis_raster_lib_build_date()
COMMENT FUNCTION postgis_raster_lib_version()
COMMENT FUNCTION postgis_scripts_build_date()
COMMENT FUNCTION postgis_scripts_installed()
COMMENT FUNCTION postgis_scripts_released()
COMMENT FUNCTION postgis_uses_stats()
COMMENT FUNCTION postgis_version()
COMMENT FUNCTION probe_geometry_columns()
COMMENT FUNCTION st_3dclosestpoint(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dclosestpoint(geometry,geometry)
COMMENT FUNCTION st_3ddfullywithin(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_3ddfullywithin(geometry,geometry,double precision)
COMMENT FUNCTION st_3ddistance(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3ddistance(geometry,geometry)
COMMENT FUNCTION st_3ddwithin(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_3ddwithin(geometry,geometry,double precision)
COMMENT FUNCTION st_3dintersects(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dintersects(geometry,geometry)
COMMENT FUNCTION st_3dlength(geometry)
COMMENT FUNCTION st_3dlength_spheroid(geometry,spheroid)
COMMENT FUNCTION st_3dlongestline(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dlongestline(geometry,geometry)
COMMENT FUNCTION st_3dmakebox(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dmakebox(geometry,geometry)
COMMENT FUNCTION st_3dmaxdistance(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dmaxdistance(geometry,geometry)
COMMENT FUNCTION st_3dperimeter(geometry)
COMMENT FUNCTION st_3dshortestline(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_3dshortestline(geometry,geometry)
COMMENT FUNCTION st_addband(rast raster,indexinteger,pixeltypetext,initialvaluedouble precision,nodatavaldouble precision)
COMMENT FUNCTION st_addband(rast raster,pixeltypetext,initialvaluedouble precision,nodatavaldouble precision)
COMMENT FUNCTION st_addband(torast raster,fromrast raster,frombandinteger,torastindexinteger)
COMMENT FUNCTION st_addband(torast raster,fromrastsraster[],frombandinteger)
COMMENT FUNCTION st_addbbox(geometry)
COMMENT FUNCTION st_addedgemodface(atopologycharacter varying,anodeinteger,anothernodeinteger,acurvepublic.geometry)
COMMENT FUNCTION st_addedgenewfaces(atopologycharacter varying,anodeinteger,anothernodeinteger,acurvepublic.geometry)
COMMENT FUNCTION st_addisoedge(atopologycharacter varying,anodeinteger,anothernodeinteger,acurvepublic.geometry)
COMMENT FUNCTION st_addisonode(atopology character varying,aface integer,apoint public.geometry)
COMMENT FUNCTION st_addisonode(character varying,integer,public.geometry)
COMMENT FUNCTION st_addmeasure(geometry,double precision,double precision)
COMMENT FUNCTION st_addpoint(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_addpoint(geom1 geometry,geom2 geometry,integer)
COMMENT FUNCTION st_addpoint(geometry,geometry)
COMMENT FUNCTION st_addpoint(geometry,geometry,integer)
COMMENT FUNCTION st_affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_area(geoggeography,use_spheroidboolean)
COMMENT FUNCTION st_area(geography)
COMMENT FUNCTION st_area(geography,boolean)
COMMENT FUNCTION st_area(geometry)
COMMENT FUNCTION st_asbinary(geography)
COMMENT FUNCTION st_asbinary(geography,text)
COMMENT FUNCTION st_asbinary(geometry)
COMMENT FUNCTION st_asbinary(geometry,text)
COMMENT FUNCTION st_asbinary(raster)
COMMENT FUNCTION st_asencodedpolyline(geometry)
COMMENT FUNCTION st_asencodedpolyline(geometry,integer)
COMMENT FUNCTION st_asewkb(geometry)
COMMENT FUNCTION st_asewkb(geometry,text)
COMMENT FUNCTION st_asewkt(geometry)
COMMENT FUNCTION st_asgdalraster(rast raster,formattext,optionstext[],sridinteger)
COMMENT FUNCTION st_asgeojson(geog geography,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgeojson(geography)
COMMENT FUNCTION st_asgeojson(geography,integer)
COMMENT FUNCTION st_asgeojson(geography,integer,integer)
COMMENT FUNCTION st_asgeojson(geometry)
COMMENT FUNCTION st_asgeojson(geometry,integer)
COMMENT FUNCTION st_asgeojson(geometry,integer,integer)
COMMENT FUNCTION st_asgeojson(geom geometry,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgeojson(gj_version integer,geog geography,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgeojson(gj_version integer,geom geometry,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgeojson(integer,geography)
COMMENT FUNCTION st_asgeojson(integer,geography,integer)
COMMENT FUNCTION st_asgeojson(integer,geography,integer,integer)
COMMENT FUNCTION st_asgeojson(integer,geometry)
COMMENT FUNCTION st_asgeojson(integer,geometry,integer)
COMMENT FUNCTION st_asgeojson(integer,geometry,integer,integer)
COMMENT FUNCTION st_asgml(geog geography,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgml(geography)
COMMENT FUNCTION st_asgml(geography,integer)
COMMENT FUNCTION st_asgml(geography,integer,integer)
COMMENT FUNCTION st_asgml(geometry)
COMMENT FUNCTION st_asgml(geometry,integer)
COMMENT FUNCTION st_asgml(geometry,integer,integer)
COMMENT FUNCTION st_asgml(geom geometry,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asgml(integer,geography)
COMMENT FUNCTION st_asgml(integer,geography,integer)
COMMENT FUNCTION st_asgml(integer,geography,integer,integer)
COMMENT FUNCTION st_asgml(integer,geography,integer,integer,text)
COMMENT FUNCTION st_asgml(integer,geometry)
COMMENT FUNCTION st_asgml(integer,geometry,integer)
COMMENT FUNCTION st_asgml(integer,geometry,integer,integer)
COMMENT FUNCTION st_asgml(integer,geometry,integer,integer,text)
COMMENT FUNCTION st_asgml(version integer,geog geography,maxdecimaldigits integer,options integer,nprefix text)
COMMENT FUNCTION st_asgml(version integer,geom geometry,maxdecimaldigits integer,options integer,nprefix text)
COMMENT FUNCTION st_ashexewkb(geometry)
COMMENT FUNCTION st_ashexewkb(geometry,text)
COMMENT FUNCTION st_asjpeg(rast raster,nband integer,optionstext[])
COMMENT FUNCTION st_asjpeg(rast raster,nband integer,qualityinteger)
COMMENT FUNCTION st_asjpeg(rast raster,nbands integer[],optionstext[])
COMMENT FUNCTION st_asjpeg(rast raster,nbands integer[],qualityinteger)
COMMENT FUNCTION st_asjpeg(rast raster,optionstext[])
COMMENT FUNCTION st_askml(geog geography,maxdecimaldigits integer)
COMMENT FUNCTION st_askml(geography)
COMMENT FUNCTION st_askml(geography,integer)
COMMENT FUNCTION st_askml(geometry)
COMMENT FUNCTION st_askml(geometry,integer)
COMMENT FUNCTION st_askml(geom geometry,maxdecimaldigits integer)
COMMENT FUNCTION st_askml(integer,geography)
COMMENT FUNCTION st_askml(integer,geography,integer)
COMMENT FUNCTION st_askml(integer,geography,integer,text)
COMMENT FUNCTION st_askml(integer,geometry)
COMMENT FUNCTION st_askml(integer,geometry,integer)
COMMENT FUNCTION st_askml(integer,geometry,integer,text)
COMMENT FUNCTION st_askml(version integer,geog geography,maxdecimaldigits integer,nprefix text)
COMMENT FUNCTION st_askml(version integer,geom geometry,maxdecimaldigits integer,nprefix text)
COMMENT FUNCTION st_aslatlontext(geometry)
COMMENT FUNCTION st_aslatlontext(geometry,text)
COMMENT FUNCTION st_aspng(rast raster,nband integer,compressioninteger)
COMMENT FUNCTION st_aspng(rast raster,nband integer,optionstext[])
COMMENT FUNCTION st_aspng(rast raster,nbands integer[],compressioninteger)
COMMENT FUNCTION st_aspng(rast raster,nbands integer[],optionstext[])
COMMENT FUNCTION st_aspng(rast raster,optionstext[])
COMMENT FUNCTION st_asraster(geomgeometry,refraster,pixeltypetext,valuedouble precision,nodatavaldouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,refraster,pixeltypetext[],valuedouble precision[],nodatavaldouble precision[],touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,scalexdouble precision,scaleydouble precision,gridxdouble precision,gridydouble precision,pixeltypetext,valuedouble precision,nodatavaldouble precision,skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,scalexdouble precision,scaleydouble precision,gridxdouble precision,gridydouble precision,pixeltypetext[],valuedouble precision[],nodatavaldouble precision[],skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,scalexdouble precision,scaleydouble precision,pixeltypetext,valuedouble precision,nodatavaldouble precision,upperleftxdouble precision,upperleftydouble precision,skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,widthinteger,heightinteger,gridxdouble precision,gridydouble precision,pixeltypetext,valuedouble precision,nodatavaldouble precision,skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,widthinteger,heightinteger,gridxdouble precision,gridydouble precision,pixeltypetext[],valuedouble precision[],nodatavaldouble precision[],skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,widthinteger,heightinteger,pixeltypetext,valuedouble precision,nodatavaldouble precision,upperleftxdouble precision,upperleftydouble precision,skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_asraster(geomgeometry,widthinteger,heightinteger,pixeltypetext[],valuedouble precision[],nodatavaldouble precision[],upperleftxdouble precision,upperleftydouble precision,skewxdouble precision,skewydouble precision,touchedboolean)
COMMENT FUNCTION st_assvg(geog geography,rel integer,maxdecimaldigits integer)
COMMENT FUNCTION st_assvg(geography)
COMMENT FUNCTION st_assvg(geography,integer)
COMMENT FUNCTION st_assvg(geography,integer,integer)
COMMENT FUNCTION st_assvg(geometry)
COMMENT FUNCTION st_assvg(geometry,integer)
COMMENT FUNCTION st_assvg(geometry,integer,integer)
COMMENT FUNCTION st_assvg(geom geometry,rel integer,maxdecimaldigits integer)
COMMENT FUNCTION st_astext(geography)
COMMENT FUNCTION st_astext(geometry)
COMMENT FUNCTION st_astiff(rast raster,compressiontext,sridinteger)
COMMENT FUNCTION st_astiff(rast raster,nbands integer[],compressiontext,sridinteger)
COMMENT FUNCTION st_astiff(rast raster,nbands integer[],optionstext[],sridinteger)
COMMENT FUNCTION st_astiff(rast raster,optionstext[],sridinteger)
COMMENT FUNCTION st_asx3d(geom geometry,maxdecimaldigits integer,options integer)
COMMENT FUNCTION st_asx3d(geomgeometry,precinteger)
COMMENT FUNCTION st_azimuth(geog1 geography,geog2 geography)
COMMENT FUNCTION st_azimuth(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_azimuth(geometry,geometry)
COMMENT FUNCTION st_bandisnodata(rast raster,bandinteger,forcecheckingboolean)
COMMENT FUNCTION st_bandisnodata(rast raster,forcechecking boolean)
COMMENT FUNCTION st_bandmetadata(rast raster,bandinteger,OUT pixeltype text,OUT hasnodata boolean,OUT nodatavalue double precision,OUT isoutdb boolean,OUT path text)
COMMENT FUNCTION st_bandnodatavalue(rast raster,bandinteger)
COMMENT FUNCTION st_bandpath(rast raster,bandinteger)
COMMENT FUNCTION st_bandpixeltype(rast raster,bandinteger)
COMMENT FUNCTION st_band(rast raster,nband integer)
COMMENT FUNCTION st_band(rast raster,nbands integer[])
COMMENT FUNCTION st_band(rast raster,nbandstext,delimitercharacter)
COMMENT FUNCTION st_bdmpolyfromtext(text,integer)
COMMENT FUNCTION st_bdpolyfromtext(text,integer)
COMMENT FUNCTION st_boundary(geometry)
COMMENT FUNCTION st_box2dfromgeohash(text)
COMMENT FUNCTION st_box2dfromgeohash(text,integer)
COMMENT FUNCTION st_box2d(geometry)
COMMENT FUNCTION st_box3d(geometry)
COMMENT FUNCTION st_buffer(geography,double precision)
COMMENT FUNCTION st_buffer(geometry,double precision)
COMMENT FUNCTION st_buffer(geometry,double precision,integer)
COMMENT FUNCTION st_buffer(geometry,double precision,text)
COMMENT FUNCTION st_buildarea(geometry)
COMMENT FUNCTION st_centroid(geometry)
COMMENT FUNCTION st_changeedgegeom(atopologycharacter varying,anedgeinteger,acurvepublic.geometry)
COMMENT FUNCTION st_clip(rast raster,band integer,geom geometry,crop boolean)
COMMENT FUNCTION st_clip(rast raster,band integer,geom geometry,nodata double precision,trimraster boolean)
COMMENT FUNCTION st_clip(rast raster,band integer,geom geometry,trimraster boolean)
COMMENT FUNCTION st_clip(rast raster,geom geometry,crop boolean)
COMMENT FUNCTION st_clip(rast raster,geom geometry,nodata double precision,trimraster boolean)
COMMENT FUNCTION st_clip(rast raster,geom geometry,trimraster boolean)
COMMENT FUNCTION st_closestpoint(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_closestpoint(geometry,geometry)
COMMENT FUNCTION st_collect(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_collect(geometry[])
COMMENT FUNCTION st_collect(geometry,geometry)
COMMENT FUNCTION st_collectionextract(geometry,integer)
COMMENT FUNCTION st_concavehull(param_geomgeometry,param_pctconvexdouble precision,param_allow_holesboolean)
COMMENT FUNCTION st_contains(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_contains(geometry,geometry)
COMMENT FUNCTION st_containsproperly(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_containsproperly(geometry,geometry)
COMMENT FUNCTION st_convexhull(geometry)
COMMENT FUNCTION st_convexhull(raster)
COMMENT FUNCTION st_coorddim(geometry)
COMMENT FUNCTION st_coorddim(geometry geometry)
COMMENT FUNCTION st_count(rastertabletext,rastercolumntext,exclude_nodata_valueboolean)
COMMENT FUNCTION st_count(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean)
COMMENT FUNCTION st_count(rast raster,exclude_nodata_valueboolean)
COMMENT FUNCTION st_count(rast raster,nband integer,exclude_nodata_valueboolean)
COMMENT FUNCTION st_coveredby(geography,geography)
COMMENT FUNCTION st_coveredby(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_coveredby(geometry,geometry)
COMMENT FUNCTION st_covers(geography,geography)
COMMENT FUNCTION st_covers(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_covers(geometry,geometry)
COMMENT FUNCTION st_createtopogeo(atopologycharacter varying,acollectionpublic.geometry)
COMMENT FUNCTION st_crosses(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_crosses(geometry,geometry)
COMMENT FUNCTION st_curvetoline(geometry)
COMMENT FUNCTION st_curvetoline(geometry,integer)
COMMENT FUNCTION st_dfullywithin(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_dfullywithin(geometry,geometry,double precision)
COMMENT FUNCTION st_difference(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_difference(geometry,geometry)
COMMENT FUNCTION st_dimension(geometry)
COMMENT FUNCTION st_disjoint(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_disjoint(geometry,geometry)
COMMENT FUNCTION st_distance(geography,geography)
COMMENT FUNCTION st_distance(geography,geography,boolean)
COMMENT FUNCTION st_distance(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_distance(geometry,geometry)
COMMENT FUNCTION st_distance_sphere(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_distance_sphere(geometry,geometry)
COMMENT FUNCTION st_distance_spheroid(geom1 geometry,geom2 geometry,spheroid)
COMMENT FUNCTION st_distance_spheroid(geometry,geometry,spheroid)
COMMENT FUNCTION st_dropbbox(geometry)
COMMENT FUNCTION st_dumpaspolygons(rast raster,bandinteger)
COMMENT FUNCTION st_dump(geometry)
COMMENT FUNCTION st_dumppoints(geometry)
COMMENT FUNCTION st_dumprings(geometry)
COMMENT FUNCTION st_dwithin(geography,geography,double precision)
COMMENT FUNCTION st_dwithin(geography,geography,double precision,boolean)
COMMENT FUNCTION st_dwithin(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_dwithin(geometry,geometry,double precision)
COMMENT FUNCTION st_endpoint(geometry)
COMMENT FUNCTION st_envelope(geometry)
COMMENT FUNCTION st_envelope(raster)
COMMENT FUNCTION st_equals(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_equals(geometry,geometry)
COMMENT FUNCTION st_estimated_extent(text,text)
COMMENT FUNCTION st_estimated_extent(text,text,text)
COMMENT FUNCTION st_expand(box2d,double precision)
COMMENT FUNCTION st_expand(box3d,double precision)
COMMENT FUNCTION st_expand(geometry,double precision)
COMMENT FUNCTION st_exteriorring(geometry)
COMMENT FUNCTION st_flipcoordinates(geometry)
COMMENT FUNCTION st_force_2d(geometry)
COMMENT FUNCTION st_force_3d(geometry)
COMMENT FUNCTION st_force_3dm(geometry)
COMMENT FUNCTION st_force_3dz(geometry)
COMMENT FUNCTION st_force_4d(geometry)
COMMENT FUNCTION st_force_collection(geometry)
COMMENT FUNCTION st_forcerhr(geometry)
COMMENT FUNCTION st_gdaldrivers(OUTidxinteger,OUTshort_nametext,OUTlong_nametext,OUTcreate_optionstext)
COMMENT FUNCTION st_geogfromtext(text)
COMMENT FUNCTION st_geogfromwkb(bytea)
COMMENT FUNCTION st_geographyfromtext(text)
COMMENT FUNCTION st_geohash(geometry)
COMMENT FUNCTION st_geohash(geometry,integer)
COMMENT FUNCTION st_geohash(geom geometry,maxchars integer)
COMMENT FUNCTION st_geomcollfromtext(text)
COMMENT FUNCTION st_geomcollfromtext(text,integer)
COMMENT FUNCTION st_geometryfromtext(text)
COMMENT FUNCTION st_geometryfromtext(text,integer)
COMMENT FUNCTION st_geometryn(geometry,integer)
COMMENT FUNCTION st_geometrytype(geometry)
COMMENT FUNCTION st_geomfromewkb(bytea)
COMMENT FUNCTION st_geomfromewkt(text)
COMMENT FUNCTION st_geomfromgeohash(text)
COMMENT FUNCTION st_geomfromgeohash(text,integer)
COMMENT FUNCTION st_geomfromgeojson(text)
COMMENT FUNCTION st_geomfromgml(text)
COMMENT FUNCTION st_geomfromgml(text,integer)
COMMENT FUNCTION st_geomfromkml(text)
COMMENT FUNCTION st_geomfromtext(text)
COMMENT FUNCTION st_geomfromtext(text,integer)
COMMENT FUNCTION st_geomfromwkb(bytea)
COMMENT FUNCTION st_geomfromwkb(bytea,integer)
COMMENT FUNCTION st_georeference(rast raster,formattext)
COMMENT FUNCTION st_getfaceedges(toponame character varying,face_idinteger)
COMMENT FUNCTION st_getfacegeometry(toponame character varying,afaceinteger)
COMMENT FUNCTION st_gmltosql(text)
COMMENT FUNCTION st_gmltosql(text,integer)
COMMENT FUNCTION st_hasarc(geometry)
COMMENT FUNCTION st_hasarc(geometry geometry)
COMMENT FUNCTION st_hasbbox(geometry)
COMMENT FUNCTION st_hasnoband(rast raster,nband integer)
COMMENT FUNCTION st_hausdorffdistance(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_hausdorffdistance(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_hausdorffdistance(geometry,geometry)
COMMENT FUNCTION st_hausdorffdistance(geometry,geometry,double precision)
COMMENT FUNCTION st_height(raster)
COMMENT FUNCTION st_hillshade(rast raster,band integer,pixeltype text,azimuth double precision,altitude double precision,max_bright double precision,elevation_scale double precision)
COMMENT FUNCTION st_histogram(rastertabletext,rastercolumntext,nband integer,binsinteger,"right"boolean)
COMMENT FUNCTION st_histogram(rastertabletext,rastercolumntext,nband integer,binsinteger,widthdouble precision[],"right"boolean)
COMMENT FUNCTION st_histogram(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean,binsinteger,"right"boolean)
COMMENT FUNCTION st_histogram(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean,binsinteger,widthdouble precision[],"right"boolean)
COMMENT FUNCTION st_histogram(rast raster,nband integer,binsinteger,"right"boolean)
COMMENT FUNCTION st_histogram(rast raster,nband integer,binsinteger,widthdouble precision[],"right"boolean)
COMMENT FUNCTION st_histogram(rast raster,nband integer,exclude_nodata_valueboolean,binsinteger,"right"boolean)
COMMENT FUNCTION st_histogram(rast raster,nband integer,exclude_nodata_valueboolean,binsinteger,widthdouble precision[],"right"boolean)
COMMENT FUNCTION st_inittopogeo(atopologycharacter varying)
COMMENT FUNCTION st_interiorringn(geometry,integer)
COMMENT FUNCTION st_intersection(geography,geography)
COMMENT FUNCTION st_intersection(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_intersection(geometry,geometry)
COMMENT FUNCTION st_intersection(geomingeometry,rast raster,bandinteger)
COMMENT FUNCTION st_intersection(rast1raster,band1integer,geomgeometry,extenttypetext,otheruserfuncregprocedure)
COMMENT FUNCTION st_intersection(rast1raster,band1integer,geomgeometry,otheruserfuncregprocedure)
COMMENT FUNCTION st_intersection(rast1raster,geomgeometry,extenttypetext,otheruserfuncregprocedure)
COMMENT FUNCTION st_intersection(rast1raster,geomgeometry,otheruserfuncregprocedure)
COMMENT FUNCTION st_intersects(geography,geography)
COMMENT FUNCTION st_intersects(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_intersects(geometry,geometry)
COMMENT FUNCTION st_intersects(geomgeometry,rast raster,nband integer)
COMMENT FUNCTION st_intersects(rast1raster,nband1integer,rast2raster,nband2integer)
COMMENT FUNCTION st_intersects(rast1raster,rast2raster)
COMMENT FUNCTION st_intersects(rast raster,nband integer,geomgeometry)
COMMENT FUNCTION st_isclosed(geometry)
COMMENT FUNCTION st_iscollection(geometry)
COMMENT FUNCTION st_isempty(geometry)
COMMENT FUNCTION st_isempty(rast raster)
COMMENT FUNCTION st_isring(geometry)
COMMENT FUNCTION st_issimple(geometry)
COMMENT FUNCTION st_isvaliddetail(geometry)
COMMENT FUNCTION st_isvaliddetail(geometry,integer)
COMMENT FUNCTION st_isvalid(geometry)
COMMENT FUNCTION st_isvalid(geometry,integer)
COMMENT FUNCTION st_isvalidreason(geometry)
COMMENT FUNCTION st_isvalidreason(geometry,integer)
COMMENT FUNCTION st_length2d(geometry)
COMMENT FUNCTION st_length2d_spheroid(geometry,spheroid)
COMMENT FUNCTION st_length3d(geometry)
COMMENT FUNCTION st_length3d_spheroid(geometry,spheroid)
COMMENT FUNCTION st_length(geoggeography,use_spheroidboolean)
COMMENT FUNCTION st_length(geography)
COMMENT FUNCTION st_length(geography,boolean)
COMMENT FUNCTION st_length(geometry)
COMMENT FUNCTION st_length_spheroid(geometry,spheroid)
COMMENT FUNCTION st_linecrossingdirection(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_linecrossingdirection(geometry,geometry)
COMMENT FUNCTION st_linefromencodedpolyline(text)
COMMENT FUNCTION st_linefromencodedpolyline(text,integer)
COMMENT FUNCTION st_linefrommultipoint(geometry)
COMMENT FUNCTION st_linefromtext(text)
COMMENT FUNCTION st_linefromtext(text,integer)
COMMENT FUNCTION st_linefromwkb(bytea)
COMMENT FUNCTION st_linefromwkb(bytea,integer)
COMMENT FUNCTION st_line_interpolate_point(geometry,double precision)
COMMENT FUNCTION st_line_locate_point(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_line_locate_point(geometry,geometry)
COMMENT FUNCTION st_linemerge(geometry)
COMMENT FUNCTION st_linestringfromwkb(bytea)
COMMENT FUNCTION st_linestringfromwkb(bytea,integer)
COMMENT FUNCTION st_line_substring(geometry,double precision,double precision)
COMMENT FUNCTION st_linetocurve(geometry)
COMMENT FUNCTION st_linetocurve(geometry geometry)
COMMENT FUNCTION st_locate_along_measure(geometry,double precision)
COMMENT FUNCTION st_locatebetweenelevations(geometry,double precision,double precision)
COMMENT FUNCTION st_locatebetweenelevations(geometry geometry,fromelevation double precision,toelevation double precision)
COMMENT FUNCTION st_locate_between_measures(geometry,double precision,double precision)
COMMENT FUNCTION st_longestline(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_longestline(geometry,geometry)
COMMENT FUNCTION st_makebox2d(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_makebox2d(geometry,geometry)
COMMENT FUNCTION st_makebox3d(geometry,geometry)
COMMENT FUNCTION st_makeemptyraster(rast raster)
COMMENT FUNCTION st_makeemptyraster(widthinteger,heightinteger,upperleftxdouble precision,upperleftydouble precision,pixelsizedouble precision)
COMMENT FUNCTION st_makeemptyraster(widthinteger,heightinteger,upperleftxdouble precision,upperleftydouble precision,scalexdouble precision,scaleydouble precision,skewxdouble precision,skewydouble precision,sridinteger)
COMMENT FUNCTION st_makeenvelope(double precision,double precision,double precision,double precision,integer)
COMMENT FUNCTION st_makeline(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_makeline(geometry[])
COMMENT FUNCTION st_makeline(geometry,geometry)
COMMENT FUNCTION st_makepoint(double precision,double precision)
COMMENT FUNCTION st_makepoint(double precision,double precision,double precision)
COMMENT FUNCTION st_makepoint(double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_makepointm(double precision,double precision,double precision)
COMMENT FUNCTION st_makepolygon(geometry)
COMMENT FUNCTION st_makepolygon(geometry,geometry[])
COMMENT FUNCTION st_makevalid(geometry)
COMMENT FUNCTION st_mapalgebraexpr(rast1raster,band1integer,rast2raster,band2integer,expressiontext,pixeltypetext,extenttypetext,nodata1exprtext,nodata2exprtext,nodatanodatavaldouble precision)
COMMENT FUNCTION st_mapalgebraexpr(rast1raster,rast2raster,expressiontext,pixeltypetext,extenttypetext,nodata1exprtext,nodata2exprtext,nodatanodatavaldouble precision)
COMMENT FUNCTION st_mapalgebraexpr(rast raster,bandinteger,pixeltypetext,expressiontext,nodatavaldouble precision)
COMMENT FUNCTION st_mapalgebraexpr(rast raster,pixeltypetext,expressiontext,nodatavaldouble precision)
COMMENT FUNCTION st_mapalgebrafctngb(rast raster,bandinteger,pixeltypetext,ngbwidthinteger,ngbheightinteger,onerastngbuserfuncregprocedure,nodatamodetext,variadicargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast1raster,band1integer,rast2raster,band2integer,tworastuserfuncregprocedure,pixeltypetext,extenttypetext,variadicuserargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast1raster,rast2raster,tworastuserfuncregprocedure,pixeltypetext,extenttypetext,variadicuserargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast raster,bandinteger,onerastuserfuncregprocedure)
COMMENT FUNCTION st_mapalgebrafct(rast raster,bandinteger,onerastuserfuncregprocedure,variadicargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast raster,bandinteger,pixeltypetext,onerastuserfuncregprocedure)
COMMENT FUNCTION st_mapalgebrafct(rast raster,bandinteger,pixeltypetext,onerastuserfuncregprocedure,variadicargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast raster,onerastuserfuncregprocedure)
COMMENT FUNCTION st_mapalgebrafct(rast raster,onerastuserfuncregprocedure,variadicargstext[])
COMMENT FUNCTION st_mapalgebrafct(rast raster,pixeltypetext,onerastuserfuncregprocedure)
COMMENT FUNCTION st_mapalgebrafct(rast raster,pixeltypetext,onerastuserfuncregprocedure,variadicargstext[])
COMMENT FUNCTION st_maxdistance(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_max_distance(geometry,geometry)
COMMENT FUNCTION st_maxdistance(geometry,geometry)
COMMENT FUNCTION st_mem_size(geometry)
COMMENT FUNCTION st_metadata(rast raster,OUTupperleftxdouble precision,OUTupperleftydouble precision,OUTwidthinteger,OUTheightinteger,OUTscalexdouble precision,OUTscaleydouble precision,OUTskewxdouble precision,OUTskewydouble precision,OUTsridinteger,OUTnumbandsinteger)
COMMENT FUNCTION st_m(geometry)
COMMENT FUNCTION st_minimumboundingcircle(geometry)
COMMENT FUNCTION st_minimumboundingcircle(inputgeomgeometry,segs_per_quarterinteger)
COMMENT FUNCTION st_mlinefromtext(text)
COMMENT FUNCTION st_mlinefromtext(text,integer)
COMMENT FUNCTION st_modedgeheal(toponame character varying,e1idinteger,e2idinteger)
COMMENT FUNCTION st_modedgesplit(atopology character varying,anedge integer,apoint public.geometry)
COMMENT FUNCTION st_modedgesplit(character varying,integer,public.geometry)
COMMENT FUNCTION st_moveisonode(atopology character varying,anode integer,apoint public.geometry)
COMMENT FUNCTION st_moveisonode(character varying,integer,public.geometry)
COMMENT FUNCTION st_mpointfromtext(text)
COMMENT FUNCTION st_mpointfromtext(text,integer)
COMMENT FUNCTION st_mpolyfromtext(text)
COMMENT FUNCTION st_mpolyfromtext(text,integer)
COMMENT FUNCTION st_multi(geometry)
COMMENT FUNCTION st_ndims(geometry)
COMMENT FUNCTION st_newedgeheal(toponame character varying,e1idinteger,e2idinteger)
COMMENT FUNCTION st_newedgessplit(atopology character varying,anedge integer,apoint public.geometry)
COMMENT FUNCTION st_newedgessplit(character varying,integer,public.geometry)
COMMENT FUNCTION st_node(ggeometry)
COMMENT FUNCTION st_npoints(geometry)
COMMENT FUNCTION st_nrings(geometry)
COMMENT FUNCTION st_numbands(raster)
COMMENT FUNCTION st_numgeometries(geometry)
COMMENT FUNCTION st_numinteriorring(geometry)
COMMENT FUNCTION st_numinteriorrings(geometry)
COMMENT FUNCTION st_numpatches(geometry)
COMMENT FUNCTION st_numpoints(geometry)
COMMENT FUNCTION st_offsetcurve(linegeometry,distancedouble precision,paramstext)
COMMENT FUNCTION st_orderingequals(geometrya geometry,geometryb geometry)
COMMENT FUNCTION st_orderingequals(geometry,geometry)
COMMENT FUNCTION st_overlaps(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_overlaps(geometry,geometry)
COMMENT FUNCTION st_patchn(geometry,integer)
COMMENT FUNCTION st_perimeter2d(geometry)
COMMENT FUNCTION st_perimeter3d(geometry)
COMMENT FUNCTION st_perimeter(geoggeography,use_spheroidboolean)
COMMENT FUNCTION st_perimeter(geometry)
COMMENT FUNCTION st_pixelaspolygon(rast raster,bandinteger,xinteger,yinteger)
COMMENT FUNCTION st_pixelaspolygon(rast raster,xinteger,yinteger)
COMMENT FUNCTION st_pixelheight(raster)
COMMENT FUNCTION st_pixelwidth(raster)
COMMENT FUNCTION st_point(double precision,double precision)
COMMENT FUNCTION st_pointfromgeohash(text)
COMMENT FUNCTION st_pointfromgeohash(text,integer)
COMMENT FUNCTION st_pointfromtext(text)
COMMENT FUNCTION st_pointfromtext(text,integer)
COMMENT FUNCTION st_point_inside_circle(geometry,double precision,double precision,double precision)
COMMENT FUNCTION st_pointn(geometry,integer)
COMMENT FUNCTION st_pointonsurface(geometry)
COMMENT FUNCTION st_polygonfromtext(text)
COMMENT FUNCTION st_polygonfromtext(text,integer)
COMMENT FUNCTION st_polygon(geometry,integer)
COMMENT FUNCTION st_polygonize(geometry[])
COMMENT FUNCTION st_polygon(rast raster,bandinteger)
COMMENT FUNCTION st_project(geog geography,distance double precision,azimuth double precision)
COMMENT FUNCTION st_quantile(rast raster,exclude_nodata_valueboolean,quantiledouble precision)
COMMENT FUNCTION st_quantile(rast raster,nband integer,exclude_nodata_valueboolean,quantiledouble precision)
COMMENT FUNCTION st_quantile(rast raster,nband integer,exclude_nodata_valueboolean,quantilesdouble precision[])
COMMENT FUNCTION st_quantile(rast raster,nband integer,quantiledouble precision)
COMMENT FUNCTION st_quantile(rast raster,nband integer,quantilesdouble precision[])
COMMENT FUNCTION st_quantile(rast raster,quantiledouble precision)
COMMENT FUNCTION st_quantile(rast raster,quantilesdouble precision[])
COMMENT FUNCTION st_raster2worldcoordx(rast raster,xrinteger)
COMMENT FUNCTION st_raster2worldcoordx(rast raster,xrinteger,yrinteger)
COMMENT FUNCTION st_raster2worldcoordy(rast raster,xrinteger,yrinteger)
COMMENT FUNCTION st_raster2worldcoordy(rast raster,yrinteger)
COMMENT FUNCTION st_reclass(rast raster,nband integer,reclassexprtext,pixeltypetext,nodatavaldouble precision)
COMMENT FUNCTION st_reclass(rast raster,reclassexprtext,pixeltypetext)
COMMENT FUNCTION st_reclass(rast raster,variadicreclassargsetreclassarg[])
COMMENT FUNCTION st_relate(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_relate(geom1 geometry,geom2 geometry,integer)
COMMENT FUNCTION st_relate(geom1 geometry,geom2 geometry,text)
COMMENT FUNCTION st_relate(geometry,geometry)
COMMENT FUNCTION st_relate(geometry,geometry,integer)
COMMENT FUNCTION st_relate(geometry,geometry,text)
COMMENT FUNCTION st_relatematch(text,text)
COMMENT FUNCTION st_remedgemodface(toponame character varying,e1id integer)
COMMENT FUNCTION st_remedgenewface(toponame character varying,e1id integer)
COMMENT FUNCTION st_removeisonode(atopology character varying,anode integer)
COMMENT FUNCTION st_removeisonode(character varying,integer)
COMMENT FUNCTION st_removepoint(geometry,integer)
COMMENT FUNCTION st_removerepeatedpoints(geometry)
COMMENT FUNCTION st_resample(rast raster,refraster,algorithmtext,maxerrdouble precision,usescaleboolean)
COMMENT FUNCTION st_resample(rast raster,refraster,usescaleboolean,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_resample(rast raster,sridinteger,scalexdouble precision,scaleydouble precision,gridxdouble precision,gridydouble precision,skewxdouble precision,skewydouble precision,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_resample(rast raster,widthinteger,heightinteger,sridinteger,gridxdouble precision,gridydouble precision,skewxdouble precision,skewydouble precision,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_rescale(rast raster,scalexdouble precision,scaleydouble precision,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_rescale(rast raster,scalexydouble precision,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_reverse(geometry)
COMMENT FUNCTION st_rotate(geometry,double precision)
COMMENT FUNCTION st_rotatex(geometry,double precision)
COMMENT FUNCTION st_rotatey(geometry,double precision)
COMMENT FUNCTION st_rotatez(geometry,double precision)
COMMENT FUNCTION st_rotation(raster)
COMMENT FUNCTION st_samealignment(rast1raster,rast2raster)
COMMENT FUNCTION st_samealignment(ulx1double precision,uly1double precision,scalex1double precision,scaley1double precision,skewx1double precision,skewy1double precision,ulx2double precision,uly2double precision,scalex2double precision,scaley2double precision,skewx2double precision,skewy2double precision)
COMMENT FUNCTION st_scale(geometry,double precision,double precision)
COMMENT FUNCTION st_scale(geometry,double precision,double precision,double precision)
COMMENT FUNCTION st_scalex(raster)
COMMENT FUNCTION st_scaley(raster)
COMMENT FUNCTION st_segmentize(geometry,double precision)
COMMENT FUNCTION st_setbandisnodata(rast raster,bandinteger)
COMMENT FUNCTION st_setbandnodatavalue(rast raster,bandinteger,nodatavaluedouble precision,forcecheckingboolean)
COMMENT FUNCTION st_setbandnodatavalue(rast raster,nodatavaluedouble precision)
COMMENT FUNCTION st_setgeoreference(rast raster,georeftext,formattext)
COMMENT FUNCTION st_setpoint(geometry,integer,geometry)
COMMENT FUNCTION st_setrotation(rast raster,rotationdouble precision)
COMMENT FUNCTION st_setscale(rast raster,scaledouble precision)
COMMENT FUNCTION st_setscale(rast raster,scalexdouble precision,scaleydouble precision)
COMMENT FUNCTION st_setskew(rast raster,skewdouble precision)
COMMENT FUNCTION st_setskew(rast raster,skewxdouble precision,skewydouble precision)
COMMENT FUNCTION st_setsrid(geometry,integer)
COMMENT FUNCTION st_setsrid(rast raster,sridinteger)
COMMENT FUNCTION st_setupperleft(rast raster,upperleftxdouble precision,upperleftydouble precision)
COMMENT FUNCTION st_setvalue(rast raster,bandinteger,ptgeometry,newvaluedouble precision)
COMMENT FUNCTION st_setvalue(rast raster,bandinteger,xinteger,yinteger,newvaluedouble precision)
COMMENT FUNCTION st_setvalue(rast raster,ptgeometry,newvaluedouble precision)
COMMENT FUNCTION st_setvalue(rast raster,xinteger,yinteger,newvaluedouble precision)
COMMENT FUNCTION st_sharedpaths(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_sharedpaths(geometry,geometry)
COMMENT FUNCTION st_shift_longitude(geometry)
COMMENT FUNCTION st_shortestline(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_shortestline(geometry,geometry)
COMMENT FUNCTION st_simplify(geometry,double precision)
COMMENT FUNCTION st_simplifypreservetopology(geometry,double precision)
COMMENT FUNCTION st_skewx(raster)
COMMENT FUNCTION st_skewy(raster)
COMMENT FUNCTION st_snap(geom1 geometry,geom2 geometry,double precision)
COMMENT FUNCTION st_snap(geometry,geometry,double precision)
COMMENT FUNCTION st_snaptogrid(geom1 geometry,geom2 geometry,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_snaptogrid(geometry,double precision)
COMMENT FUNCTION st_snaptogrid(geometry,double precision,double precision)
COMMENT FUNCTION st_snaptogrid(geometry,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_snaptogrid(geometry,geometry,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_split(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_split(geometry,geometry)
COMMENT FUNCTION st_srid(geometry)
COMMENT FUNCTION st_srid(raster)
COMMENT FUNCTION st_startpoint(geometry)
COMMENT FUNCTION st_summary(geometry)
COMMENT FUNCTION st_summarystats(rastertabletext,rastercolumntext,exclude_nodata_valueboolean)
COMMENT FUNCTION st_summarystats(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean)
COMMENT FUNCTION st_summarystats(rast raster,exclude_nodata_valueboolean)
COMMENT FUNCTION st_summarystats(rast raster,nband integer,exclude_nodata_valueboolean)
COMMENT FUNCTION st_symdifference(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_symdifference(geometry,geometry)
COMMENT FUNCTION st_touches(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_touches(geometry,geometry)
COMMENT FUNCTION st_transform(geometry,integer)
COMMENT FUNCTION st_transform(rast raster,sridinteger,algorithmtext,maxerrdouble precision,scalexdouble precision,scaleydouble precision)
COMMENT FUNCTION st_transform(rast raster,sridinteger,scalexdouble precision,scaleydouble precision,algorithmtext,maxerrdouble precision)
COMMENT FUNCTION st_translate(geometry,double precision,double precision)
COMMENT FUNCTION st_translate(geometry,double precision,double precision,double precision)
COMMENT FUNCTION st_transscale(geometry,double precision,double precision,double precision,double precision)
COMMENT FUNCTION st_unaryunion(geometry)
COMMENT FUNCTION st_union(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_union(geometry[])
COMMENT FUNCTION st_union(geometry,geometry)
COMMENT FUNCTION st_upperleftx(raster)
COMMENT FUNCTION st_upperlefty(raster)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,nband integer,exclude_nodata_valueboolean,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,nband integer,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,nband integer,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rastertabletext,rastercolumntext,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_valuecount(rast raster,nband integer,exclude_nodata_valueboolean,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rast raster,nband integer,exclude_nodata_valueboolean,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_valuecount(rast raster,nband integer,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rast raster,nband integer,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_valuecount(rast raster,searchvaluedouble precision,roundtodouble precision)
COMMENT FUNCTION st_valuecount(rast raster,searchvaluesdouble precision[],roundtodouble precision,OUTvaluedouble precision,OUTcountinteger)
COMMENT FUNCTION st_value(rast raster,bandinteger,ptgeometry,hasnodataboolean)
COMMENT FUNCTION st_value(rast raster,bandinteger,xinteger,yinteger,hasnodataboolean)
COMMENT FUNCTION st_value(rast raster,ptgeometry,hasnodataboolean)
COMMENT FUNCTION st_value(rast raster,xinteger,yinteger,hasnodataboolean)
COMMENT FUNCTION st_width(raster)
COMMENT FUNCTION st_within(geom1 geometry,geom2 geometry)
COMMENT FUNCTION st_within(geometry,geometry)
COMMENT FUNCTION st_wkbtosql(bytea)
COMMENT FUNCTION st_wkbtosql(wkb bytea)
COMMENT FUNCTION st_wkttosql(text)
COMMENT FUNCTION st_world2rastercoordx(rast raster,ptgeometry)
COMMENT FUNCTION st_world2rastercoordx(rast raster,xwdouble precision)
COMMENT FUNCTION st_world2rastercoordx(rast raster,xwdouble precision,ywdouble precision)
COMMENT FUNCTION st_world2rastercoordy(rast raster,ptgeometry)
COMMENT FUNCTION st_world2rastercoordy(rast raster,xwdouble precision,ywdouble precision)
COMMENT FUNCTION st_world2rastercoordy(rast raster,ywdouble precision)
COMMENT FUNCTION st_x(geometry)
COMMENT FUNCTION st_xmax(box3d)
COMMENT FUNCTION st_xmin(box3d)
COMMENT FUNCTION st_y(geometry)
COMMENT FUNCTION st_ymax(box3d)
COMMENT FUNCTION st_ymin(box3d)
COMMENT FUNCTION st_z(geometry)
COMMENT FUNCTION st_zmax(box3d)
COMMENT FUNCTION st_zmflag(geometry)
COMMENT FUNCTION st_zmin(box3d)
COMMENT FUNCTION topogeo_addlinestring(atopology character varying,aline public.geometry,tolerance double precision)
COMMENT FUNCTION topogeo_addpoint(atopology character varying,apoint public.geometry,tolerance double precision)
COMMENT FUNCTION topogeo_addpolygon(atopology character varying,apoly public.geometry,tolerance double precision)
COMMENT FUNCTION topologysummary(atopologycharacter varying)
COMMENT FUNCTION totopogeom(ageom public.geometry,atopology character varying,alayer integer,atolerance double precision)
COMMENT FUNCTION unlockrows(text)
COMMENT FUNCTION updategeometrysrid(catalogn_namecharacter varying,schema_namecharacter varying,table_namecharacter varying,column_namecharacter varying,new_sridinteger)
COMMENT FUNCTION updategeometrysrid(character varying,character varying,character varying,character varying,integer)
COMMENT FUNCTION updategeometrysrid(character varying,character varying,character varying,integer)
COMMENT FUNCTION updategeometrysrid(character varying,character varying,integer)
COMMENT FUNCTION validatetopology(character varying)
COMMENT FUNCTION validatetopology(toponame character varying)
COMMENT TYPE box2d
COMMENT TYPE box3d
COMMENT TYPE box3d_extent
COMMENT TYPE geography
COMMENT TYPE geometry
COMMENT TYPE geometry_dump
COMMENT TYPE geomval
COMMENT TYPE getfaceedges_returntype
COMMENT TYPE histogram
COMMENT TYPE raster
COMMENT TYPE reclassarg
COMMENT TYPE summarystats
COMMENT TYPE topogeometry
COMMENT TYPE validatetopology_returntype
CONSTRAINT geometry_columns_pk
CONSTRAINT layer_pkey
CONSTRAINT layer_schema_name_key
CONSTRAINT raster_columns_pk
CONSTRAINT raster_overviews_pk
CONSTRAINT spatial_ref_sys_pkey
CONSTRAINT topology_name_key
CONSTRAINT topology_pkey
DOMAIN topoelement
DOMAIN topoelementarray
DOMAIN topogeomelementarray
FKCONSTRAINT layer_topology_id_fkey
FUNCTION addauth(text)
FUNCTION addbbox(geometry)
FUNCTION addedge(character varying,public.geometry)
FUNCTION addface(character varying,public.geometry,boolean)
FUNCTION addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer)
FUNCTION addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer,boolean)
FUNCTION addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer)
FUNCTION addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer,boolean)
FUNCTION addgeometrycolumn(character varying,character varying,integer,character varying,integer)
FUNCTION addgeometrycolumn(character varying,character varying,integer,character varying,integer,boolean)
FUNCTION addnode(character varying,public.geometry)
FUNCTION addnode(character varying,public.geometry,boolean,boolean)
FUNCTION _add_overview_constraint(name,name,name,name,name,name,integer)
FUNCTION addoverviewconstraints(name,name,name,name,integer)
FUNCTION addoverviewconstraints(name,name,name,name,name,name,integer)
FUNCTION addpoint(geometry,geometry)
FUNCTION addpoint(geometry,geometry,integer)
FUNCTION addrastercolumn(character varying,character varying,character varying,character varying,integer,character varying[],boolean,boolean,double precision[],double precision,double precision,integer,integer,geometry)
FUNCTION addrastercolumn(character varying,character varying,character varying,integer,character varying[],boolean,boolean,double precision[],double precision,double precision,integer,integer,geometry)
FUNCTION addrastercolumn(character varying,character varying,integer,character varying[],boolean,boolean,double precision[],double precision,double precision,integer,integer,geometry)
FUNCTION _add_raster_constraint_alignment(name,name,name)
FUNCTION _add_raster_constraint_blocksize(name,name,name,text)
FUNCTION _add_raster_constraint_extent(name,name,name)
FUNCTION _add_raster_constraint(name,text)
FUNCTION _add_raster_constraint_nodata_values(name,name,name)
FUNCTION _add_raster_constraint_num_bands(name,name,name)
FUNCTION _add_raster_constraint_out_db(name,name,name)
FUNCTION _add_raster_constraint_pixel_types(name,name,name)
FUNCTION _add_raster_constraint_regular_blocking(name,name,name)
FUNCTION _add_raster_constraint_scale(name,name,name,character)
FUNCTION addrasterconstraints(name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION addrasterconstraints(name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION addrasterconstraints(name,name,name,text[])
FUNCTION addrasterconstraints(name,name,text[])
FUNCTION _add_raster_constraint_srid(name,name,name)
FUNCTION addtopogeometrycolumn(character varying,character varying,character varying,character varying,character varying)
FUNCTION addtopogeometrycolumn(character varying,character varying,character varying,character varying,character varying,integer)
FUNCTION addtosearchpath(character varying)
FUNCTION affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION area2d(geometry)
FUNCTION area(geometry)
FUNCTION asbinary(geometry)
FUNCTION asbinary(geometry,text)
FUNCTION asewkb(geometry)
FUNCTION asewkb(geometry,text)
FUNCTION asewkt(geometry)
FUNCTION _asgmledge(integer,integer,integer,public.geometry,regclass,text,integer,integer)
FUNCTION _asgmledge(integer,integer,integer,public.geometry,regclass,text,integer,integer,text)
FUNCTION _asgmledge(integer,integer,integer,public.geometry,regclass,text,integer,integer,text,integer)
FUNCTION _asgmledge(integer,integer,integer,public.geometry,text)
FUNCTION asgmledge(integer,integer,integer,public.geometry,text)
FUNCTION _asgmledge(integer,integer,integer,public.geometry,text,integer,integer)
FUNCTION _asgmlface(text,integer,regclass,text,integer,integer,text,integer)
FUNCTION asgml(geometry)
FUNCTION asgml(geometry,integer)
FUNCTION asgml(geometry,integer,integer)
FUNCTION _asgmlnode(integer,public.geometry,text)
FUNCTION asgmlnode(integer,public.geometry,text)
FUNCTION _asgmlnode(integer,public.geometry,text,integer,integer)
FUNCTION _asgmlnode(integer,public.geometry,text,integer,integer,text)
FUNCTION _asgmlnode(integer,public.geometry,text,integer,integer,text,integer)
FUNCTION asgml(topogeometry)
FUNCTION asgml(topogeometry,regclass)
FUNCTION asgml(topogeometry,regclass,text)
FUNCTION asgml(topogeometry,text)
FUNCTION asgml(topogeometry,text,integer,integer)
FUNCTION asgml(topogeometry,text,integer,integer,regclass)
FUNCTION asgml(topogeometry,text,integer,integer,regclass,text)
FUNCTION asgml(topogeometry,text,integer,integer,regclass,text,integer)
FUNCTION ashexewkb(geometry)
FUNCTION ashexewkb(geometry,text)
FUNCTION askml(geometry)
FUNCTION askml(geometry,integer)
FUNCTION askml(geometry,integer,integer)
FUNCTION askml(integer,geometry,integer)
FUNCTION assvg(geometry)
FUNCTION assvg(geometry,integer)
FUNCTION assvg(geometry,integer,integer)
FUNCTION astext(geometry)
FUNCTION asukml(geometry)
FUNCTION asukml(geometry,integer)
FUNCTION asukml(geometry,integer,integer)
FUNCTION azimuth(geometry,geometry)
FUNCTION bdmpolyfromtext(text,integer)
FUNCTION bdpolyfromtext(text,integer)
FUNCTION boundary(geometry)
FUNCTION box2d(box3d)
FUNCTION box2d(box3d_extent)
FUNCTION box2d_contain(box2d,box2d)
FUNCTION box2d_contained(box2d,box2d)
FUNCTION box2df_in(cstring)
FUNCTION box2df_out(box2df)
FUNCTION box2d(geometry)
FUNCTION box2d_in(cstring)
FUNCTION box2d_intersects(box2d,box2d)
FUNCTION box2d_left(box2d,box2d)
FUNCTION box2d_out(box2d)
FUNCTION box2d_overlap(box2d,box2d)
FUNCTION box2d_overleft(box2d,box2d)
FUNCTION box2d_overright(box2d,box2d)
FUNCTION box2d(raster)
FUNCTION box2d_right(box2d,box2d)
FUNCTION box2d_same(box2d,box2d)
FUNCTION box3d(box2d)
FUNCTION box3d_extent(box3d_extent)
FUNCTION box3d_extent_in(cstring)
FUNCTION box3d_extent_out(box3d_extent)
FUNCTION box3d(geometry)
FUNCTION box3d_in(cstring)
FUNCTION box3d_out(box3d)
FUNCTION box3d(raster)
FUNCTION box3dtobox(box3d)
FUNCTION box(box3d)
FUNCTION box(geometry)
FUNCTION buffer(geometry,double precision)
FUNCTION buffer(geometry,double precision,integer)
FUNCTION buildarea(geometry)
FUNCTION build_histogram2d(histogram2d,text,text)
FUNCTION build_histogram2d(histogram2d,text,text,text)
FUNCTION bytea(geography)
FUNCTION bytea(geometry)
FUNCTION bytea(raster)
FUNCTION cache_bbox()
FUNCTION centroid(geometry)
FUNCTION checkauth(text,text)
FUNCTION checkauth(text,text,text)
FUNCTION checkauthtrigger()
FUNCTION chip_in(cstring)
FUNCTION chip_out(chip)
FUNCTION collect_garray(geometry[])
FUNCTION collect(geometry,geometry)
FUNCTION collector(geometry,geometry)
FUNCTION combine_bbox(box2d,geometry)
FUNCTION combine_bbox(box3d_extent,geometry)
FUNCTION combine_bbox(box3d,geometry)
FUNCTION compression(chip)
FUNCTION contains(geometry,geometry)
FUNCTION convexhull(geometry)
FUNCTION copytopology(character varying,character varying)
FUNCTION create_histogram2d(box2d,integer)
FUNCTION createtopogeom(character varying,integer,integer)
FUNCTION createtopogeom(character varying,integer,integer,topoelementarray)
FUNCTION createtopology(character varying)
FUNCTION createtopology(character varying,integer)
FUNCTION createtopology(character varying,integer,double precision)
FUNCTION createtopology(character varying,integer,double precision,boolean)
FUNCTION crosses(geometry,geometry)
FUNCTION datatype(chip)
FUNCTION difference(geometry,geometry)
FUNCTION dimension(geometry)
FUNCTION disablelongtransactions()
FUNCTION disjoint(geometry,geometry)
FUNCTION distance(geometry,geometry)
FUNCTION distance_sphere(geometry,geometry)
FUNCTION distance_spheroid(geometry,geometry,spheroid)
FUNCTION dropbbox(geometry)
FUNCTION dropgeometrycolumn(character varying,character varying)
FUNCTION dropgeometrycolumn(character varying,character varying,character varying)
FUNCTION dropgeometrycolumn(character varying,character varying,character varying,character varying)
FUNCTION dropgeometrytable(character varying)
FUNCTION dropgeometrytable(character varying,character varying)
FUNCTION dropgeometrytable(character varying,character varying,character varying)
FUNCTION _drop_overview_constraint(name,name,name)
FUNCTION dropoverviewconstraints(name,name)
FUNCTION dropoverviewconstraints(name,name,name)
FUNCTION droprastercolumn(character varying,character varying)
FUNCTION droprastercolumn(character varying,character varying,character varying)
FUNCTION droprastercolumn(character varying,character varying,character varying,character varying)
FUNCTION _drop_raster_constraint_alignment(name,name,name)
FUNCTION _drop_raster_constraint_blocksize(name,name,name,text)
FUNCTION _drop_raster_constraint_extent(name,name,name)
FUNCTION _drop_raster_constraint(name,name,name)
FUNCTION _drop_raster_constraint_nodata_values(name,name,name)
FUNCTION _drop_raster_constraint_num_bands(name,name,name)
FUNCTION _drop_raster_constraint_out_db(name,name,name)
FUNCTION _drop_raster_constraint_pixel_types(name,name,name)
FUNCTION _drop_raster_constraint_regular_blocking(name,name,name)
FUNCTION _drop_raster_constraint_scale(name,name,name,character)
FUNCTION droprasterconstraints(name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION droprasterconstraints(name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION droprasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION droprasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
FUNCTION droprasterconstraints(name,name,name,text[])
FUNCTION droprasterconstraints(name,name,text[])
FUNCTION _drop_raster_constraint_srid(name,name,name)
FUNCTION droprastertable(character varying)
FUNCTION droprastertable(character varying,character varying)
FUNCTION droprastertable(character varying,character varying,character varying)
FUNCTION droptopogeometrycolumn(character varying,character varying,character varying)
FUNCTION droptopology(character varying)
FUNCTION dumpaswktpolygons(raster,integer)
FUNCTION dump(geometry)
FUNCTION dumprings(geometry)
FUNCTION enablelongtransactions()
FUNCTION endpoint(geometry)
FUNCTION envelope(geometry)
FUNCTION envelope(topogeometry)
FUNCTION equals(geometry,geometry)
FUNCTION equals(topogeometry,topogeometry)
FUNCTION estimated_extent(text,text)
FUNCTION estimated_extent(text,text,text)
FUNCTION estimate_histogram2d(histogram2d,box2d)
FUNCTION expand(box2d,double precision)
FUNCTION expand(box3d,double precision)
FUNCTION expand(geometry,double precision)
FUNCTION explode_histogram2d(histogram2d,text)
FUNCTION exteriorring(geometry)
FUNCTION factor(chip)
FUNCTION find_extent(text,text)
FUNCTION find_extent(text,text,text)
FUNCTION find_srid(character varying,character varying,character varying)
FUNCTION fix_geometry_columns()
FUNCTION force_2d(geometry)
FUNCTION force_3d(geometry)
FUNCTION force_3dm(geometry)
FUNCTION force_3dz(geometry)
FUNCTION force_4d(geometry)
FUNCTION force_collection(geometry)
FUNCTION forcerhr(geometry)
FUNCTION geography_analyze(internal)
FUNCTION geography(bytea)
FUNCTION geography_cmp(geography,geography)
FUNCTION geography_eq(geography,geography)
FUNCTION geography_ge(geography,geography)
FUNCTION geography(geography,integer,boolean)
FUNCTION geography(geometry)
FUNCTION geography_gist_compress(internal)
FUNCTION geography_gist_consistent(internal,geography,integer)
FUNCTION geography_gist_consistent(internal,geometry,integer)
FUNCTION geography_gist_decompress(internal)
FUNCTION geography_gist_join_selectivity(internal,oid,internal,smallint)
FUNCTION geography_gist_penalty(internal,internal,internal)
FUNCTION geography_gist_picksplit(internal,internal)
FUNCTION geography_gist_same(box2d,box2d,internal)
FUNCTION geography_gist_selectivity(internal,oid,internal,integer)
FUNCTION geography_gist_union(bytea,internal)
FUNCTION geography_gt(geography,geography)
FUNCTION geography_in(cstring,oid,integer)
FUNCTION geography_le(geography,geography)
FUNCTION geography_lt(geography,geography)
FUNCTION geography_out(geography)
FUNCTION geography_overlaps(geography,geography)
FUNCTION geography_recv(internal,oid,integer)
FUNCTION geography_send(geography)
FUNCTION geography_typmod_dims(integer)
FUNCTION geography_typmod_in(cstring[])
FUNCTION geography_typmod_out(integer)
FUNCTION geography_typmod_srid(integer)
FUNCTION geography_typmod_type(integer)
FUNCTION geom_accum(geometry[],geometry)
FUNCTION geomcollfromtext(text)
FUNCTION geomcollfromtext(text,integer)
FUNCTION geomcollfromwkb(bytea)
FUNCTION geomcollfromwkb(bytea,integer)
FUNCTION geometry_above(geometry,geometry)
FUNCTION geometry_analyze(internal)
FUNCTION geometry_below(geometry,geometry)
FUNCTION geometry(box2d)
FUNCTION geometry(box3d)
FUNCTION geometry(box3d_extent)
FUNCTION geometry(bytea)
FUNCTION geometry(chip)
FUNCTION geometry_cmp(geometry,geometry)
FUNCTION geometry_contained(geometry,geometry)
FUNCTION geometry_contain(geometry,geometry)
FUNCTION geometry_contains(geometry,geometry)
FUNCTION geometry_distance_box(geometry,geometry)
FUNCTION geometry_distance_centroid(geometry,geometry)
FUNCTION geometry_eq(geometry,geometry)
FUNCTION geometryfromtext(text)
FUNCTION geometryfromtext(text,integer)
FUNCTION geometry_ge(geometry,geometry)
FUNCTION geometry(geography)
FUNCTION geometry(geometry,integer,boolean)
FUNCTION geometry_gist_compress_2d(internal)
FUNCTION geometry_gist_compress_nd(internal)
FUNCTION geometry_gist_consistent_2d(internal,geometry,integer)
FUNCTION geometry_gist_consistent_nd(internal,geometry,integer)
FUNCTION geometry_gist_decompress_2d(internal)
FUNCTION geometry_gist_decompress_nd(internal)
FUNCTION geometry_gist_distance_2d(internal,geometry,integer)
FUNCTION geometry_gist_joinsel_2d(internal,oid,internal,smallint)
FUNCTION geometry_gist_joinsel(internal,oid,internal,smallint)
FUNCTION geometry_gist_penalty_2d(internal,internal,internal)
FUNCTION geometry_gist_penalty_nd(internal,internal,internal)
FUNCTION geometry_gist_picksplit_2d(internal,internal)
FUNCTION geometry_gist_picksplit_nd(internal,internal)
FUNCTION geometry_gist_same_2d(geometry,geometry,internal)
FUNCTION geometry_gist_same_nd(geometry,geometry,internal)
FUNCTION geometry_gist_sel_2d(internal,oid,internal,integer)
FUNCTION geometry_gist_sel(internal,oid,internal,integer)
FUNCTION geometry_gist_union_2d(bytea,internal)
FUNCTION geometry_gist_union_nd(bytea,internal)
FUNCTION geometry_gt(geometry,geometry)
FUNCTION geometry_in(cstring)
FUNCTION geometry_left(geometry,geometry)
FUNCTION geometry_le(geometry,geometry)
FUNCTION geometry_lt(geometry,geometry)
FUNCTION geometryn(geometry,integer)
FUNCTION geometry_out(geometry)
FUNCTION geometry_overabove(geometry,geometry)
FUNCTION geometry_overbelow(geometry,geometry)
FUNCTION geometry_overlap(geometry,geometry)
FUNCTION geometry_overlaps(geometry,geometry)
FUNCTION geometry_overlaps_nd(geometry,geometry)
FUNCTION geometry_overleft(geometry,geometry)
FUNCTION geometry_overright(geometry,geometry)
FUNCTION geometry_raster_contain(geometry,raster)
FUNCTION geometry_raster_overlap(geometry,raster)
FUNCTION geometry_recv(internal)
FUNCTION geometry_right(geometry,geometry)
FUNCTION geometry_samebox(geometry,geometry)
FUNCTION geometry_same(geometry,geometry)
FUNCTION geometry_send(geometry)
FUNCTION geometry(text)
FUNCTION geometry(topogeometry)
FUNCTION geometrytype(geography)
FUNCTION geometrytype(geometry)
FUNCTION geometrytype(topogeometry)
FUNCTION geometry_typmod_in(cstring[])
FUNCTION geometry_typmod_out(integer)
FUNCTION geometry_within(geometry,geometry)
FUNCTION geomfromewkb(bytea)
FUNCTION geomfromewkt(text)
FUNCTION geomfromtext(text)
FUNCTION geomfromtext(text,integer)
FUNCTION geomfromwkb(bytea)
FUNCTION geomfromwkb(bytea,integer)
FUNCTION geomunion(geometry,geometry)
FUNCTION geosnoop(geometry)
FUNCTION getbbox(geometry)
FUNCTION getedgebypoint(character varying,public.geometry,double precision)
FUNCTION getfacebypoint(character varying,public.geometry,double precision)
FUNCTION getnodebypoint(character varying,public.geometry,double precision)
FUNCTION get_proj4_from_srid(integer)
FUNCTION getringedges(character varying,integer,integer)
FUNCTION getsrid(geometry)
FUNCTION gettopogeomelementarray(character varying,integer,integer)
FUNCTION gettopogeomelementarray(topogeometry)
FUNCTION gettopogeomelements(character varying,integer,integer)
FUNCTION gettopogeomelements(topogeometry)
FUNCTION gettopologyid(character varying)
FUNCTION gettopologyname(integer)
FUNCTION gettransactionid()
FUNCTION gidx_in(cstring)
FUNCTION gidx_out(gidx)
FUNCTION hasbbox(geometry)
FUNCTION height(chip)
FUNCTION histogram2d_in(cstring)
FUNCTION histogram2d_out(histogram2d)
FUNCTION interiorringn(geometry,integer)
FUNCTION intersection(geometry,geometry)
FUNCTION intersects(geometry,geometry)
FUNCTION intersects(topogeometry,topogeometry)
FUNCTION isclosed(geometry)
FUNCTION isempty(geometry)
FUNCTION isring(geometry)
FUNCTION issimple(geometry)
FUNCTION isvalid(geometry)
FUNCTION jtsnoop(geometry)
FUNCTION layertrigger()
FUNCTION length2d(geometry)
FUNCTION length2d_spheroid(geometry,spheroid)
FUNCTION length3d(geometry)
FUNCTION length3d_spheroid(geometry,spheroid)
FUNCTION length(geometry)
FUNCTION length_spheroid(geometry,spheroid)
FUNCTION linefrommultipoint(geometry)
FUNCTION linefromtext(text)
FUNCTION linefromtext(text,integer)
FUNCTION linefromwkb(bytea)
FUNCTION linefromwkb(bytea,integer)
FUNCTION line_interpolate_point(geometry,double precision)
FUNCTION line_locate_point(geometry,geometry)
FUNCTION linemerge(geometry)
FUNCTION linestringfromtext(text)
FUNCTION linestringfromtext(text,integer)
FUNCTION linestringfromwkb(bytea)
FUNCTION linestringfromwkb(bytea,integer)
FUNCTION line_substring(geometry,double precision,double precision)
FUNCTION locate_along_measure(geometry,double precision)
FUNCTION locate_between_measures(geometry,double precision,double precision)
FUNCTION lockrow(text,text,text)
FUNCTION lockrow(text,text,text,text)
FUNCTION lockrow(text,text,text,text,timestamp without time zone)
FUNCTION lockrow(text,text,text,timestamp without time zone)
FUNCTION longtransactionsenabled()
FUNCTION lwgeom_gist_compress(internal)
FUNCTION lwgeom_gist_consistent(internal,geometry,integer)
FUNCTION lwgeom_gist_decompress(internal)
FUNCTION lwgeom_gist_penalty(internal,internal,internal)
FUNCTION lwgeom_gist_picksplit(internal,internal)
FUNCTION lwgeom_gist_same(box2d,box2d,internal)
FUNCTION lwgeom_gist_union(bytea,internal)
FUNCTION makebox2d(geometry,geometry)
FUNCTION makebox3d(geometry,geometry)
FUNCTION makeline_garray(geometry[])
FUNCTION makeline(geometry,geometry)
FUNCTION makepoint(double precision,double precision)
FUNCTION makepoint(double precision,double precision,double precision)
FUNCTION makepoint(double precision,double precision,double precision,double precision)
FUNCTION makepointm(double precision,double precision,double precision)
FUNCTION makepolygon(geometry)
FUNCTION makepolygon(geometry,geometry[])
FUNCTION mapalgebra4unionfinal1(rastexpr)
FUNCTION mapalgebra4unionfinal3(rastexpr)
FUNCTION mapalgebra4unionstate(raster,raster,text,text,text,double precision,text,text,text,double precision)
FUNCTION mapalgebra4unionstate(rastexpr,raster)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text,text)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text,text,text)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text,text,text,double precision)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text,text,text,double precision,text,text,text,double precision)
FUNCTION mapalgebra4unionstate(rastexpr,raster,text,text,text,double precision,text,text,text,double precision,text,text,text,double precision)
FUNCTION max_distance(geometry,geometry)
FUNCTION mem_size(geometry)
FUNCTION m(geometry)
FUNCTION mlinefromtext(text)
FUNCTION mlinefromtext(text,integer)
FUNCTION mlinefromwkb(bytea)
FUNCTION mlinefromwkb(bytea,integer)
FUNCTION mpointfromtext(text)
FUNCTION mpointfromtext(text,integer)
FUNCTION mpointfromwkb(bytea)
FUNCTION mpointfromwkb(bytea,integer)
FUNCTION mpolyfromtext(text)
FUNCTION mpolyfromtext(text,integer)
FUNCTION mpolyfromwkb(bytea)
FUNCTION mpolyfromwkb(bytea,integer)
FUNCTION multi(geometry)
FUNCTION multilinefromwkb(bytea)
FUNCTION multilinefromwkb(bytea,integer)
FUNCTION multilinestringfromtext(text)
FUNCTION multilinestringfromtext(text,integer)
FUNCTION multipointfromtext(text)
FUNCTION multipointfromtext(text,integer)
FUNCTION multipointfromwkb(bytea)
FUNCTION multipointfromwkb(bytea,integer)
FUNCTION multipolyfromwkb(bytea)
FUNCTION multipolyfromwkb(bytea,integer)
FUNCTION multipolygonfromtext(text)
FUNCTION multipolygonfromtext(text,integer)
FUNCTION ndims(geometry)
FUNCTION noop(geometry)
FUNCTION npoints(geometry)
FUNCTION nrings(geometry)
FUNCTION numgeometries(geometry)
FUNCTION numinteriorring(geometry)
FUNCTION numinteriorrings(geometry)
FUNCTION numpoints(geometry)
FUNCTION overlaps(geometry,geometry)
FUNCTION _overview_constraint_info(name,name,name)
FUNCTION _overview_constraint(raster,integer,name,name,name)
FUNCTION perimeter2d(geometry)
FUNCTION perimeter3d(geometry)
FUNCTION perimeter(geometry)
FUNCTION pgis_abs_in(cstring)
FUNCTION pgis_abs_out(pgis_abs)
FUNCTION pgis_geometry_accum_finalfn(pgis_abs)
FUNCTION pgis_geometry_accum_transfn(pgis_abs,geometry)
FUNCTION pgis_geometry_collect_finalfn(pgis_abs)
FUNCTION pgis_geometry_makeline_finalfn(pgis_abs)
FUNCTION pgis_geometry_polygonize_finalfn(pgis_abs)
FUNCTION pgis_geometry_union_finalfn(pgis_abs)
FUNCTION pointfromtext(text)
FUNCTION pointfromtext(text,integer)
FUNCTION pointfromwkb(bytea)
FUNCTION pointfromwkb(bytea,integer)
FUNCTION point_inside_circle(geometry,double precision,double precision,double precision)
FUNCTION pointn(geometry,integer)
FUNCTION pointonsurface(geometry)
FUNCTION polyfromtext(text)
FUNCTION polyfromtext(text,integer)
FUNCTION polyfromwkb(bytea)
FUNCTION polyfromwkb(bytea,integer)
FUNCTION polygonfromtext(text)
FUNCTION polygonfromtext(text,integer)
FUNCTION polygonfromwkb(bytea)
FUNCTION polygonfromwkb(bytea,integer)
FUNCTION polygonize(character varying)
FUNCTION polygonize_garray(geometry[])
FUNCTION populate_geometry_columns()
FUNCTION populate_geometry_columns(boolean)
FUNCTION populate_geometry_columns(oid)
FUNCTION populate_geometry_columns(oid,boolean)
FUNCTION postgis_addbbox(geometry)
FUNCTION postgis_cache_bbox()
FUNCTION postgis_constraint_dims(text,text,text)
FUNCTION postgis_constraint_srid(text,text,text)
FUNCTION postgis_constraint_type(text,text,text)
FUNCTION postgis_dropbbox(geometry)
FUNCTION postgis_full_version()
FUNCTION postgis_gdal_version()
FUNCTION postgis_geos_version()
FUNCTION postgis_getbbox(geometry)
FUNCTION postgis_gist_joinsel(internal,oid,internal,smallint)
FUNCTION postgis_gist_sel(internal,oid,internal,integer)
FUNCTION postgis_hasbbox(geometry)
FUNCTION postgis_jts_version()
FUNCTION postgis_lib_build_date()
FUNCTION postgis_libjson_version()
FUNCTION postgis_lib_version()
FUNCTION postgis_libxml_version()
FUNCTION postgis_noop(geometry)
FUNCTION postgis_proj_version()
FUNCTION postgis_raster_lib_build_date()
FUNCTION postgis_raster_lib_version()
FUNCTION postgis_raster_scripts_installed()
FUNCTION postgis_scripts_build_date()
FUNCTION postgis_scripts_installed()
FUNCTION postgis_scripts_released()
FUNCTION postgis_topology_scripts_installed()
FUNCTION postgis_transform_geometry(geometry,text,text,integer)
FUNCTION postgis_type_name(character varying,integer,boolean)
FUNCTION postgis_typmod_dims(integer)
FUNCTION postgis_typmod_srid(integer)
FUNCTION postgis_typmod_type(integer)
FUNCTION postgis_uses_stats()
FUNCTION postgis_version()
FUNCTION probe_geometry_columns()
FUNCTION raster_above(raster,raster)
FUNCTION raster_below(raster,raster)
FUNCTION _raster_constraint_info_alignment(name,name,name)
FUNCTION _raster_constraint_info_blocksize(name,name,name,text)
FUNCTION _raster_constraint_info_extent(name,name,name)
FUNCTION _raster_constraint_info_nodata_values(name,name,name)
FUNCTION _raster_constraint_info_num_bands(name,name,name)
FUNCTION _raster_constraint_info_out_db(name,name,name)
FUNCTION _raster_constraint_info_pixel_types(name,name,name)
FUNCTION _raster_constraint_info_regular_blocking(name,name,name)
FUNCTION _raster_constraint_info_scale(name,name,name,character)
FUNCTION _raster_constraint_info_srid(name,name,name)
FUNCTION _raster_constraint_nodata_values(raster)
FUNCTION _raster_constraint_out_db(raster)
FUNCTION _raster_constraint_pixel_types(raster)
FUNCTION raster_contained(raster,raster)
FUNCTION raster_contain(raster,raster)
FUNCTION raster_geometry_contain(raster,geometry)
FUNCTION raster_geometry_overlap(raster,geometry)
FUNCTION raster_in(cstring)
FUNCTION raster_left(raster,raster)
FUNCTION raster_out(raster)
FUNCTION raster_overabove(raster,raster)
FUNCTION raster_overbelow(raster,raster)
FUNCTION raster_overlap(raster,raster)
FUNCTION raster_overleft(raster,raster)
FUNCTION raster_overright(raster,raster)
FUNCTION raster_right(raster,raster)
FUNCTION raster_same(raster,raster)
FUNCTION relate(geometry,geometry)
FUNCTION relate(geometry,geometry,text)
FUNCTION relationtrigger()
FUNCTION removepoint(geometry,integer)
FUNCTION rename_geometry_table_constraints()
FUNCTION _rename_raster_tables()
FUNCTION reverse(geometry)
FUNCTION rotate(geometry,double precision)
FUNCTION rotatex(geometry,double precision)
FUNCTION rotatey(geometry,double precision)
FUNCTION rotatez(geometry,double precision)
FUNCTION scale(geometry,double precision,double precision)
FUNCTION scale(geometry,double precision,double precision,double precision)
FUNCTION se_envelopesintersect(geometry,geometry)
FUNCTION segmentize(geometry,double precision)
FUNCTION se_is3d(geometry)
FUNCTION se_ismeasured(geometry)
FUNCTION se_locatealong(geometry,double precision)
FUNCTION se_locatebetween(geometry,double precision,double precision)
FUNCTION se_m(geometry)
FUNCTION setfactor(chip,real)
FUNCTION setpoint(geometry,integer,geometry)
FUNCTION setsrid(chip,integer)
FUNCTION setsrid(geometry,integer)
FUNCTION se_z(geometry)
FUNCTION shift_longitude(geometry)
FUNCTION simplify(geometry,double precision)
FUNCTION snaptogrid(geometry,double precision)
FUNCTION snaptogrid(geometry,double precision,double precision)
FUNCTION snaptogrid(geometry,double precision,double precision,double precision,double precision)
FUNCTION snaptogrid(geometry,geometry,double precision,double precision,double precision,double precision)
FUNCTION spheroid_in(cstring)
FUNCTION spheroid_out(spheroid)
FUNCTION srid(chip)
FUNCTION srid(geometry)
FUNCTION st_3dclosestpoint(geometry,geometry)
FUNCTION _st_3ddfullywithin(geometry,geometry,double precision)
FUNCTION st_3ddfullywithin(geometry,geometry,double precision)
FUNCTION st_3ddistance(geometry,geometry)
FUNCTION _st_3ddwithin(geometry,geometry,double precision)
FUNCTION st_3ddwithin(geometry,geometry,double precision)
FUNCTION st_3dintersects(geometry,geometry)
FUNCTION st_3dlength(geometry)
FUNCTION st_3dlength_spheroid(geometry,spheroid)
FUNCTION st_3dlongestline(geometry,geometry)
FUNCTION st_3dmakebox(geometry,geometry)
FUNCTION ST_3DMakeBox(geometry,geometry)
FUNCTION st_3dmaxdistance(geometry,geometry)
FUNCTION st_3dperimeter(geometry)
FUNCTION ST_3DPerimeter(geometry)
FUNCTION st_3dshortestline(geometry,geometry)
FUNCTION st_above(raster,raster)
FUNCTION st_addband(raster,integer,text)
FUNCTION st_addband(raster,integer,text,double precision)
FUNCTION st_addband(raster,integer,text,double precision,double precision)
FUNCTION st_addband(raster,raster)
FUNCTION st_addband(raster,raster,integer)
FUNCTION st_addband(raster,raster[],integer)
FUNCTION st_addband(raster,raster,integer,integer)
FUNCTION st_addband(raster,text)
FUNCTION st_addband(raster,text,double precision)
FUNCTION st_addband(raster,text,double precision,double precision)
FUNCTION st_addbbox(geometry)
FUNCTION st_addedgemodface(character varying,integer,integer,public.geometry)
FUNCTION st_addedgenewfaces(character varying,integer,integer,public.geometry)
FUNCTION st_addisoedge(character varying,integer,integer,public.geometry)
FUNCTION st_addisonode(character varying,integer,public.geometry)
FUNCTION st_addmeasure(geometry,double precision,double precision)
FUNCTION st_addpoint(geometry,geometry)
FUNCTION st_addpoint(geometry,geometry,integer)
FUNCTION st_affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_affine(geometry,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_approxcount(raster,boolean,double precision)
FUNCTION st_approxcount(raster,double precision)
FUNCTION st_approxcount(raster,integer,boolean,double precision)
FUNCTION st_approxcount(raster,integer,double precision)
FUNCTION st_approxcount(text,text,boolean,double precision)
FUNCTION st_approxcount(text,text,double precision)
FUNCTION st_approxcount(text,text,integer,boolean,double precision)
FUNCTION st_approxcount(text,text,integer,double precision)
FUNCTION st_approxhistogram(raster,double precision)
FUNCTION st_approxhistogram(raster,integer,boolean,double precision,integer,boolean)
FUNCTION st_approxhistogram(raster,integer,boolean,double precision,integer,double precision[],boolean)
FUNCTION st_approxhistogram(raster,integer,double precision)
FUNCTION st_approxhistogram(raster,integer,double precision,integer,boolean)
FUNCTION st_approxhistogram(raster,integer,double precision,integer,double precision[],boolean)
FUNCTION st_approxhistogram(text,text,double precision)
FUNCTION st_approxhistogram(text,text,integer,boolean,double precision,integer,boolean)
FUNCTION st_approxhistogram(text,text,integer,boolean,double precision,integer,double precision[],boolean)
FUNCTION st_approxhistogram(text,text,integer,double precision)
FUNCTION st_approxhistogram(text,text,integer,double precision,integer,boolean)
FUNCTION st_approxhistogram(text,text,integer,double precision,integer,double precision[],boolean)
FUNCTION st_approxquantile(raster,boolean,double precision)
FUNCTION st_approxquantile(raster,double precision)
FUNCTION st_approxquantile(raster,double precision[])
FUNCTION st_approxquantile(raster,double precision,double precision)
FUNCTION st_approxquantile(raster,double precision,double precision[])
FUNCTION st_approxquantile(raster,integer,boolean,double precision,double precision)
FUNCTION st_approxquantile(raster,integer,boolean,double precision,double precision[])
FUNCTION st_approxquantile(raster,integer,double precision,double precision)
FUNCTION st_approxquantile(raster,integer,double precision,double precision[])
FUNCTION st_approxquantile(text,text,boolean,double precision)
FUNCTION st_approxquantile(text,text,double precision)
FUNCTION st_approxquantile(text,text,double precision[])
FUNCTION st_approxquantile(text,text,double precision,double precision)
FUNCTION st_approxquantile(text,text,double precision,double precision[])
FUNCTION st_approxquantile(text,text,integer,boolean,double precision,double precision)
FUNCTION st_approxquantile(text,text,integer,boolean,double precision,double precision[])
FUNCTION st_approxquantile(text,text,integer,double precision,double precision)
FUNCTION st_approxquantile(text,text,integer,double precision,double precision[])
FUNCTION st_approxsummarystats(raster,boolean,double precision)
FUNCTION st_approxsummarystats(raster,double precision)
FUNCTION st_approxsummarystats(raster,integer,boolean,double precision)
FUNCTION st_approxsummarystats(raster,integer,double precision)
FUNCTION st_approxsummarystats(text,text,boolean)
FUNCTION st_approxsummarystats(text,text,double precision)
FUNCTION st_approxsummarystats(text,text,integer,boolean,double precision)
FUNCTION st_approxsummarystats(text,text,integer,double precision)
FUNCTION st_area2d(geometry)
FUNCTION st_area(geography)
FUNCTION st_area(geography,boolean)
FUNCTION st_area(geometry)
FUNCTION st_area(text)
FUNCTION startpoint(geometry)
FUNCTION st_asbinary(geography)
FUNCTION st_asbinary(geography,text)
FUNCTION st_asbinary(geometry)
FUNCTION st_asbinary(geometry,text)
FUNCTION st_asbinary(raster)
FUNCTION st_asbinary(text)
FUNCTION st_asencodedpolyline(geometry)
FUNCTION st_asencodedpolyline(geometry,integer)
FUNCTION st_asewkb(geometry)
FUNCTION st_asewkb(geometry,text)
FUNCTION st_asewkt(geography)
FUNCTION st_asewkt(geometry)
FUNCTION st_asewkt(text)
FUNCTION st_asgdalraster(raster,text,text[],integer)
FUNCTION st_asgeojson(geography)
FUNCTION st_asgeojson(geography,integer)
FUNCTION st_asgeojson(geography,integer,integer)
FUNCTION st_asgeojson(geometry)
FUNCTION st_asgeojson(geometry,integer)
FUNCTION st_asgeojson(geometry,integer,integer)
FUNCTION st_asgeojson(integer,geography)
FUNCTION st_asgeojson(integer,geography,integer)
FUNCTION _st_asgeojson(integer,geography,integer,integer)
FUNCTION st_asgeojson(integer,geography,integer,integer)
FUNCTION st_asgeojson(integer,geometry)
FUNCTION st_asgeojson(integer,geometry,integer)
FUNCTION _st_asgeojson(integer,geometry,integer,integer)
FUNCTION st_asgeojson(integer,geometry,integer,integer)
FUNCTION st_asgeojson(text)
FUNCTION st_asgml(geography)
FUNCTION st_asgml(geography,integer)
FUNCTION st_asgml(geography,integer,integer)
FUNCTION st_asgml(geometry)
FUNCTION st_asgml(geometry,integer)
FUNCTION st_asgml(geometry,integer,integer)
FUNCTION st_asgml(integer,geography)
FUNCTION st_asgml(integer,geography,integer)
FUNCTION _st_asgml(integer,geography,integer,integer)
FUNCTION st_asgml(integer,geography,integer,integer)
FUNCTION _st_asgml(integer,geography,integer,integer,text)
FUNCTION st_asgml(integer,geography,integer,integer,text)
FUNCTION st_asgml(integer,geometry)
FUNCTION _st_asgml(integer,geometry,integer)
FUNCTION st_asgml(integer,geometry,integer)
FUNCTION _st_asgml(integer,geometry,integer,integer)
FUNCTION st_asgml(integer,geometry,integer,integer)
FUNCTION _st_asgml(integer,geometry,integer,integer,text)
FUNCTION st_asgml(integer,geometry,integer,integer,text)
FUNCTION st_asgml(text)
FUNCTION st_ashexewkb(geometry)
FUNCTION st_ashexewkb(geometry,text)
FUNCTION st_asjpeg(raster,integer,integer)
FUNCTION st_asjpeg(raster,integer[],integer)
FUNCTION st_asjpeg(raster,integer,text[])
FUNCTION st_asjpeg(raster,integer[],text[])
FUNCTION st_asjpeg(raster,text[])
FUNCTION st_askml(geography)
FUNCTION st_askml(geography,integer)
FUNCTION st_askml(geometry)
FUNCTION st_askml(geometry,integer)
FUNCTION st_askml(integer,geography)
FUNCTION _st_askml(integer,geography,integer)
FUNCTION st_askml(integer,geography,integer)
FUNCTION _st_askml(integer,geography,integer,text)
FUNCTION st_askml(integer,geography,integer,text)
FUNCTION st_askml(integer,geometry)
FUNCTION _st_askml(integer,geometry,integer)
FUNCTION st_askml(integer,geometry,integer)
FUNCTION _st_askml(integer,geometry,integer,text)
FUNCTION st_askml(integer,geometry,integer,text)
FUNCTION st_askml(text)
FUNCTION st_aslatlontext(geometry)
FUNCTION st_aslatlontext(geometry,text)
FUNCTION _st_aspect4ma(double precision[],text,text[])
FUNCTION st_aspect(raster,integer,text)
FUNCTION st_aspect(raster,integer,text,boolean)
FUNCTION st_aspect(raster,integer,text,text,boolean)
FUNCTION st_aspng(raster,integer,integer)
FUNCTION st_aspng(raster,integer[],integer)
FUNCTION st_aspng(raster,integer,text[])
FUNCTION st_aspng(raster,integer[],text[])
FUNCTION st_aspng(raster,text[])
FUNCTION st_asraster(geometry,double precision,double precision,double precision,double precision,text,double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,double precision,double precision,double precision,double precision,text[],double precision[],double precision[],double precision,double precision,boolean)
FUNCTION _st_asraster(geometry,double precision,double precision,integer,integer,text[],double precision[],double precision[],double precision,double precision,double precision,double precision,double precision,double precision,boolean)
FUNCTION _st_asraster(geometry,double precision,double precision,integer,integer,text[],double precision[],double precision[],double precision,double precision,double precision,double precision,double precision,double precision,touched boolean)
FUNCTION st_asraster(geometry,double precision,double precision,text,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_asraster(geometry,double precision,double precision,text,double precision,double precision,double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,double precision,double precision,text[],double precision[],double precision[],double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,integer,integer,double precision,double precision,text,double precision,double precision,double precision,double precision)
FUNCTION st_asraster(geometry,integer,integer,double precision,double precision,text[],double precision[],double precision[],double precision,double precision)
FUNCTION st_asraster(geometry,integer,integer,double precision,double precision,text,double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,integer,integer,double precision,double precision,text[],double precision[],double precision[],double precision,double precision,boolean)
FUNCTION st_asraster(geometry,integer,integer,text,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_asraster(geometry,integer,integer,text[],double precision[],double precision[],double precision,double precision,double precision,double precision)
FUNCTION st_asraster(geometry,integer,integer,text,double precision,double precision,double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,integer,integer,text[],double precision[],double precision[],double precision,double precision,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,raster,text,double precision,double precision)
FUNCTION st_asraster(geometry,raster,text,double precision,double precision,boolean)
FUNCTION st_asraster(geometry,raster,text[],double precision[],double precision[],boolean)
FUNCTION st_assvg(geography)
FUNCTION st_assvg(geography,integer)
FUNCTION st_assvg(geography,integer,integer)
FUNCTION st_assvg(geometry)
FUNCTION st_assvg(geometry,integer)
FUNCTION st_assvg(geometry,integer,integer)
FUNCTION st_assvg(text)
FUNCTION st_astext(geography)
FUNCTION st_astext(geometry)
FUNCTION st_astext(text)
FUNCTION st_astiff(raster,integer[],text,integer)
FUNCTION st_astiff(raster,integer[],text[],integer)
FUNCTION st_astiff(raster,text,integer)
FUNCTION st_astiff(raster,text[],integer)
FUNCTION st_astwkb(geometry,integer)
FUNCTION st_astwkb(geometry,integer,bigint)
FUNCTION st_astwkb(geometry,integer,bigint,boolean)
FUNCTION st_asukml(geometry)
FUNCTION st_asukml(geometry,integer)
FUNCTION st_asukml(geometry,integer,integer)
FUNCTION st_asx3d(geometry)
FUNCTION st_asx3d(geometry,integer)
FUNCTION st_asx3d(geometry,integer,integer)
FUNCTION _st_asx3d(integer,geometry,integer,integer,text)
FUNCTION st_azimuth(geography,geography)
FUNCTION st_azimuth(geometry,geometry)
FUNCTION st_bandisnodata(raster)
FUNCTION st_bandisnodata(raster,boolean)
FUNCTION st_bandisnodata(raster,integer)
FUNCTION st_bandisnodata(raster,integer,boolean)
FUNCTION st_bandmetadata(raster)
FUNCTION st_bandmetadata(raster,integer)
FUNCTION st_bandmetadata(raster,integer[])
FUNCTION st_bandmetadata(raster,variadic integer[])
FUNCTION st_bandnodatavalue(raster)
FUNCTION st_bandnodatavalue(raster,integer)
FUNCTION st_bandpath(raster)
FUNCTION st_bandpath(raster,integer)
FUNCTION st_bandpixeltype(raster)
FUNCTION st_bandpixeltype(raster,integer)
FUNCTION st_band(raster,integer)
FUNCTION st_band(raster,integer[])
FUNCTION st_band(raster,text,character)
FUNCTION st_bandsurface(raster,integer)
FUNCTION st_bdmpolyfromtext(text,integer)
FUNCTION st_bdpolyfromtext(text,integer)
FUNCTION st_below(raster,raster)
FUNCTION _st_bestsrid(geography)
FUNCTION _st_bestsrid(geography,geography)
FUNCTION st_boundary(geometry)
FUNCTION st_box2d(box3d)
FUNCTION st_box2d(box3d_extent)
FUNCTION st_box2d_contain(box2d,box2d)
FUNCTION st_box2d_contained(box2d,box2d)
FUNCTION st_box2d(geometry)
FUNCTION st_box2d_in(cstring)
FUNCTION st_box2d_intersects(box2d,box2d)
FUNCTION st_box2d_left(box2d,box2d)
FUNCTION st_box2d_out(box2d)
FUNCTION st_box2d_overlap(box2d,box2d)
FUNCTION st_box2d_overleft(box2d,box2d)
FUNCTION st_box2d_overright(box2d,box2d)
FUNCTION st_box2d_right(box2d,box2d)
FUNCTION st_box2d_same(box2d,box2d)
FUNCTION st_box3d(box2d)
FUNCTION st_box3d_extent(box3d_extent)
FUNCTION st_box3d(geometry)
FUNCTION st_box3d_in(cstring)
FUNCTION st_box3d_out(box3d)
FUNCTION st_box(box3d)
FUNCTION st_box(geometry)
FUNCTION st_buffer(geography,double precision)
FUNCTION st_buffer(geometry,double precision)
FUNCTION _st_buffer(geometry,double precision,cstring)
FUNCTION st_buffer(geometry,double precision,integer)
FUNCTION st_buffer(geometry,double precision,text)
FUNCTION st_buffer(text,double precision)
FUNCTION st_buildarea(geometry)
FUNCTION st_build_histogram2d(histogram2d,text,text)
FUNCTION st_build_histogram2d(histogram2d,text,text,text)
FUNCTION st_bytea(geometry)
FUNCTION st_bytea(raster)
FUNCTION st_cache_bbox()
FUNCTION st_centroid(geometry)
FUNCTION _st_changeedgegeom_adjacent_edges(character varying,integer,integer)
FUNCTION st_changeedgegeom(character varying,integer,public.geometry)
FUNCTION st_chip_in(cstring)
FUNCTION st_chip_out(chip)
FUNCTION st_cleangeometry(geometry)
FUNCTION st_clip(raster,geometry,boolean)
FUNCTION st_clip(raster,geometry,double precision,boolean)
FUNCTION st_clip(raster,geometry,double precision[],boolean)
FUNCTION st_clip(raster,integer,geometry,boolean)
FUNCTION st_clip(raster,integer,geometry,double precision,boolean)
FUNCTION st_clip(raster,integer,geometry,double precision[],boolean)
FUNCTION st_closestpoint(geometry,geometry)
FUNCTION st_collect_garray(geometry[])
FUNCTION st_collect(geometry[])
FUNCTION st_collect(geometry,geometry)
FUNCTION st_collectionextract(geometry,integer)
FUNCTION st_collectionhomogenize(geometry)
FUNCTION st_collector(geometry,geometry)
FUNCTION st_combine_bbox(box2d,geometry)
FUNCTION st_combine_bbox(box3d_extent,geometry)
FUNCTION st_combine_bbox(box3d,geometry)
FUNCTION st_compression(chip)
FUNCTION _st_concavehull(geometry)
FUNCTION st_concavehull(geometry,double precision,boolean)
FUNCTION st_concavehull(geometry,float)
FUNCTION _st_concvehull(geometry)
FUNCTION st_contained(raster,raster)
FUNCTION st_contain(raster,raster)
FUNCTION st_contain(raster,raster)**/
FUNCTION _st_contains(geometry,geometry)
FUNCTION st_contains(geometry,geometry)
FUNCTION _st_contains(geometry,raster,integer)
FUNCTION st_contains(geometry,raster,integer)
FUNCTION _st_containsproperly(geometry,geometry)
FUNCTION st_containsproperly(geometry,geometry)
FUNCTION _st_contains(raster,geometry,integer)
FUNCTION st_contains(raster,geometry,integer)
FUNCTION st_contains(raster,integer,geometry)
FUNCTION st_convexhull(geometry)
FUNCTION st_convexhull(raster)
FUNCTION st_coorddim(geometry)
FUNCTION st_count(raster,boolean)
FUNCTION st_count(raster,integer,boolean)
FUNCTION _st_count(raster,integer,boolean,double precision)
FUNCTION st_count(text,text,boolean)
FUNCTION st_count(text,text,integer,boolean)
FUNCTION _st_count(text,text,integer,boolean,double precision)
FUNCTION st_coveredby(geography,geography)
FUNCTION _st_coveredby(geometry,geometry)
FUNCTION st_coveredby(geometry,geometry)
FUNCTION st_coveredby(text,text)
FUNCTION _st_covers(geography,geography)
FUNCTION st_covers(geography,geography)
FUNCTION _st_covers(geometry,geometry)
FUNCTION st_covers(geometry,geometry)
FUNCTION st_covers(text,text)
FUNCTION st_create_histogram2d(box2d,integer)
FUNCTION st_createtopogeo(character varying,public.geometry)
FUNCTION _st_crosses(geometry,geometry)
FUNCTION st_crosses(geometry,geometry)
FUNCTION st_curvetoline(geometry)
FUNCTION st_curvetoline(geometry,integer)
FUNCTION st_datatype(chip)
FUNCTION _st_dfullywithin(geometry,geometry,double precision)
FUNCTION st_dfullywithin(geometry,geometry,double precision)
FUNCTION st_difference(geometry,geometry)
FUNCTION st_dimension(geometry)
FUNCTION st_disjoint(geometry,geometry)
FUNCTION st_distance(geography,geography)
FUNCTION st_distance(geography,geography,boolean)
FUNCTION _st_distance(geography,geography,double precision,boolean)
FUNCTION st_distance(geometry,geometry)
FUNCTION st_distance_sphere(geometry,geometry)
FUNCTION st_distance_spheroid(geometry,geometry,spheroid)
FUNCTION st_distance(text,text)
FUNCTION st_dropbbox(geometry)
FUNCTION st_dumpaspolygons(raster)
FUNCTION st_dumpaspolygons(raster,integer)
FUNCTION _st_dumpaswktpolygons(raster,integer)
FUNCTION st_dump(geometry)
FUNCTION st_dumppoints(geometry)
FUNCTION _st_dumppoints(geometry,integer[])
FUNCTION st_dumprings(geometry)
FUNCTION st_dwithin(geography,geography,double precision)
FUNCTION _st_dwithin(geography,geography,double precision,boolean)
FUNCTION st_dwithin(geography,geography,double precision,boolean)
FUNCTION _st_dwithin(geometry,geometry,double precision)
FUNCTION st_dwithin(geometry,geometry,double precision)
FUNCTION st_dwithin(text,text,double precision)
FUNCTION st_endpoint(geometry)
FUNCTION st_envelope(geometry)
FUNCTION st_envelope(raster)
FUNCTION _st_equals(geometry,geometry)
FUNCTION st_equals(geometry,geometry)
FUNCTION st_estimated_extent(text,text)
FUNCTION st_estimated_extent(text,text,text)
FUNCTION st_estimate_histogram2d(histogram2d,box2d)
FUNCTION st_expand(box2d,double precision)
FUNCTION st_expand(box3d,double precision)
FUNCTION _st_expand(geography,double precision)
FUNCTION st_expand(geometry,double precision)
FUNCTION st_explode_histogram2d(histogram2d,text)
FUNCTION st_exteriorring(geometry)
FUNCTION st_factor(chip)
FUNCTION st_find_extent(text,text)
FUNCTION st_find_extent(text,text,text)
FUNCTION st_flipcoordinates(geometry)
FUNCTION st_force_2d(geometry)
FUNCTION st_force_3d(geometry)
FUNCTION st_force_3dm(geometry)
FUNCTION st_force_3dz(geometry)
FUNCTION st_force_4d(geometry)
FUNCTION st_force_collection(geometry)
FUNCTION st_forcerhr(geometry)
FUNCTION st_gdaldrivers()
FUNCTION st_geogfromtext(text)
FUNCTION st_geogfromwkb(bytea)
FUNCTION st_geographyfromtext(text)
FUNCTION st_geohash(geometry)
FUNCTION st_geohash(geometry,integer)
FUNCTION st_geom_accum(geometry[],geometry)
FUNCTION st_geomcollfromtext(text)
FUNCTION st_geomcollfromtext(text,integer)
FUNCTION st_geomcollfromwkb(bytea)
FUNCTION st_geomcollfromwkb(bytea,integer)
FUNCTION st_geometry_above(geometry,geometry)
FUNCTION st_geometry_analyze(internal)
FUNCTION st_geometry_below(geometry,geometry)
FUNCTION st_geometry(box2d)
FUNCTION st_geometry(box3d)
FUNCTION st_geometry(box3d_extent)
FUNCTION st_geometry(bytea)
FUNCTION st_geometry(chip)
FUNCTION st_geometry_cmp(geometry,geometry)
FUNCTION st_geometry_contained(geometry,geometry)
FUNCTION st_geometry_contain(geometry,geometry)
FUNCTION st_geometry_eq(geometry,geometry)
FUNCTION st_geometryfromtext(text)
FUNCTION st_geometryfromtext(text,integer)
FUNCTION st_geometry_ge(geometry,geometry)
FUNCTION st_geometry_gt(geometry,geometry)
FUNCTION st_geometry_in(cstring)
FUNCTION st_geometry_left(geometry,geometry)
FUNCTION st_geometry_le(geometry,geometry)
FUNCTION st_geometry_lt(geometry,geometry)
FUNCTION st_geometryn(geometry,integer)
FUNCTION st_geometry_out(geometry)
FUNCTION st_geometry_overabove(geometry,geometry)
FUNCTION st_geometry_overbelow(geometry,geometry)
FUNCTION st_geometry_overlap(geometry,geometry)
FUNCTION st_geometry_overleft(geometry,geometry)
FUNCTION st_geometry_overright(geometry,geometry)
FUNCTION st_geometry_recv(internal)
FUNCTION st_geometry_right(geometry,geometry)
FUNCTION st_geometry_same(geometry,geometry)
FUNCTION st_geometry_send(geometry)
FUNCTION st_geometry(text)
FUNCTION st_geometrytype(geometry)
FUNCTION st_geometrytype(topogeometry)
FUNCTION st_geomfromewkb(bytea)
FUNCTION st_geomfromewkt(text)
FUNCTION st_geomfromgeojson(text)
FUNCTION st_geomfromgml(text)
FUNCTION _st_geomfromgml(text,integer)
FUNCTION st_geomfromgml(text,integer)
FUNCTION st_geomfromkml(text)
FUNCTION st_geomfromtext(text)
FUNCTION st_geomfromtext(text,integer)
FUNCTION st_geomfromwkb(bytea)
FUNCTION st_geomfromwkb(bytea,integer)
FUNCTION st_georeference(raster)
FUNCTION st_georeference(raster,text)
FUNCTION st_geotransform(raster)
FUNCTION st_getfaceedges(character varying,integer)
FUNCTION _st_getfacegeometry(character varying,integer)
FUNCTION st_getfacegeometry(character varying,integer)
FUNCTION st_gmltosql(text)
FUNCTION st_gmltosql(text,integer)
FUNCTION st_hasarc(geometry)
FUNCTION st_hasbbox(geometry)
FUNCTION st_hasnoband(raster)
FUNCTION st_hasnoband(raster,integer)
FUNCTION st_hausdorffdistance(geometry,geometry)
FUNCTION st_hausdorffdistance(geometry,geometry,double precision)
FUNCTION st_height(chip)
FUNCTION st_height(raster)
FUNCTION _st_hillshade4ma(double precision[],text,text[])
FUNCTION st_hillshade(raster,integer,text,double precision,double precision,double precision,double precision)
FUNCTION st_hillshade(raster,integer,text,double precision,double precision,double precision,double precision,boolean)
FUNCTION st_hillshade(raster,integer,text,float,float,float,float)
FUNCTION st_hillshade(raster,integer,text,float,float,float,float,boolean)
FUNCTION st_histogram2d_in(cstring)
FUNCTION st_histogram2d_out(histogram2d)
FUNCTION _st_histogram(raster,integer,boolean,double precision,integer,double precision[],boolean,double precision,double precision)
FUNCTION st_histogram(raster,integer,boolean,integer,boolean)
FUNCTION st_histogram(raster,integer,boolean,integer,double precision[],boolean)
FUNCTION st_histogram(raster,integer,integer,boolean)
FUNCTION st_histogram(raster,integer,integer,double precision[],boolean)
FUNCTION _st_histogram(text,text,integer,boolean,double precision,integer,double precision[],boolean)
FUNCTION st_histogram(text,text,integer,boolean,integer,boolean)
FUNCTION st_histogram(text,text,integer,boolean,integer,double precision[],boolean)
FUNCTION st_histogram(text,text,integer,integer,boolean)
FUNCTION st_histogram(text,text,integer,integer,double precision[],boolean)
FUNCTION st_inittopogeo(character varying)
FUNCTION st_interiorringn(geometry,integer)
FUNCTION st_interpolatepoint(geometry,geometry)
FUNCTION st_intersection(geography,geography)
FUNCTION st_intersection(geometry,geometry)
FUNCTION st_intersection(geometry,raster)
FUNCTION st_intersection(geometry,raster,integer)
FUNCTION st_intersection(raster,geometry)
FUNCTION st_intersection(raster,geometry,regprocedure)
FUNCTION st_intersection(raster,geometry,text,regprocedure)
FUNCTION st_intersection(raster,integer,geometry)
FUNCTION st_intersection(raster,integer,geometry,regprocedure)
FUNCTION st_intersection(raster,integer,geometry,text,regprocedure)
FUNCTION st_intersection(raster,integer,raster,integer,double precision)
FUNCTION st_intersection(raster,integer,raster,integer,double precision[])
FUNCTION st_intersection(raster,integer,raster,integer,regprocedure)
FUNCTION st_intersection(raster,integer,raster,integer,text,double precision)
FUNCTION st_intersection(raster,integer,raster,integer,text,double precision[])
FUNCTION st_intersection(raster,integer,raster,integer,text,regprocedure)
FUNCTION _st_intersection(raster,integer,raster,integer,text,text,regprocedure)
FUNCTION st_intersection(raster,raster,double precision)
FUNCTION st_intersection(raster,raster,double precision[])
FUNCTION st_intersection(raster,raster,integer,integer)
FUNCTION st_intersection(raster,raster,regprocedure)
FUNCTION st_intersection(raster,raster,text,double precision)
FUNCTION st_intersection(raster,raster,text,double precision[])
FUNCTION st_intersection(raster,raster,text,regprocedure)
FUNCTION st_intersection(text,text)
FUNCTION st_intersects(geography,geography)
FUNCTION _st_intersects(geometry,geometry)
FUNCTION st_intersects(geometry,geometry)
FUNCTION st_intersects(geometry,raster)
FUNCTION st_intersects(geometry,raster,boolean)
FUNCTION _st_intersects(geometry,raster,integer)
FUNCTION st_intersects(geometry,raster,integer)
FUNCTION _st_intersects(geometry,raster,integer,boolean)
FUNCTION st_intersects(geometry,raster,integer,boolean)
FUNCTION st_intersects(raster,boolean,geometry)
FUNCTION st_intersects(raster,geometry)
FUNCTION _st_intersects(raster,geometry,integer)
FUNCTION st_intersects(raster,geometry,integer)
FUNCTION st_intersects(raster,integer,boolean,geometry)
FUNCTION st_intersects(raster,integer,geometry)
FUNCTION _st_intersects(raster,integer,raster,integer)
FUNCTION st_intersects(raster,integer,raster,integer)
FUNCTION st_intersects(raster,raster)
FUNCTION st_intersects(text,text)
FUNCTION st_isclosed(geometry)
FUNCTION st_iscollection(geometry)
FUNCTION st_isempty(geometry)
FUNCTION st_isempty(raster)
FUNCTION st_isring(geometry)
FUNCTION st_issimple(geometry)
FUNCTION st_isvaliddetail(geometry)
FUNCTION st_isvaliddetail(geometry,integer)
FUNCTION st_isvalid(geometry)
FUNCTION st_isvalid(geometry,integer)
FUNCTION st_isvalidreason(geometry)
FUNCTION st_isvalidreason(geometry,integer)
FUNCTION st_left(raster,raster)
FUNCTION st_length2d(geometry)
FUNCTION st_length2d_spheroid(geometry,spheroid)
FUNCTION st_length3d(geometry)
FUNCTION st_length3d_spheroid(geometry,spheroid)
FUNCTION st_length(geography)
FUNCTION st_length(geography,boolean)
FUNCTION st_length(geometry)
FUNCTION st_length_spheroid(geometry,spheroid)
FUNCTION st_length(text)
FUNCTION _st_linecrossingdirection(geometry,geometry)
FUNCTION st_linecrossingdirection(geometry,geometry)
FUNCTION st_linefromencodedpolyline(text)
FUNCTION st_linefromencodedpolyline(text,integer)
FUNCTION st_linefrommultipoint(geometry)
FUNCTION st_linefromtext(text)
FUNCTION st_linefromtext(text,integer)
FUNCTION st_linefromwkb(bytea)
FUNCTION st_linefromwkb(bytea,integer)
FUNCTION st_line_interpolate_point(geometry,double precision)
FUNCTION st_line_locate_point(geometry,geometry)
FUNCTION st_linemerge(geometry)
FUNCTION st_linestringfromwkb(bytea)
FUNCTION st_linestringfromwkb(bytea,integer)
FUNCTION st_line_substring(geometry,double precision,double precision)
FUNCTION st_linetocurve(geometry)
FUNCTION st_locatealong(geometry,double precision)
FUNCTION st_locatealong(geometry,double precision,double precision)
FUNCTION st_locate_along_measure(geometry,double precision)
FUNCTION st_locatebetweenelevations(geometry,double precision,double precision)
FUNCTION st_locatebetween(geometry,double precision,double precision)
FUNCTION st_locatebetween(geometry,double precision,double precision,double precision)
FUNCTION st_locate_between_measures(geometry,double precision,double precision)
FUNCTION _st_longestline(geometry,geometry)
FUNCTION st_longestline(geometry,geometry)
FUNCTION st_makebox2d(geometry,geometry)
FUNCTION st_makebox3d(geometry,geometry)
FUNCTION st_makeemptyraster(integer,integer,double precision,double precision,double precision)
FUNCTION st_makeemptyraster(integer,integer,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_makeemptyraster(integer,integer,double precision,double precision,double precision,double precision,double precision,double precision,integer)
FUNCTION st_makeemptyraster(raster)
FUNCTION st_makeenvelope(double precision,double precision,double precision,double precision)
FUNCTION st_makeenvelope(double precision,double precision,double precision,double precision,integer)
FUNCTION st_makeline_garray(geometry[])
FUNCTION st_makeline(geometry[])
FUNCTION st_makeline(geometry,geometry)
FUNCTION st_makepoint(double precision,double precision)
FUNCTION st_makepoint(double precision,double precision,double precision)
FUNCTION st_makepoint(double precision,double precision,double precision,double precision)
FUNCTION st_makepointm(double precision,double precision,double precision)
FUNCTION st_makepolygon(geometry)
FUNCTION st_makepolygon(geometry,geometry[])
FUNCTION st_makevalid(geometry)
FUNCTION _st_mapalgebra4unionfinal1(raster)
FUNCTION _st_mapalgebra4unionstate(raster,raster)
FUNCTION _st_mapalgebra4unionstate(raster,raster,integer)
FUNCTION _st_mapalgebra4unionstate(raster,raster,integer,text)
FUNCTION _st_mapalgebra4unionstate(raster,raster,text)
FUNCTION _st_mapalgebra4unionstate(raster,raster,text,text,text,double precision,text,text,text,double precision)
FUNCTION st_mapalgebraexpr(raster,integer,raster,integer,text,text,text,text,text,double precision)
FUNCTION st_mapalgebraexpr(raster,integer,text,text,double precision)
FUNCTION st_mapalgebraexpr(raster,integer,text,text,text)
FUNCTION st_mapalgebraexpr(raster,raster,text,text,text,text,text,double precision)
FUNCTION st_mapalgebraexpr(raster,text,text,double precision)
FUNCTION st_mapalgebraexpr(raster,text,text,text)
FUNCTION st_mapalgebrafctngb(raster,integer,text,integer,integer,regprocedure,text,text[])
FUNCTION st_mapalgebrafctngb(raster,integer,text,integer,integer,regprocedure,text,variadic text[])
FUNCTION st_mapalgebrafct(raster,integer,raster,integer,regprocedure,text,text,text[])
FUNCTION st_mapalgebrafct(raster,integer,raster,integer,regprocedure,text,text,variadic text[])
FUNCTION st_mapalgebrafct(raster,integer,regprocedure)
FUNCTION st_mapalgebrafct(raster,integer,regprocedure,text[])
FUNCTION st_mapalgebrafct(raster,integer,regprocedure,variadic text[])
FUNCTION st_mapalgebrafct(raster,integer,text,regprocedure)
FUNCTION st_mapalgebrafct(raster,integer,text,regprocedure,text[])
FUNCTION st_mapalgebrafct(raster,integer,text,regprocedure,variadic text[])
FUNCTION st_mapalgebrafct(raster,raster,regprocedure,text,text,text[])
FUNCTION st_mapalgebrafct(raster,raster,regprocedure,text,text,variadic text[])
FUNCTION st_mapalgebrafct(raster,raster,regprocedure,variadic text[])
FUNCTION st_mapalgebrafct(raster,regprocedure)
FUNCTION st_mapalgebrafct(raster,regprocedure,text[])
FUNCTION st_mapalgebrafct(raster,regprocedure,variadic text[])
FUNCTION st_mapalgebrafct(raster,text,regprocedure)
FUNCTION st_mapalgebrafct(raster,text,regprocedure,text[])
FUNCTION st_mapalgebrafct(raster,text,regprocedure,variadic text[])
FUNCTION st_mapalgebra(raster,integer,text)
FUNCTION st_mapalgebra(raster,integer,text,text)
FUNCTION st_mapalgebra(raster,integer,text,text,nodatavaluerepl text)
FUNCTION st_mapalgebra(raster,integer,text,text,text)
FUNCTION st_mapalgebra(raster,pixeltype text,expression text,nodatavaluerepl text)
FUNCTION st_mapalgebra(raster,text)
FUNCTION st_mapalgebra(raster,text,text)
FUNCTION st_mapalgebra(raster,text,text,text)
FUNCTION st_max4ma(double precision[],text,text[])
FUNCTION _st_maxdistance(geometry,geometry)
FUNCTION st_max_distance(geometry,geometry)
FUNCTION st_maxdistance(geometry,geometry)
FUNCTION st_mean4ma(double precision[],text,text[])
FUNCTION st_mem_size(geometry)
FUNCTION st_metadata(raster)
FUNCTION st_m(geometry)
FUNCTION st_min4ma(double precision[],text,text[])
FUNCTION st_minimumboundingcircle(geometry)
FUNCTION st_minimumboundingcircle(geometry)
FUNCTION st_minimumboundingcircle(geometry,integer)
FUNCTION st_minpossibleval(text)
FUNCTION st_minpossiblevalue(text)
FUNCTION st_mlinefromtext(text)
FUNCTION st_mlinefromtext(text,integer)
FUNCTION st_mlinefromwkb(bytea)
FUNCTION st_mlinefromwkb(bytea,integer)
FUNCTION st_modedgeheal(character varying,integer,integer)
FUNCTION st_modedgesplit(character varying,integer,public.geometry)
FUNCTION st_modedgessplit(character varying,integer,public.geometry)
FUNCTION st_moveisonode(character varying,integer,public.geometry)
FUNCTION st_mpointfromtext(text)
FUNCTION st_mpointfromtext(text,integer)
FUNCTION st_mpointfromwkb(bytea)
FUNCTION st_mpointfromwkb(bytea,integer)
FUNCTION st_mpolyfromtext(text)
FUNCTION st_mpolyfromtext(text,integer)
FUNCTION st_mpolyfromwkb(bytea)
FUNCTION st_mpolyfromwkb(bytea,integer)
FUNCTION st_multi(geometry)
FUNCTION st_multilinefromwkb(bytea)
FUNCTION st_multilinestringfromtext(text)
FUNCTION st_multilinestringfromtext(text,integer)
FUNCTION st_multipointfromtext(text)
FUNCTION st_multipointfromwkb(bytea)
FUNCTION st_multipointfromwkb(bytea,integer)
FUNCTION st_multipolyfromwkb(bytea)
FUNCTION st_multipolyfromwkb(bytea,integer)
FUNCTION st_multipolygonfromtext(text)
FUNCTION st_multipolygonfromtext(text,integer)
FUNCTION st_ndims(geometry)
FUNCTION st_nearestvalue(raster,integer,integer,boolean)
FUNCTION st_nearestvalue(raster,integer,integer,integer,boolean)
FUNCTION st_neighborhood(raster,geometry,integer,boolean)
FUNCTION st_neighborhood(raster,integer,geometry,integer,boolean)
FUNCTION st_neighborhood(raster,integer,integer,integer,boolean)
FUNCTION st_neighborhood(raster,integer,integer,integer,integer,boolean)
FUNCTION st_newedgeheal(character varying,integer,integer)
FUNCTION st_newedgessplit(character varying,integer,public.geometry)
FUNCTION st_node(geometry)
FUNCTION st_noop(geometry)
FUNCTION st_npoints(geometry)
FUNCTION st_nrings(geometry)
FUNCTION st_numbands(raster)
FUNCTION st_numgeometries(geometry)
FUNCTION st_numinteriorring(geometry)
FUNCTION st_numinteriorrings(geometry)
FUNCTION st_numpatches(geometry)
FUNCTION st_numpoints(geometry)
FUNCTION st_offsetcurve(geometry,double precision,cstring)
FUNCTION st_offsetcurve(geometry,double precision,text)
FUNCTION _st_orderingequals(geometry,geometry)
FUNCTION st_orderingequals(geometry,geometry)
FUNCTION st_overabove(raster,raster)
FUNCTION st_overbelow(raster,raster)
FUNCTION st_overlap(raster,raster)
FUNCTION _st_overlaps(geometry,geometry)
FUNCTION st_overlaps(geometry,geometry)
FUNCTION _st_overlaps(geometry,raster,integer)
FUNCTION st_overlaps(geometry,raster,integer)
FUNCTION _st_overlaps(raster,geometry,integer)
FUNCTION st_overlaps(raster,geometry,integer)
FUNCTION st_overlaps(raster,integer,geometry)
FUNCTION st_overleft(raster,raster)
FUNCTION st_overright(raster,raster)
FUNCTION st_patchn(geometry,integer)
FUNCTION st_perimeter2d(geometry)
FUNCTION st_perimeter3d(geometry)
FUNCTION st_perimeter(geography)
FUNCTION st_perimeter(geography,boolean)
FUNCTION st_perimeter(geometry)
FUNCTION st_pixelaspolygon(raster,integer,integer)
FUNCTION st_pixelaspolygon(raster,integer,integer,integer)
FUNCTION st_pixelaspolygons(raster)
FUNCTION st_pixelaspolygons(raster,integer)
FUNCTION st_pixelheight(raster)
FUNCTION st_pixelwidth(raster)
FUNCTION st_point(double precision,double precision)
FUNCTION st_pointfromtext(text)
FUNCTION st_pointfromtext(text,integer)
FUNCTION st_pointfromwkb(bytea)
FUNCTION st_pointfromwkb(bytea,integer)
FUNCTION st_point_inside_circle(geometry,double precision,double precision,double precision)
FUNCTION st_pointn(geometry)
FUNCTION st_pointn(geometry,integer)
FUNCTION st_pointonsurface(geometry)
FUNCTION _st_pointoutside(geography)
FUNCTION st_polyfromtext(text)
FUNCTION st_polyfromtext(text,integer)
FUNCTION st_polyfromwkb(bytea)
FUNCTION st_polyfromwkb(bytea,integer)
FUNCTION st_polygonfromtext(text)
FUNCTION st_polygonfromtext(text,integer)
FUNCTION st_polygonfromwkb(bytea)
FUNCTION st_polygonfromwkb(bytea,integer)
FUNCTION st_polygon(geometry,integer)
FUNCTION st_polygonize_garray(geometry[])
FUNCTION st_polygonize(geometry[])
FUNCTION st_polygon(raster)
FUNCTION st_polygon(raster,integer)
FUNCTION st_postgis_gist_joinsel(internal,oid,internal,smallint)
FUNCTION st_postgis_gist_sel(internal,oid,internal,integer)
FUNCTION st_project(geography,double precision,double precision)
FUNCTION st_quantile(raster,boolean,double precision)
FUNCTION st_quantile(raster,double precision)
FUNCTION st_quantile(raster,double precision[])
FUNCTION st_quantile(raster,integer,boolean,double precision)
FUNCTION st_quantile(raster,integer,boolean,double precision[])
FUNCTION _st_quantile(raster,integer,boolean,double precision,double precision[])
FUNCTION st_quantile(raster,integer,double precision)
FUNCTION st_quantile(raster,integer,double precision[])
FUNCTION st_quantile(text,text,boolean,double precision)
FUNCTION st_quantile(text,text,double precision)
FUNCTION st_quantile(text,text,double precision[])
FUNCTION st_quantile(text,text,integer,boolean,double precision)
FUNCTION st_quantile(text,text,integer,boolean,double precision[])
FUNCTION _st_quantile(text,text,integer,boolean,double precision,double precision[])
FUNCTION st_quantile(text,text,integer,double precision)
FUNCTION st_quantile(text,text,integer,double precision[])
FUNCTION st_range4ma(double precision[],text,text[])
FUNCTION _st_raster2worldcoord(raster,integer,integer)
FUNCTION st_raster2worldcoord(raster,integer,integer)
FUNCTION st_raster2worldcoordx(raster,integer)
FUNCTION st_raster2worldcoordx(raster,integer,integer)
FUNCTION st_raster2worldcoordy(raster,integer)
FUNCTION st_raster2worldcoordy(raster,integer,integer)
FUNCTION st_reclass(raster,integer,text,text,double precision)
FUNCTION _st_reclass(raster,reclassarg[])
FUNCTION st_reclass(raster,reclassarg[])
FUNCTION st_reclass(raster,text,text)
FUNCTION st_relate(geometry,geometry)
FUNCTION st_relate(geometry,geometry,integer)
FUNCTION st_relate(geometry,geometry,text)
FUNCTION st_relatematch(text,text)
FUNCTION st_remedgemodface(character varying,integer)
FUNCTION st_remedgenewface(character varying,integer)
FUNCTION st_remisonode(character varying,integer)
FUNCTION st_removeisoedge(character varying,integer)
FUNCTION st_removeisonode(character varying,integer)
FUNCTION st_removepoint(geometry,integer)
FUNCTION st_removerepeatedpoints(geometry)
FUNCTION st_resample(raster,integer,double precision,double precision,double precision,double precision,double precision,double precision,text,double precision)
FUNCTION st_resample(raster,integer,integer,integer,double precision,double precision,double precision,double precision,text,double precision)
FUNCTION st_resample(raster,raster,boolean,text,double precision)
FUNCTION st_resample(raster,raster,text,double precision)
FUNCTION st_resample(raster,raster,text,double precision,boolean)
FUNCTION _st_resample(raster,text,double precision,integer,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION _st_resample(raster,text,double precision,integer,double precision,double precision,double precision,double precision,double precision,double precision,integer,integer)
FUNCTION st_rescale(raster,double precision,double precision,text,double precision)
FUNCTION st_rescale(raster,double precision,text,double precision)
FUNCTION st_reskew(raster,double precision,double precision,text,double precision)
FUNCTION st_reskew(raster,double precision,text,double precision)
FUNCTION st_reverse(geometry)
FUNCTION st_right(raster,raster)
FUNCTION st_rotate(geometry,double precision)
FUNCTION st_rotate(geometry,double precision,double precision,double precision)
FUNCTION st_rotate(geometry,double precision,geometry)
FUNCTION st_rotatex(geometry,double precision)
FUNCTION st_rotatey(geometry,double precision)
FUNCTION st_rotatez(geometry,double precision)
FUNCTION st_rotation(raster)
FUNCTION st_samealignment(double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_samealignment(raster,raster)
FUNCTION st_same(raster,raster)
FUNCTION st_scale(geometry,double precision,double precision)
FUNCTION st_scale(geometry,double precision,double precision,double precision)
FUNCTION st_scalex(raster)
FUNCTION st_scaley(raster)
FUNCTION st_segmentize(geometry,double precision)
FUNCTION st_setbandisnodata(raster)
FUNCTION st_setbandisnodata(raster,integer)
FUNCTION st_setbandnodatavalue(raster,double precision)
FUNCTION st_setbandnodatavalue(raster,integer,double precision)
FUNCTION st_setbandnodatavalue(raster,integer,double precision,boolean)
FUNCTION st_setfactor(chip,real)
FUNCTION st_setgeoreference(raster,text)
FUNCTION st_setgeoreference(raster,text,text)
FUNCTION st_setgeotransform(raster,double precision,double precision,double precision,double precision,double precision,double precision)
FUNCTION st_setpoint(geometry,integer,geometry)
FUNCTION st_setrotation(raster,double precision)
FUNCTION st_setscale(raster,double precision)
FUNCTION st_setscale(raster,double precision,double precision)
FUNCTION st_setskew(raster,double precision)
FUNCTION st_setskew(raster,double precision,double precision)
FUNCTION st_setsrid(geometry,integer)
FUNCTION st_setsrid(raster,integer)
FUNCTION st_setupperleft(raster,double precision,double precision)
FUNCTION st_setvalue(raster,geometry,double precision)
FUNCTION st_setvalue(raster,integer,geometry,double precision)
FUNCTION st_setvalue(raster,integer,integer,double precision)
FUNCTION st_setvalue(raster,integer,integer,integer,double precision)
FUNCTION st_sharedpaths(geometry,geometry)
FUNCTION st_shift_longitude(geometry)
FUNCTION st_shortestline(geometry,geometry)
FUNCTION st_simplify(geometry,double precision)
FUNCTION st_simplifypreservetopology(geometry,double precision)
FUNCTION st_skewx(raster)
FUNCTION st_skewy(raster)
FUNCTION _st_slope4ma(double precision[],text,text[])
FUNCTION st_slope(raster,integer,text)
FUNCTION st_slope(raster,integer,text,boolean)
FUNCTION st_slope(raster,integer,text,text,double precision,boolean)
FUNCTION st_snap(geometry,geometry,double precision)
FUNCTION st_snaptogrid(geometry,double precision)
FUNCTION st_snaptogrid(geometry,double precision,double precision)
FUNCTION st_snaptogrid(geometry,double precision,double precision,double precision,double precision)
FUNCTION st_snaptogrid(geometry,geometry,double precision,double precision,double precision,double precision)
FUNCTION st_snaptogrid(raster,double precision,double precision,double precision,double precision,text,double precision)
FUNCTION st_snaptogrid(raster,double precision,double precision,double precision,text,double precision)
FUNCTION st_snaptogrid(raster,double precision,double precision,text,double precision,double precision,double precision)
FUNCTION st_spheroid_in(cstring)
FUNCTION st_spheroid_out(spheroid)
FUNCTION st_split(geometry,geometry)
FUNCTION st_srid(chip)
FUNCTION st_srid(geometry)
FUNCTION st_srid(raster)
FUNCTION st_startpoint(geometry)
FUNCTION st_sum4ma(double precision[],text,text[])
FUNCTION st_summary(geography)
FUNCTION st_summary(geometry)
FUNCTION st_summarystats(raster,boolean)
FUNCTION st_summarystats(raster,integer,boolean)
FUNCTION _st_summarystats(raster,integer,boolean,double precision)
FUNCTION st_summarystats(text,text,boolean)
FUNCTION st_summarystats(text,text,integer,boolean)
FUNCTION _st_summarystats(text,text,integer,boolean,double precision)
FUNCTION st_symdifference(geometry,geometry)
FUNCTION st_symmetricdifference(geometry,geometry)
FUNCTION st_testraster(double precision,double precision,double precision)
FUNCTION st_text(boolean)
FUNCTION st_text(geometry)
FUNCTION st_tile(raster,integer,integer)
FUNCTION _st_tile(raster,integer,integer,integer[])
FUNCTION st_tile(raster,integer,integer,integer)
FUNCTION st_tile(raster,integer,integer,integer[])
FUNCTION st_tile(raster,integer[],integer,integer)
FUNCTION _st_touches(geometry,geometry)
FUNCTION st_touches(geometry,geometry)
FUNCTION _st_touches(geometry,raster,integer)
FUNCTION st_touches(geometry,raster,integer)
FUNCTION _st_touches(raster,geometry,integer)
FUNCTION st_touches(raster,geometry,integer)
FUNCTION st_touches(raster,integer,geometry)
FUNCTION st_transform(geometry,integer)
FUNCTION st_transform(raster,integer,double precision,double precision,text,double precision)
FUNCTION st_transform(raster,integer,double precision,text,double precision)
FUNCTION st_transform(raster,integer,text,double precision,double precision,double precision)
FUNCTION st_translate(geometry,double precision,double precision)
FUNCTION st_translate(geometry,double precision,double precision,double precision)
FUNCTION st_transscale(geometry,double precision,double precision,double precision,double precision)
FUNCTION st_unaryunion(geometry)
FUNCTION st_union(geometry[])
FUNCTION st_union(geometry,geometry)
FUNCTION st_unite_garray(geometry[])
FUNCTION st_upperleftx(raster)
FUNCTION st_upperlefty(raster)
FUNCTION st_valuecount(raster,double precision,double precision)
FUNCTION st_valuecount(raster,double precision[],double precision)
FUNCTION _st_valuecount(raster,integer,boolean,double precision[],double precision)
FUNCTION st_valuecount(raster,integer,boolean,double precision,double precision)
FUNCTION st_valuecount(raster,integer,boolean,double precision[],double precision)
FUNCTION st_valuecount(raster,integer,double precision,double precision)
FUNCTION st_valuecount(raster,integer,double precision[],double precision)
FUNCTION st_valuecount(text,text,double precision,double precision)
FUNCTION st_valuecount(text,text,double precision[],double precision)
FUNCTION _st_valuecount(text,text,integer,boolean,double precision[],double precision)
FUNCTION st_valuecount(text,text,integer,boolean,double precision,double precision)
FUNCTION st_valuecount(text,text,integer,boolean,double precision[],double precision)
FUNCTION st_valuecount(text,text,integer,double precision,double precision)
FUNCTION st_valuecount(text,text,integer,double precision[],double precision)
FUNCTION st_valuepercent(raster,double precision,double precision)
FUNCTION st_valuepercent(raster,double precision[],double precision)
FUNCTION st_valuepercent(raster,integer,boolean,double precision,double precision)
FUNCTION st_valuepercent(raster,integer,boolean,double precision[],double precision)
FUNCTION st_valuepercent(raster,integer,double precision,double precision)
FUNCTION st_valuepercent(raster,integer,double precision[],double precision)
FUNCTION st_valuepercent(text,text,double precision,double precision)
FUNCTION st_valuepercent(text,text,double precision[],double precision)
FUNCTION st_valuepercent(text,text,integer,boolean,double precision,double precision)
FUNCTION st_valuepercent(text,text,integer,boolean,double precision[],double precision)
FUNCTION st_valuepercent(text,text,integer,double precision,double precision)
FUNCTION st_valuepercent(text,text,integer,double precision[],double precision)
FUNCTION st_value(raster,geometry)
FUNCTION st_value(raster,geometry,boolean)
FUNCTION st_value(raster,geometry,double precision)
FUNCTION st_value(raster,integer,geometry)
FUNCTION st_value(raster,integer,geometry,boolean)
FUNCTION st_value(raster,integer,geometry,double precision)
FUNCTION st_value(raster,integer,integer)
FUNCTION st_value(raster,integer,integer,boolean)
FUNCTION st_value(raster,integer,integer,integer)
FUNCTION st_value(raster,integer,integer,integer,boolean)
FUNCTION st_width(chip)
FUNCTION st_width(raster)
FUNCTION _st_within(geometry,geometry)
FUNCTION st_within(geometry,geometry)
FUNCTION st_wkbtosql(bytea)
FUNCTION st_wkttosql(text)
FUNCTION _st_world2rastercoord(raster,double precision,double precision)
FUNCTION st_world2rastercoord(raster,double precision,double precision)
FUNCTION st_world2rastercoord(raster,geometry)
FUNCTION st_world2rastercoordx(raster,double precision)
FUNCTION st_world2rastercoordx(raster,double precision,double precision)
FUNCTION st_world2rastercoordx(raster,geometry)
FUNCTION st_world2rastercoordy(raster,double precision)
FUNCTION st_world2rastercoordy(raster,double precision,double precision)
FUNCTION st_world2rastercoordy(raster,geometry)
FUNCTION st_x(geometry)
FUNCTION st_xmax(box3d)
FUNCTION st_xmin(box3d)
FUNCTION st_y(geometry)
FUNCTION st_ymax(box3d)
FUNCTION st_ymin(box3d)
FUNCTION st_z(geometry)
FUNCTION st_zmax(box3d)
FUNCTION st_zmflag(geometry)
FUNCTION st_zmin(box3d)
FUNCTION summary(geometry)
FUNCTION symdifference(geometry,geometry)
FUNCTION symmetricdifference(geometry,geometry)
FUNCTION text(boolean)
FUNCTION text(geometry)
FUNCTION topoelementarray_append(topoelementarray,topoelement)
FUNCTION topogeo_addgeometry(character varying,public.geometry,double precision)
FUNCTION topogeo_addlinestring(character varying,public.geometry)
FUNCTION topogeo_addlinestring(character varying,public.geometry,double precision)
FUNCTION topogeo_addpoint(character varying,public.geometry,double precision)
FUNCTION topogeo_addpoint(character varying,public.geometry,integer,integer)
FUNCTION topogeo_addpolygon(character varying,public.geometry)
FUNCTION topogeo_addpolygon(character varying,public.geometry,double precision)
FUNCTION topologysummary(character varying)
FUNCTION totopogeom(public.geometry,character varying,integer,double precision)
FUNCTION touches(geometry,geometry)
FUNCTION transform_geometry(geometry,text,text,integer)
FUNCTION transform(geometry,integer)
FUNCTION translate(geometry,double precision,double precision)
FUNCTION translate(geometry,double precision,double precision,double precision)
FUNCTION transscale(geometry,double precision,double precision,double precision,double precision)
FUNCTION unite_garray(geometry[])
FUNCTION unlockrows(text)
FUNCTION updategeometrysrid(character varying,character varying,character varying,character varying,integer)
FUNCTION updategeometrysrid(character varying,character varying,character varying,integer)
FUNCTION updategeometrysrid(character varying,character varying,integer)
FUNCTION update_geometry_stats()
FUNCTION update_geometry_stats(character varying,character varying)
FUNCTION update_the_geom_webmercator()
FUNCTION validatetopology(character varying)
FUNCTION width(chip)
FUNCTION within(geometry,geometry)
FUNCTION x(geometry)
FUNCTION xmax(box2d)
FUNCTION xmax(box3d)
FUNCTION xmin(box2d)
FUNCTION xmin(box3d)
FUNCTION y(geometry)
FUNCTION ymax(box2d)
FUNCTION ymax(box3d)
FUNCTION ymin(box2d)
FUNCTION ymin(box3d)
FUNCTION z(geometry)
FUNCTION zmax(box3d)
FUNCTION zmflag(geometry)
FUNCTION zmin(box3d)
OPERATOR CLASS btree_geography_ops
OPERATOR CLASS btree_geometry_ops
OPERATOR CLASS gist_geography_ops
OPERATOR CLASS gist_geometry_ops
OPERATOR CLASS gist_geometry_ops_2d
OPERATOR CLASS gist_geometry_ops_nd
OPERATOR ~=(geography,geography)
OPERATOR ~(geography,geography)
OPERATOR <<|(geography,geography)
OPERATOR <<(geography,geography)
OPERATOR <=(geography,geography)
OPERATOR <(geography,geography)
OPERATOR =(geography,geography)
OPERATOR >=(geography,geography)
OPERATOR >>(geography,geography)
OPERATOR >(geography,geography)
OPERATOR |>>(geography,geography)
OPERATOR |&>(geography,geography)
OPERATOR @(geography,geography)
OPERATOR &<|(geography,geography)
OPERATOR &<(geography,geography)
OPERATOR &>(geography,geography)
OPERATOR &&(geography,geography)
OPERATOR &&&(geography,geography)
OPERATOR ~=(geometry,geometry)
OPERATOR ~(geometry,geometry)
OPERATOR <<|(geometry,geometry)
OPERATOR <<(geometry,geometry)
OPERATOR <=(geometry,geometry)
OPERATOR <->(geometry,geometry)
OPERATOR <(geometry,geometry)
OPERATOR <#>(geometry,geometry)
OPERATOR =(geometry,geometry)
OPERATOR >=(geometry,geometry)
OPERATOR >>(geometry,geometry)
OPERATOR >(geometry,geometry)
OPERATOR |>>(geometry,geometry)
OPERATOR |&>(geometry,geometry)
OPERATOR @(geometry,geometry)
OPERATOR &<|(geometry,geometry)
OPERATOR &<(geometry,geometry)
OPERATOR &>(geometry,geometry)
OPERATOR &&(geometry,geometry)
OPERATOR &&&(geometry,geometry)
OPERATOR ~(geometry,raster)
OPERATOR &&(geometry,raster)
OPERATOR ~(raster,geometry)
OPERATOR &&(raster,geometry)
OPERATOR ~=(raster,raster)
OPERATOR ~(raster,raster)
OPERATOR <<|(raster,raster)
OPERATOR <<(raster,raster)
OPERATOR >>(raster,raster)
OPERATOR |>>(raster,raster)
OPERATOR |&>(raster,raster)
OPERATOR @(raster,raster)
OPERATOR &<|(raster,raster)
OPERATOR &<(raster,raster)
OPERATOR &>(raster,raster)
OPERATOR &&(raster,raster)
PROCEDURALLANGUAGE plpgsql
RULE geometry_columns_delete
RULE geometry_columns_insert
RULE geometry_columns_update
SCHEMA topology
SEQUENCE topology_id_seq
SHELLTYPE box2d
SHELLTYPE box2df
SHELLTYPE box3d
SHELLTYPE box3d_extent
SHELLTYPE chip
SHELLTYPE geography
SHELLTYPE geometry
SHELLTYPE gidx
SHELLTYPE pgis_abs
SHELLTYPE raster
SHELLTYPE spheroid
TABLE DATA geography_columns
TABLE DATA geometry_columns
TABLE DATA raster_columns
TABLE DATA raster_overviews
TABLE geography_columns
TABLE geometry_columns
TABLE layer
TABLE raster_columns
TABLE raster_overviews
TABLE spatial_ref_sys
TABLE topology
TRIGGER layer_integrity_checks
TYPE box2d
TYPE box2df
TYPE box3d
TYPE box3d_extent
TYPE chip
TYPE geography
TYPE geometry
TYPE geometry_dump
TYPE geomval
TYPE getfaceedges_returntype
TYPE gidx
TYPE histogram
TYPE histogram2d
TYPE pgis_abs
TYPE quantile
TYPE raster
TYPE rastexpr
TYPE reclassarg
TYPE spheroid
TYPE summarystats
TYPE topogeometry
TYPE validatetopology_returntype
TYPE valid_detail
TYPE valuecount
TYPE wktgeomval
VIEW geography_columns
VIEW geometry_columns
VIEW raster_columns
VIEW raster_overviews
|