-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtodo-table-colums.txt
115 lines (105 loc) · 3.66 KB
/
todo-table-colums.txt
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
SELECT column_name, data_type, is_nullable, is_updatable FROM information_schema.columns WHERE table_catalog = 'domonda_demo' AND table_schema = 'public' AND table_name = 'document' ORDER BY ordinal_position;
SELECT * FROM information_schema.columns WHERE column_name = 'type' AND table_schema = 'public' AND table_name = 'document' ORDER BY ordinal_position;
udt_catalog | domonda_demo
udt_schema | public
udt_name | document_type
SELECT * FROM information_schema.columns WHERE column_name = 'page_images' AND table_schema = 'public' AND table_name = 'document' ORDER BY ordinal_position;
udt_catalog | domonda_demo
udt_schema | pg_catalog
udt_name | _text
domain_catalog | domonda_demo
domain_schema | public
domain_name | bank_bic
udt_catalog | domonda_demo
udt_schema | pg_catalog
udt_name | text
-[ RECORD 1 ]------------+----------------------------
table_catalog | domonda_demo
table_schema | public
table_name | bank_account
column_name | bank_bic
ordinal_position | 1
column_default |
is_nullable | NO
data_type | text
character_maximum_length |
character_octet_length | 1073741824
numeric_precision |
numeric_precision_radix |
numeric_scale |
datetime_precision |
interval_type |
interval_precision |
character_set_catalog |
character_set_schema |
character_set_name |
collation_catalog |
collation_schema |
collation_name |
domain_catalog | domonda_demo
domain_schema | public
domain_name | bank_bic
udt_catalog | domonda_demo
udt_schema | pg_catalog
udt_name | text
scope_catalog |
scope_schema |
scope_name |
maximum_cardinality |
dtd_identifier | 1
is_self_referencing | NO
is_identity | NO
identity_generation |
identity_start |
identity_increment |
identity_maximum |
identity_minimum |
identity_cycle | NO
is_generated | NEVER
generation_expression |
is_updatable | YES
-[ RECORD 1 ]------------+----------------------------
table_catalog | domonda_demo
table_schema | public
table_name | document
column_name | id
ordinal_position | 1
column_default |
is_nullable | NO
data_type | uuid
character_maximum_length |
character_octet_length |
numeric_precision |
numeric_precision_radix |
numeric_scale |
datetime_precision |
interval_type |
interval_precision |
character_set_catalog |
character_set_schema |
character_set_name |
collation_catalog |
collation_schema |
collation_name |
domain_catalog |
domain_schema |
domain_name |
udt_catalog | domonda_demo
udt_schema | pg_catalog
udt_name | uuid
scope_catalog |
scope_schema |
scope_name |
maximum_cardinality |
dtd_identifier | 1
is_self_referencing | NO
is_identity | NO
identity_generation |
identity_start |
identity_increment |
identity_maximum |
identity_minimum |
identity_cycle | NO
is_generated | NEVER
generation_expression |
is_updatable | YES