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