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