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
|
# SQL definition for database model
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.
[-- ** Database generated with pgModeler (PostgreSQL Database Modeler).] $br
[-- ** pgModeler version: ] {pgmodeler-ver} $br
[-- ** PostgreSQL version: ] {pgsql-ver} $br
[-- ** Project Site: pgmodeler.io] $br
[-- ** Model Author: ]
@include "ddlend"
%if {author} %then
{author}
%else
---
%end
$br
%if {export-to-file} %then
%if {role} %then
{role}
%end
%if {tablespace} %then
[-- ** Tablespaces creation must be performed outside a multi lined SQL file. ] $br
[-- ** These commands were put in this file only as a convenience.] $br $br
{tablespace} $br
%end
$br
%if {database} %then
[-- ** Database creation must be performed outside a multi lined SQL file. ] $br
[-- ** These commands were put in this file only as a convenience.] $br $br
{database} $br
%end
%end
%if {function} %then
[SET check_function_bodies = false;]
{ddl-end} $br
%end
%if {schema} %then
{schema}
%end
%if {search-path} %then
[SET search_path TO ] {search-path};
{ddl-end} $br
%end
%if {shell-types} %then
{shell-types}
%end
%if {objects} %then
{objects}
%end
%if {permission} %then
{permission}
%end
$br
|
