github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join2.ref.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 NULL 7 AS table_cat, 8 n.nspname 9 AS table_schem, 10 ct.relname 11 AS table_name, 12 a.attname 13 AS column_name, 14 (i.keys).n 15 AS key_seq, 16 ci.relname 17 AS pk_name 18 FROM 19 pg_catalog.pg_class 20 AS ct 21 JOIN pg_catalog.pg_attribute 22 AS a ON 23 ct.oid 24 = a.attrelid 25 JOIN pg_catalog.pg_namespace 26 AS n ON 27 ct.relnamespace 28 = n.oid 29 JOIN ( 30 SELECT 31 i.indexrelid, 32 i.indrelid, 33 i.indisprimary, 34 information_schema._pg_expandarray( 35 i.indkey 36 ) 37 AS keys 38 FROM 39 pg_catalog.pg_index 40 AS i 41 ) 42 AS i ON 43 a.attnum 44 = (i.keys).x 45 AND a.attrelid 46 = i.indrelid 47 JOIN pg_catalog.pg_class 48 AS ci ON 49 ci.oid 50 = i.indexrelid 51 WHERE 52 true 53 AND ct.relname 54 = 'j' 55 AND i.indisprimary 56 ORDER BY 57 table_name, 58 pk_name, 59 key_seq 60 61 22: 62 ---------------------- 63 SELECT 64 NULL AS table_cat, 65 n.nspname 66 AS table_schem, 67 ct.relname 68 AS table_name, 69 a.attname 70 AS column_name, 71 (i.keys).n 72 AS key_seq, 73 ci.relname 74 AS pk_name 75 FROM 76 pg_catalog.pg_class 77 AS ct 78 JOIN pg_catalog.pg_attribute 79 AS a ON 80 ct.oid 81 = a.attrelid 82 JOIN pg_catalog.pg_namespace 83 AS n ON 84 ct.relnamespace 85 = n.oid 86 JOIN ( 87 SELECT 88 i.indexrelid, 89 i.indrelid, 90 i.indisprimary, 91 information_schema._pg_expandarray( 92 i.indkey 93 ) 94 AS keys 95 FROM 96 pg_catalog.pg_index 97 AS i 98 ) 99 AS i ON 100 a.attnum 101 = (i.keys).x 102 AND a.attrelid 103 = i.indrelid 104 JOIN pg_catalog.pg_class 105 AS ci ON 106 ci.oid 107 = i.indexrelid 108 WHERE 109 true 110 AND ct.relname 111 = 'j' 112 AND i.indisprimary 113 ORDER BY 114 table_name, 115 pk_name, 116 key_seq 117 118 24: 119 ------------------------ 120 SELECT 121 NULL AS table_cat, 122 n.nspname 123 AS table_schem, 124 ct.relname 125 AS table_name, 126 a.attname 127 AS column_name, 128 (i.keys).n 129 AS key_seq, 130 ci.relname 131 AS pk_name 132 FROM 133 pg_catalog.pg_class 134 AS ct 135 JOIN pg_catalog.pg_attribute 136 AS a ON 137 ct.oid 138 = a.attrelid 139 JOIN pg_catalog.pg_namespace 140 AS n ON 141 ct.relnamespace 142 = n.oid 143 JOIN ( 144 SELECT 145 i.indexrelid, 146 i.indrelid, 147 i.indisprimary, 148 information_schema._pg_expandarray( 149 i.indkey 150 ) 151 AS keys 152 FROM 153 pg_catalog.pg_index 154 AS i 155 ) 156 AS i ON 157 a.attnum 158 = (i.keys).x 159 AND a.attrelid 160 = i.indrelid 161 JOIN pg_catalog.pg_class 162 AS ci ON 163 ci.oid 164 = i.indexrelid 165 WHERE 166 true 167 AND ct.relname = 'j' 168 AND i.indisprimary 169 ORDER BY 170 table_name, 171 pk_name, 172 key_seq 173 174 25: 175 ------------------------- 176 SELECT 177 NULL AS table_cat, 178 n.nspname 179 AS table_schem, 180 ct.relname 181 AS table_name, 182 a.attname 183 AS column_name, 184 (i.keys).n 185 AS key_seq, 186 ci.relname AS pk_name 187 FROM 188 pg_catalog.pg_class 189 AS ct 190 JOIN pg_catalog.pg_attribute 191 AS a ON 192 ct.oid 193 = a.attrelid 194 JOIN pg_catalog.pg_namespace 195 AS n ON 196 ct.relnamespace 197 = n.oid 198 JOIN ( 199 SELECT 200 i.indexrelid, 201 i.indrelid, 202 i.indisprimary, 203 information_schema._pg_expandarray( 204 i.indkey 205 ) 206 AS keys 207 FROM 208 pg_catalog.pg_index 209 AS i 210 ) 211 AS i ON 212 a.attnum 213 = (i.keys).x 214 AND a.attrelid 215 = i.indrelid 216 JOIN pg_catalog.pg_class 217 AS ci ON 218 ci.oid 219 = i.indexrelid 220 WHERE 221 true 222 AND ct.relname = 'j' 223 AND i.indisprimary 224 ORDER BY 225 table_name, 226 pk_name, 227 key_seq 228 229 26: 230 -------------------------- 231 SELECT 232 NULL AS table_cat, 233 n.nspname 234 AS table_schem, 235 ct.relname 236 AS table_name, 237 a.attname 238 AS column_name, 239 (i.keys).n AS key_seq, 240 ci.relname AS pk_name 241 FROM 242 pg_catalog.pg_class 243 AS ct 244 JOIN pg_catalog.pg_attribute 245 AS a ON 246 ct.oid 247 = a.attrelid 248 JOIN pg_catalog.pg_namespace 249 AS n ON 250 ct.relnamespace 251 = n.oid 252 JOIN ( 253 SELECT 254 i.indexrelid, 255 i.indrelid, 256 i.indisprimary, 257 information_schema._pg_expandarray( 258 i.indkey 259 ) 260 AS keys 261 FROM 262 pg_catalog.pg_index 263 AS i 264 ) 265 AS i ON 266 a.attnum 267 = (i.keys).x 268 AND a.attrelid 269 = i.indrelid 270 JOIN pg_catalog.pg_class 271 AS ci ON 272 ci.oid 273 = i.indexrelid 274 WHERE 275 true 276 AND ct.relname = 'j' 277 AND i.indisprimary 278 ORDER BY 279 table_name, 280 pk_name, 281 key_seq 282 283 29: 284 ----------------------------- 285 SELECT 286 NULL AS table_cat, 287 n.nspname AS table_schem, 288 ct.relname AS table_name, 289 a.attname AS column_name, 290 (i.keys).n AS key_seq, 291 ci.relname AS pk_name 292 FROM 293 pg_catalog.pg_class AS ct 294 JOIN pg_catalog.pg_attribute 295 AS a ON 296 ct.oid 297 = a.attrelid 298 JOIN pg_catalog.pg_namespace 299 AS n ON 300 ct.relnamespace 301 = n.oid 302 JOIN ( 303 SELECT 304 i.indexrelid, 305 i.indrelid, 306 i.indisprimary, 307 information_schema._pg_expandarray( 308 i.indkey 309 ) 310 AS keys 311 FROM 312 pg_catalog.pg_index 313 AS i 314 ) 315 AS i ON 316 a.attnum 317 = (i.keys).x 318 AND a.attrelid 319 = i.indrelid 320 JOIN pg_catalog.pg_class 321 AS ci ON 322 ci.oid 323 = i.indexrelid 324 WHERE 325 true 326 AND ct.relname = 'j' 327 AND i.indisprimary 328 ORDER BY 329 table_name, 330 pk_name, 331 key_seq 332 333 31: 334 ------------------------------- 335 SELECT 336 NULL AS table_cat, 337 n.nspname AS table_schem, 338 ct.relname AS table_name, 339 a.attname AS column_name, 340 (i.keys).n AS key_seq, 341 ci.relname AS pk_name 342 FROM 343 pg_catalog.pg_class AS ct 344 JOIN pg_catalog.pg_attribute 345 AS a ON 346 ct.oid = a.attrelid 347 JOIN pg_catalog.pg_namespace 348 AS n ON 349 ct.relnamespace 350 = n.oid 351 JOIN ( 352 SELECT 353 i.indexrelid, 354 i.indrelid, 355 i.indisprimary, 356 information_schema._pg_expandarray( 357 i.indkey 358 ) 359 AS keys 360 FROM 361 pg_catalog.pg_index 362 AS i 363 ) 364 AS i ON 365 a.attnum 366 = (i.keys).x 367 AND a.attrelid 368 = i.indrelid 369 JOIN pg_catalog.pg_class 370 AS ci ON 371 ci.oid 372 = i.indexrelid 373 WHERE 374 true 375 AND ct.relname = 'j' 376 AND i.indisprimary 377 ORDER BY 378 table_name, 379 pk_name, 380 key_seq 381 382 32: 383 -------------------------------- 384 SELECT 385 NULL AS table_cat, 386 n.nspname AS table_schem, 387 ct.relname AS table_name, 388 a.attname AS column_name, 389 (i.keys).n AS key_seq, 390 ci.relname AS pk_name 391 FROM 392 pg_catalog.pg_class AS ct 393 JOIN pg_catalog.pg_attribute 394 AS a ON 395 ct.oid = a.attrelid 396 JOIN pg_catalog.pg_namespace 397 AS n ON 398 ct.relnamespace 399 = n.oid 400 JOIN ( 401 SELECT 402 i.indexrelid, 403 i.indrelid, 404 i.indisprimary, 405 information_schema._pg_expandarray( 406 i.indkey 407 ) 408 AS keys 409 FROM 410 pg_catalog.pg_index 411 AS i 412 ) 413 AS i ON 414 a.attnum 415 = (i.keys).x 416 AND a.attrelid 417 = i.indrelid 418 JOIN pg_catalog.pg_class 419 AS ci ON 420 ci.oid 421 = i.indexrelid 422 WHERE 423 true 424 AND ct.relname = 'j' 425 AND i.indisprimary 426 ORDER BY 427 table_name, pk_name, key_seq 428 429 33: 430 --------------------------------- 431 SELECT 432 NULL AS table_cat, 433 n.nspname AS table_schem, 434 ct.relname AS table_name, 435 a.attname AS column_name, 436 (i.keys).n AS key_seq, 437 ci.relname AS pk_name 438 FROM 439 pg_catalog.pg_class AS ct 440 JOIN pg_catalog.pg_attribute 441 AS a ON 442 ct.oid = a.attrelid 443 JOIN pg_catalog.pg_namespace 444 AS n ON 445 ct.relnamespace 446 = n.oid 447 JOIN ( 448 SELECT 449 i.indexrelid, 450 i.indrelid, 451 i.indisprimary, 452 information_schema._pg_expandarray( 453 i.indkey 454 ) 455 AS keys 456 FROM 457 pg_catalog.pg_index 458 AS i 459 ) 460 AS i ON 461 a.attnum = (i.keys).x 462 AND a.attrelid 463 = i.indrelid 464 JOIN pg_catalog.pg_class 465 AS ci ON 466 ci.oid = i.indexrelid 467 WHERE 468 true 469 AND ct.relname = 'j' 470 AND i.indisprimary 471 ORDER BY 472 table_name, pk_name, key_seq 473 474 35: 475 ----------------------------------- 476 SELECT 477 NULL AS table_cat, 478 n.nspname AS table_schem, 479 ct.relname AS table_name, 480 a.attname AS column_name, 481 (i.keys).n AS key_seq, 482 ci.relname AS pk_name 483 FROM 484 pg_catalog.pg_class AS ct 485 JOIN pg_catalog.pg_attribute 486 AS a ON 487 ct.oid = a.attrelid 488 JOIN pg_catalog.pg_namespace 489 AS n ON 490 ct.relnamespace = n.oid 491 JOIN ( 492 SELECT 493 i.indexrelid, 494 i.indrelid, 495 i.indisprimary, 496 information_schema._pg_expandarray( 497 i.indkey 498 ) 499 AS keys 500 FROM 501 pg_catalog.pg_index 502 AS i 503 ) 504 AS i ON 505 a.attnum = (i.keys).x 506 AND a.attrelid 507 = i.indrelid 508 JOIN pg_catalog.pg_class 509 AS ci ON 510 ci.oid = i.indexrelid 511 WHERE 512 true 513 AND ct.relname = 'j' 514 AND i.indisprimary 515 ORDER BY 516 table_name, pk_name, key_seq 517 518 37: 519 ------------------------------------- 520 SELECT 521 NULL AS table_cat, 522 n.nspname AS table_schem, 523 ct.relname AS table_name, 524 a.attname AS column_name, 525 (i.keys).n AS key_seq, 526 ci.relname AS pk_name 527 FROM 528 pg_catalog.pg_class AS ct 529 JOIN pg_catalog.pg_attribute 530 AS a ON 531 ct.oid = a.attrelid 532 JOIN pg_catalog.pg_namespace 533 AS n ON 534 ct.relnamespace = n.oid 535 JOIN ( 536 SELECT 537 i.indexrelid, 538 i.indrelid, 539 i.indisprimary, 540 information_schema._pg_expandarray( 541 i.indkey 542 ) 543 AS keys 544 FROM 545 pg_catalog.pg_index 546 AS i 547 ) 548 AS i ON 549 a.attnum = (i.keys).x 550 AND a.attrelid 551 = i.indrelid 552 JOIN pg_catalog.pg_class AS ci ON 553 ci.oid = i.indexrelid 554 WHERE 555 true 556 AND ct.relname = 'j' 557 AND i.indisprimary 558 ORDER BY 559 table_name, pk_name, key_seq 560 561 39: 562 --------------------------------------- 563 SELECT 564 NULL AS table_cat, 565 n.nspname AS table_schem, 566 ct.relname AS table_name, 567 a.attname AS column_name, 568 (i.keys).n AS key_seq, 569 ci.relname AS pk_name 570 FROM 571 pg_catalog.pg_class AS ct 572 JOIN pg_catalog.pg_attribute 573 AS a ON ct.oid = a.attrelid 574 JOIN pg_catalog.pg_namespace 575 AS n ON 576 ct.relnamespace = n.oid 577 JOIN ( 578 SELECT 579 i.indexrelid, 580 i.indrelid, 581 i.indisprimary, 582 information_schema._pg_expandarray( 583 i.indkey 584 ) 585 AS keys 586 FROM 587 pg_catalog.pg_index 588 AS i 589 ) 590 AS i ON 591 a.attnum = (i.keys).x 592 AND a.attrelid = i.indrelid 593 JOIN pg_catalog.pg_class AS ci ON 594 ci.oid = i.indexrelid 595 WHERE 596 true 597 AND ct.relname = 'j' 598 AND i.indisprimary 599 ORDER BY 600 table_name, pk_name, key_seq 601 602 40: 603 ---------------------------------------- 604 SELECT 605 NULL AS table_cat, 606 n.nspname AS table_schem, 607 ct.relname AS table_name, 608 a.attname AS column_name, 609 (i.keys).n AS key_seq, 610 ci.relname AS pk_name 611 FROM 612 pg_catalog.pg_class AS ct 613 JOIN pg_catalog.pg_attribute AS a ON 614 ct.oid = a.attrelid 615 JOIN pg_catalog.pg_namespace AS n ON 616 ct.relnamespace = n.oid 617 JOIN ( 618 SELECT 619 i.indexrelid, 620 i.indrelid, 621 i.indisprimary, 622 information_schema._pg_expandarray( 623 i.indkey 624 ) 625 AS keys 626 FROM 627 pg_catalog.pg_index AS i 628 ) 629 AS i ON 630 a.attnum = (i.keys).x 631 AND a.attrelid = i.indrelid 632 JOIN pg_catalog.pg_class AS ci ON 633 ci.oid = i.indexrelid 634 WHERE 635 true 636 AND ct.relname = 'j' 637 AND i.indisprimary 638 ORDER BY 639 table_name, pk_name, key_seq 640 641 48: 642 ------------------------------------------------ 643 SELECT 644 NULL AS table_cat, 645 n.nspname AS table_schem, 646 ct.relname AS table_name, 647 a.attname AS column_name, 648 (i.keys).n AS key_seq, 649 ci.relname AS pk_name 650 FROM 651 pg_catalog.pg_class AS ct 652 JOIN pg_catalog.pg_attribute AS a ON 653 ct.oid = a.attrelid 654 JOIN pg_catalog.pg_namespace AS n ON 655 ct.relnamespace = n.oid 656 JOIN ( 657 SELECT 658 i.indexrelid, 659 i.indrelid, 660 i.indisprimary, 661 information_schema._pg_expandarray( 662 i.indkey 663 ) 664 AS keys 665 FROM 666 pg_catalog.pg_index AS i 667 ) 668 AS i ON 669 a.attnum = (i.keys).x 670 AND a.attrelid = i.indrelid 671 JOIN pg_catalog.pg_class AS ci ON 672 ci.oid = i.indexrelid 673 WHERE 674 true AND ct.relname = 'j' AND i.indisprimary 675 ORDER BY 676 table_name, pk_name, key_seq 677 678 59: 679 ----------------------------------------------------------- 680 SELECT 681 NULL AS table_cat, 682 n.nspname AS table_schem, 683 ct.relname AS table_name, 684 a.attname AS column_name, 685 (i.keys).n AS key_seq, 686 ci.relname AS pk_name 687 FROM 688 pg_catalog.pg_class AS ct 689 JOIN pg_catalog.pg_attribute AS a ON 690 ct.oid = a.attrelid 691 JOIN pg_catalog.pg_namespace AS n ON 692 ct.relnamespace = n.oid 693 JOIN ( 694 SELECT 695 i.indexrelid, 696 i.indrelid, 697 i.indisprimary, 698 information_schema._pg_expandarray( 699 i.indkey 700 ) 701 AS keys 702 FROM 703 pg_catalog.pg_index AS i 704 ) 705 AS i ON 706 a.attnum = (i.keys).x 707 AND a.attrelid = i.indrelid 708 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 709 WHERE 710 true AND ct.relname = 'j' AND i.indisprimary 711 ORDER BY 712 table_name, pk_name, key_seq 713 714 60: 715 ------------------------------------------------------------ 716 SELECT 717 NULL AS table_cat, 718 n.nspname AS table_schem, 719 ct.relname AS table_name, 720 a.attname AS column_name, 721 (i.keys).n AS key_seq, 722 ci.relname AS pk_name 723 FROM 724 pg_catalog.pg_class AS ct 725 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 726 JOIN pg_catalog.pg_namespace AS n ON 727 ct.relnamespace = n.oid 728 JOIN ( 729 SELECT 730 i.indexrelid, 731 i.indrelid, 732 i.indisprimary, 733 information_schema._pg_expandarray(i.indkey) 734 AS keys 735 FROM 736 pg_catalog.pg_index AS i 737 ) 738 AS i ON 739 a.attnum = (i.keys).x 740 AND a.attrelid = i.indrelid 741 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 742 WHERE 743 true AND ct.relname = 'j' AND i.indisprimary 744 ORDER BY 745 table_name, pk_name, key_seq 746 747 61: 748 ------------------------------------------------------------- 749 SELECT 750 NULL AS table_cat, 751 n.nspname AS table_schem, 752 ct.relname AS table_name, 753 a.attname AS column_name, 754 (i.keys).n AS key_seq, 755 ci.relname AS pk_name 756 FROM 757 pg_catalog.pg_class AS ct 758 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 759 JOIN pg_catalog.pg_namespace AS n ON 760 ct.relnamespace = n.oid 761 JOIN ( 762 SELECT 763 i.indexrelid, 764 i.indrelid, 765 i.indisprimary, 766 information_schema._pg_expandarray(i.indkey) 767 AS keys 768 FROM 769 pg_catalog.pg_index AS i 770 ) 771 AS i ON 772 a.attnum = (i.keys).x AND a.attrelid = i.indrelid 773 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 774 WHERE 775 true AND ct.relname = 'j' AND i.indisprimary 776 ORDER BY 777 table_name, pk_name, key_seq 778 779 64: 780 ---------------------------------------------------------------- 781 SELECT 782 NULL AS table_cat, 783 n.nspname AS table_schem, 784 ct.relname AS table_name, 785 a.attname AS column_name, 786 (i.keys).n AS key_seq, 787 ci.relname AS pk_name 788 FROM 789 pg_catalog.pg_class AS ct 790 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 791 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 792 JOIN ( 793 SELECT 794 i.indexrelid, 795 i.indrelid, 796 i.indisprimary, 797 information_schema._pg_expandarray(i.indkey) 798 AS keys 799 FROM 800 pg_catalog.pg_index AS i 801 ) 802 AS i ON 803 a.attnum = (i.keys).x AND a.attrelid = i.indrelid 804 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 805 WHERE 806 true AND ct.relname = 'j' AND i.indisprimary 807 ORDER BY 808 table_name, pk_name, key_seq 809 810 68: 811 -------------------------------------------------------------------- 812 SELECT 813 NULL AS table_cat, 814 n.nspname AS table_schem, 815 ct.relname AS table_name, 816 a.attname AS column_name, 817 (i.keys).n AS key_seq, 818 ci.relname AS pk_name 819 FROM 820 pg_catalog.pg_class AS ct 821 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 822 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 823 JOIN ( 824 SELECT 825 i.indexrelid, 826 i.indrelid, 827 i.indisprimary, 828 information_schema._pg_expandarray(i.indkey) AS keys 829 FROM 830 pg_catalog.pg_index AS i 831 ) 832 AS i ON 833 a.attnum = (i.keys).x AND a.attrelid = i.indrelid 834 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 835 WHERE 836 true AND ct.relname = 'j' AND i.indisprimary 837 ORDER BY 838 table_name, pk_name, key_seq 839 840 69: 841 --------------------------------------------------------------------- 842 SELECT 843 NULL AS table_cat, 844 n.nspname AS table_schem, 845 ct.relname AS table_name, 846 a.attname AS column_name, 847 (i.keys).n AS key_seq, 848 ci.relname AS pk_name 849 FROM 850 pg_catalog.pg_class AS ct 851 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 852 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 853 JOIN ( 854 SELECT 855 i.indexrelid, 856 i.indrelid, 857 i.indisprimary, 858 information_schema._pg_expandarray(i.indkey) AS keys 859 FROM 860 pg_catalog.pg_index AS i 861 ) 862 AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid 863 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 864 WHERE 865 true AND ct.relname = 'j' AND i.indisprimary 866 ORDER BY 867 table_name, pk_name, key_seq 868 869 110: 870 -------------------------------------------------------------------------------------------------------------- 871 SELECT 872 NULL AS table_cat, 873 n.nspname AS table_schem, 874 ct.relname AS table_name, 875 a.attname AS column_name, 876 (i.keys).n AS key_seq, 877 ci.relname AS pk_name 878 FROM 879 pg_catalog.pg_class AS ct 880 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 881 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 882 JOIN ( 883 SELECT 884 i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys 885 FROM 886 pg_catalog.pg_index AS i 887 ) 888 AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid 889 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 890 WHERE 891 true AND ct.relname = 'j' AND i.indisprimary 892 ORDER BY 893 table_name, pk_name, key_seq 894 895 142: 896 ---------------------------------------------------------------------------------------------------------------------------------------------- 897 SELECT 898 NULL AS table_cat, 899 n.nspname AS table_schem, 900 ct.relname AS table_name, 901 a.attname AS column_name, 902 (i.keys).n AS key_seq, 903 ci.relname AS pk_name 904 FROM 905 pg_catalog.pg_class AS ct 906 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 907 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 908 JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) 909 AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid 910 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 911 WHERE 912 true AND ct.relname = 'j' AND i.indisprimary 913 ORDER BY 914 table_name, pk_name, key_seq 915 916 145: 917 ------------------------------------------------------------------------------------------------------------------------------------------------- 918 SELECT 919 NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name 920 FROM 921 pg_catalog.pg_class AS ct 922 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 923 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 924 JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) 925 AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid 926 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 927 WHERE 928 true AND ct.relname = 'j' AND i.indisprimary 929 ORDER BY 930 table_name, pk_name, key_seq 931 932 150: 933 ------------------------------------------------------------------------------------------------------------------------------------------------------ 934 SELECT 935 NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name 936 FROM 937 pg_catalog.pg_class AS ct 938 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 939 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 940 JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON 941 a.attnum = (i.keys).x AND a.attrelid = i.indrelid 942 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 943 WHERE 944 true AND ct.relname = 'j' AND i.indisprimary 945 ORDER BY 946 table_name, pk_name, key_seq 947 948 200: 949 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 950 SELECT 951 NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name 952 FROM 953 pg_catalog.pg_class AS ct 954 JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid 955 JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid 956 JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid 957 JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 958 WHERE 959 true AND ct.relname = 'j' AND i.indisprimary 960 ORDER BY 961 table_name, pk_name, key_seq 962 963 400: 964 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 965 SELECT 966 NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name 967 FROM 968 pg_catalog.pg_class AS ct JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid 969 WHERE 970 true AND ct.relname = 'j' AND i.indisprimary 971 ORDER BY 972 table_name, pk_name, key_seq 973 974 639: 975 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 976 SELECT NULL AS table_cat, n.nspname AS table_schem, ct.relname AS table_name, a.attname AS column_name, (i.keys).n AS key_seq, ci.relname AS pk_name FROM pg_catalog.pg_class AS ct JOIN pg_catalog.pg_attribute AS a ON ct.oid = a.attrelid JOIN pg_catalog.pg_namespace AS n ON ct.relnamespace = n.oid JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index AS i) AS i ON a.attnum = (i.keys).x AND a.attrelid = i.indrelid JOIN pg_catalog.pg_class AS ci ON ci.oid = i.indexrelid WHERE true AND ct.relname = 'j' AND i.indisprimary ORDER BY table_name, pk_name, key_seq 977 978