Module: VHSKit::OID

Defined in:
lib/vhskit/oid.rb

Overview

Source for OIDs: jdbc.postgresql.org/development/privateapi/constant-values.html#org.postgresql.core.Oid.INT4

Constant Summary collapse

BIT = 
1560
BIT_ARRAY = 
1561
BOOL = 
16
BOOL_ARRAY = 
1000
BPCHAR = 
1042
BPCHAR_ARRAY = 
1014
BYTEA = 
17
BYTEA_ARRAY = 
1001
CHAR = 
18
CHAR_ARRAY = 
1002
DATE = 
1082
DATE_ARRAY = 
1182
FLOAT4 = 
700
FLOAT4_ARRAY = 
1021
FLOAT8 = 
701
FLOAT8_ARRAY = 
1022
INT2 = 
21
INT2_ARRAY = 
1005
INT4 = 
23
INT4_ARRAY = 
1007
INT8 = 
20
INT8_ARRAY = 
1016
INTERVAL = 
1186
INTERVAL_ARRAY = 
1187
MONEY = 
790
MONEY_ARRAY = 
791
NAME = 
19
NAME_ARRAY = 
1003
NUMERIC = 
1700
NUMERIC_ARRAY = 
1231
OID = 
26
OID_ARRAY = 
1028
TEXT = 
25
TEXT_ARRAY = 
1009
TIME = 
1083
TIME_ARRAY = 
1183
TIMESTAMP = 
1114
TIMESTAMP_ARRAY = 
1115
TIMESTAMPTZ = 
1184
TIMESTAMPTZ_ARRAY = 
1185
TIMETZ = 
1266
TIMETZ_ARRAY = 
1270
UNSPECIFIED = 
0
UUID = 
2950
UUID_ARRAY = 
2951
VARBIT = 
1562
VARBIT_ARRAY = 
1563
VARCHAR = 
1043
VARCHAR_ARRAY = 
1015
VOID = 
2278
XML = 
142
XML_ARRAY = 
143

Class Method Summary collapse

Class Method Details

.by_name(name) ⇒ Object 



60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
 
# File 'lib/vhskit/oid.rb', line 60

def self.by_name(name)
  name = name.upcase

  array = false
  if name =~ /^(.+)\[\]$/
    name = $1
    array = true
  end

  if name =~ /^(.+) WITHOUT TIME ZONE$/
    name = $1
  end

  if name =~ /^(.+) WITH TIME ZONE$/
    name = "#{$1}TZ"
  end

  if array
    name << "_ARRAY"
  end

  const_get name
end