This file is indexed.

/usr/share/pgmodeler/schemas/sql/view.sch is in pgmodeler-common 0.9.1~beta-1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
# SQL definition for views
# PostgreSQL Version: 9.x
# CAUTION: Do not modify this file unless you know what you are doing.
#          Code generation can be broken if incorrect changes are made.

[-- object: ] {name} [ | type: ] {sql-object} [ --] $br

[-- ] {drop}

 %if {prepended-sql} %then
   {prepended-sql}
   $br [-- ddl-end --] $br $br
 %end

[CREATE ]

%if ({pgsql-ver} >=f "9.3") %then
  %if {recursive} %then
    [RECURSIVE ]
  %else
    %if {materialized} %then
      [MATERIALIZED ]
    %end
  %end
%end

VIEW $sp {name}

%if {columns} %then
[ (] {columns} [)]
%end

$br

%if ({pgsql-ver} >=f "9.3") %then
  %if {materialized} %and {tablespace} %then
    TABLESPACE $sp {tablespace} $br
  %end
%end

[AS ] $br

#Commom table expression (CTE)
%if {cte-exp} %then
 [WITH ] {cte-exp}
%end

$br {definition}

%if ({pgsql-ver} >=f "9.3") %then
  %if {materialized} %and {with-no-data} %then
    $br [WITH NO DATA]
  %end
%end


# This is a special token that pgModeler recognizes as end of DDL command
# when exporting models directly to DBMS. DO NOT REMOVE THIS TOKEN!
$br [-- ddl-end --] $br

%if {comment} %then {comment} %end
%if {owner} %then {owner} %end

%if {appended-sql} %then
 {appended-sql}
 $br [-- ddl-end --] $br
%end

$br