Materialize/doc/user/layouts/partials/sql-grammar/create-source-postgres.svg

<svg xmlns="http://www.w3.org/2000/svg" width="707" height="949">
   <polygon points="9 17 1 13 1 21"/>
   <polygon points="17 17 9 13 9 21"/>
   <rect x="31" y="3" width="140" height="32" rx="10"/>
   <rect x="29"
         y="1"
         width="140"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="39" y="21">CREATE SOURCE</text>
   <rect x="211" y="35" width="120" height="32" rx="10"/>
   <rect x="209"
         y="33"
         width="120"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="219" y="53">IF NOT EXISTS</text>
   <rect x="371" y="3" width="82" height="32"/>
   <rect x="369" y="1" width="82" height="32" class="nonterminal"/>
   <text class="nonterminal" x="379" y="21">src_name</text>
   <rect x="141" y="133" width="104" height="32" rx="10"/>
   <rect x="139"
         y="131"
         width="104"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="149" y="151">IN CLUSTER</text>
   <rect x="265" y="133" width="108" height="32"/>
   <rect x="263" y="131" width="108" height="32" class="nonterminal"/>
   <text class="nonterminal" x="273" y="151">cluster_name</text>
   <rect x="413" y="101" width="60" height="32" rx="10"/>
   <rect x="411"
         y="99"
         width="60"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="421" y="119">FROM</text>
   <rect x="493" y="101" width="96" height="32" rx="10"/>
   <rect x="491"
         y="99"
         width="96"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="501" y="119">POSTGRES</text>
   <rect x="128" y="199" width="116" height="32" rx="10"/>
   <rect x="126"
         y="197"
         width="116"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="136" y="217">CONNECTION</text>
   <rect x="264" y="199" width="136" height="32"/>
   <rect x="262" y="197" width="136" height="32" class="nonterminal"/>
   <text class="nonterminal" x="272" y="217">connection_name</text>
   <rect x="420" y="199" width="26" height="32" rx="10"/>
   <rect x="418"
         y="197"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="428" y="217">(</text>
   <rect x="466" y="199" width="116" height="32" rx="10"/>
   <rect x="464"
         y="197"
         width="116"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="474" y="217">PUBLICATION</text>
   <rect x="288" y="265" width="134" height="32"/>
   <rect x="286" y="263" width="134" height="32" class="nonterminal"/>
   <text class="nonterminal" x="296" y="283">publication_name</text>
   <rect x="115" y="375" width="24" height="32" rx="10"/>
   <rect x="113"
         y="373"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="123" y="393">,</text>
   <rect x="159" y="375" width="134" height="32" rx="10"/>
   <rect x="157"
         y="373"
         width="134"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="167" y="393">TEXT COLUMNS</text>
   <rect x="333" y="375" width="26" height="32" rx="10"/>
   <rect x="331"
         y="373"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="341" y="393">(</text>
   <rect x="399" y="375" width="110" height="32"/>
   <rect x="397" y="373" width="110" height="32" class="nonterminal"/>
   <text class="nonterminal" x="407" y="393">column_name</text>
   <rect x="399" y="331" width="24" height="32" rx="10"/>
   <rect x="397"
         y="329"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="407" y="349">,</text>
   <rect x="549" y="375" width="26" height="32" rx="10"/>
   <rect x="547"
         y="373"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="557" y="393">)</text>
   <rect x="342" y="473" width="26" height="32" rx="10"/>
   <rect x="340"
         y="471"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="350" y="491">)</text>
   <rect x="45" y="539" width="138" height="32" rx="10"/>
   <rect x="43"
         y="537"
         width="138"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="53" y="557">FOR ALL TABLES</text>
   <rect x="65" y="627" width="106" height="32" rx="10"/>
   <rect x="63"
         y="625"
         width="106"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="73" y="645">FOR TABLES</text>
   <rect x="191" y="627" width="26" height="32" rx="10"/>
   <rect x="189"
         y="625"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="199" y="645">(</text>
   <rect x="257" y="627" width="96" height="32"/>
   <rect x="255" y="625" width="96" height="32" class="nonterminal"/>
   <text class="nonterminal" x="265" y="645">table_name</text>
   <rect x="393" y="659" width="40" height="32" rx="10"/>
   <rect x="391"
         y="657"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="401" y="677">AS</text>
   <rect x="453" y="659" width="106" height="32"/>
   <rect x="451" y="657" width="106" height="32" class="nonterminal"/>
   <text class="nonterminal" x="461" y="677">subsrc_name</text>
   <rect x="257" y="583" width="24" height="32" rx="10"/>
   <rect x="255"
         y="581"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="265" y="601">,</text>
   <rect x="65" y="747" width="124" height="32" rx="10"/>
   <rect x="63"
         y="745"
         width="124"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="73" y="765">FOR SCHEMAS</text>
   <rect x="209" y="747" width="26" height="32" rx="10"/>
   <rect x="207"
         y="745"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="217" y="765">(</text>
   <rect x="275" y="747" width="114" height="32"/>
   <rect x="273" y="745" width="114" height="32" class="nonterminal"/>
   <text class="nonterminal" x="283" y="765">schema_name</text>
   <rect x="275" y="703" width="24" height="32" rx="10"/>
   <rect x="273"
         y="701"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="283" y="721">,</text>
   <rect x="639" y="627" width="26" height="32" rx="10"/>
   <rect x="637"
         y="625"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="647" y="645">)</text>
   <rect x="121" y="829" width="76" height="32" rx="10"/>
   <rect x="119"
         y="827"
         width="76"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="129" y="847">EXPOSE</text>
   <rect x="217" y="829" width="96" height="32" rx="10"/>
   <rect x="215"
         y="827"
         width="96"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="225" y="847">PROGRESS</text>
   <rect x="333" y="829" width="40" height="32" rx="10"/>
   <rect x="331"
         y="827"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="341" y="847">AS</text>
   <rect x="393" y="829" width="196" height="32"/>
   <rect x="391" y="827" width="196" height="32" class="nonterminal"/>
   <text class="nonterminal" x="401" y="847">progress_subsource_name</text>
   <rect x="557" y="915" width="102" height="32"/>
   <rect x="555" y="913" width="102" height="32" class="nonterminal"/>
   <text class="nonterminal" x="565" y="933">with_options</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m140 0 h10 m20 0 h10 m0 0 h130 m-160 0 h20 m140 0 h20 m-180 0 q10 0 10 10 m160 0 q0 -10 10 -10 m-170 10 v12 m160 0 v-12 m-160 12 q0 10 10 10 m140 0 q10 0 10 -10 m-150 10 h10 m120 0 h10 m20 -32 h10 m82 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-376 98 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h242 m-272 0 h20 m252 0 h20 m-292 0 q10 0 10 10 m272 0 q0 -10 10 -10 m-282 10 v12 m272 0 v-12 m-272 12 q0 10 10 10 m252 0 q10 0 10 -10 m-262 10 h10 m104 0 h10 m0 0 h10 m108 0 h10 m20 -32 h10 m60 0 h10 m0 0 h10 m96 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-505 98 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m116 0 h10 m0 0 h10 m136 0 h10 m0 0 h10 m26 0 h10 m0 0 h10 m116 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-338 66 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m134 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-371 110 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m24 0 h10 m0 0 h10 m134 0 h10 m20 0 h10 m26 0 h10 m20 0 h10 m110 0 h10 m-150 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m130 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-130 0 h10 m24 0 h10 m0 0 h86 m20 44 h10 m26 0 h10 m-282 0 h20 m262 0 h20 m-302 0 q10 0 10 10 m282 0 q0 -10 10 -10 m-292 10 v14 m282 0 v-14 m-282 14 q0 10 10 10 m262 0 q10 0 10 -10 m-272 10 h10 m0 0 h252 m-500 -34 h20 m500 0 h20 m-540 0 q10 0 10 10 m520 0 q0 -10 10 -10 m-530 10 v30 m520 0 v-30 m-520 30 q0 10 10 10 m500 0 q10 0 10 -10 m-510 10 h10 m0 0 h490 m22 -50 l2 0 m2 0 l2 0 m2 0 l2 0 m-317 98 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m26 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-387 66 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m138 0 h10 m0 0 h482 m-660 0 h20 m640 0 h20 m-680 0 q10 0 10 10 m660 0 q0 -10 10 -10 m-670 10 v68 m660 0 v-68 m-660 68 q0 10 10 10 m640 0 q10 0 10 -10 m-630 10 h10 m106 0 h10 m0 0 h10 m26 0 h10 m20 0 h10 m96 0 h10 m20 0 h10 m0 0 h176 m-206 0 h20 m186 0 h20 m-226 0 q10 0 10 10 m206 0 q0 -10 10 -10 m-216 10 v12 m206 0 v-12 m-206 12 q0 10 10 10 m186 0 q10 0 10 -10 m-196 10 h10 m40 0 h10 m0 0 h10 m106 0 h10 m-342 -32 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m342 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-342 0 h10 m24 0 h10 m0 0 h298 m-554 44 h20 m554 0 h20 m-594 0 q10 0 10 10 m574 0 q0 -10 10 -10 m-584 10 v100 m574 0 v-100 m-574 100 q0 10 10 10 m554 0 q10 0 10 -10 m-564 10 h10 m124 0 h10 m0 0 h10 m26 0 h10 m20 0 h10 m114 0 h10 m-154 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m134 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-134 0 h10 m24 0 h10 m0 0 h90 m20 44 h190 m20 -120 h10 m26 0 h10 m22 -88 l2 0 m2 0 l2 0 m2 0 l2 0 m-628 258 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h478 m-508 0 h20 m488 0 h20 m-528 0 q10 0 10 10 m508 0 q0 -10 10 -10 m-518 10 v12 m508 0 v-12 m-508 12 q0 10 10 10 m488 0 q10 0 10 -10 m-498 10 h10 m76 0 h10 m0 0 h10 m96 0 h10 m0 0 h10 m40 0 h10 m0 0 h10 m196 0 h10 m22 -32 l2 0 m2 0 l2 0 m2 0 l2 0 m-116 86 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h112 m-142 0 h20 m122 0 h20 m-162 0 q10 0 10 10 m142 0 q0 -10 10 -10 m-152 10 v12 m142 0 v-12 m-142 12 q0 10 10 10 m122 0 q10 0 10 -10 m-132 10 h10 m102 0 h10 m23 -32 h-3"/>
   <polygon points="697 897 705 893 705 901"/>
   <polygon points="697 897 689 893 689 901"/>
</svg>