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
|
# frozen_string_literal: true
module Gitlab
module Database
module SchemaValidation
class PgTypes
TYPES = {
'bool' => 'boolean',
'bytea' => 'bytea',
'char' => '"char"',
'int8' => 'bigint',
'int2' => 'smallint',
'int4' => 'integer',
'regproc' => 'regproc',
'text' => 'text',
'oid' => 'oid',
'tid' => 'tid',
'xid' => 'xid',
'cid' => 'cid',
'json' => 'json',
'xml' => 'xml',
'pg_node_tree' => 'pg_node_tree',
'pg_ndistinct' => 'pg_ndistinct',
'pg_dependencies' => 'pg_dependencies',
'pg_mcv_list' => 'pg_mcv_list',
'xid8' => 'xid8',
'path' => 'path',
'polygon' => 'polygon',
'float4' => 'real',
'float8' => 'double precision',
'circle' => 'circle',
'money' => 'money',
'macaddr' => 'macaddr',
'inet' => 'inet',
'cidr' => 'cidr',
'macaddr8' => 'macaddr8',
'aclitem' => 'aclitem',
'bpchar' => 'character',
'varchar' => 'character varying',
'date' => 'date',
'time' => 'time without time zone',
'timestamp' => 'timestamp without time zone',
'timestamptz' => 'timestamp with time zone',
'interval' => 'interval',
'timetz' => 'time with time zone',
'bit' => 'bit',
'varbit' => 'bit varying',
'numeric' => 'numeric',
'refcursor' => 'refcursor',
'regprocedure' => 'regprocedure',
'regoper' => 'regoper',
'regoperator' => 'regoperator',
'regclass' => 'regclass',
'regcollation' => 'regcollation',
'regtype' => 'regtype',
'regrole' => 'regrole',
'regnamespace' => 'regnamespace',
'uuid' => 'uuid',
'pg_lsn' => 'pg_lsn',
'tsvector' => 'tsvector',
'gtsvector' => 'gtsvector',
'tsquery' => 'tsquery',
'regconfig' => 'regconfig',
'regdictionary' => 'regdictionary',
'jsonb' => 'jsonb',
'jsonpath' => 'jsonpath',
'txid_snapshot' => 'txid_snapshot',
'pg_snapshot' => 'pg_snapshot'
}.freeze
end
end
end
end
|