/usr/share/pgmodeler/schemas/sql/usertype.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 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 | # SQL definition for user defined types
# 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}
[CREATE TYPE ] {name}
%if {reduced-form} %then
; $br [-- ddl-end --] $br $br
%else
%if {prepended-sql} %then
{prepended-sql}
$br [-- ddl-end --] $br $br
%end
%if {base} %then
[ (] $br
%else
[ AS] $br
%end
%if {composite} %then
( $br {typeattrib} $br );
%end
%if {enumeration} %then
[ ENUM ] (
%if {enumerations} %then {enumerations} %end
[);]
%end
%if ({pgsql-ver} >=f "9.2") %and {range} %then
[RANGE (] $br
[SUBTYPE = ] {subtype}
%if {collation} %then $br [, COLLATE = ] {collation} %end
%if {opclass} %then $br [, SUBTYPE_OPCLASS = ] {opclass} %end
%if {canonical} %then $br [, CANONICAL = ] {canonical} %end
%if {subtypediff} %then $br [, SUBTYPE_DIFF = ] {subtypediff} %end
);
%end
%if {base} %then
%if {input} %then $tb [INPUT = ] {input}, $br %end
%if {output} %then $tb [OUTPUT = ] {output} $br %end
%if {receive} %then $tb [, RECEIVE = ] {receive} $br %end
%if {send} %then $tb [, SEND = ] {send} $br %end
%if {tpmodin} %then $tb [, TYPMOD_IN = ] {tpmodin} $br %end
%if {tpmodout} %then $tb [, TYPMOD_OUT = ] {tpmodout} $br %end
%if {analyze} %then $tb [, ANALYZE = ] {analyze} $br %end
%if {internal-length} %then $tb [, INTERNALLENGTH = ] {internal-length} $br %end
%if {by-value} %then $tb [, PASSEDBYVALUE ] $br %end
%if {alignment} %then $tb [, ALIGNMENT = ] {alignment} $br %end
%if {storage} %then $tb [, STORAGE = ] {storage} $br %end
%if {default-value} %then $tb [, DEFAULT = ] {default-value} $br %end
%if {element} %then $tb [, ELEMENT = ] {element} $br %end
%if {delimiter} %then $tb [, DELIMITER = ] '{delimiter}' $br %end
%if {like-type} %then $tb [, LIKE = ] {like-type} $br %end
%if {category} %then $tb [, CATEGORY = ] '{category}' $br %end
%if {preferred} %then $tb [, PREFERRED = ] true $br %end
%if {collatable} %then $tb [, COLLATABLE = ] true $br %end
);
%end
$br
# This is a special token that pgModeler recognizes as end of DDL command
# when exporting models directly to DBMS. DO NOT REMOVE THIS TOKEN!
[-- ddl-end --] $br
%if {owner} %then {owner} %end
%if {comment} %then {comment} %end
%if {appended-sql} %then
{appended-sql}
$br [-- ddl-end --] $br
%end
$br
%end
|