create_view.sublime-snippet

<snippet>
    <content><![CDATA[CREATE VIEW ${1:view_name} (${2:view_column01}${3:,${4:view_column02}}) AS SELECT ${5:table_column01}${6:,${7:table_column02}} FROM ${8:table_name}${0:};]]></content>
    <!-- Optional: Set a tabTrigger to define how to trigger the snippet -->
    <tabTrigger>cv</tabTrigger>
    <!-- Optional: Set a scope to limit where the snippet will trigger -->
    <scope>source.sql, source.pgsql</scope>
    <description>create view</description>
</snippet>