Author: mdrillin
Date: 2011-06-17 18:10:42 -0400 (Fri, 17 Jun 2011)
New Revision: 3253
Modified:
branches/7.4.x/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java
branches/7.4.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected
Log:
TEIID-1623 - Resolves issue with ODBC precision and scale data for numeric and string
types.
Modified:
branches/7.4.x/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java
===================================================================
---
branches/7.4.x/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java 2011-06-16
15:20:10 UTC (rev 3252)
+++
branches/7.4.x/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java 2011-06-17
22:10:42 UTC (rev 3253)
@@ -160,7 +160,8 @@
"pt.oid as atttypid," + //$NON-NLS-1$
"pt.typlen as attlen, " + //$NON-NLS-1$
"convert(t1.Position, short) as attnum, " + //$NON-NLS-1$
- "t1.Length as atttypmod, " + //$NON-NLS-1$
+ "(CASE WHEN (t1.DataType = 'bigdecimal' OR t1.DataType =
'biginteger' OR t1.DataType = 'float' OR t1.DataType='double')
THEN (4+(65536*t1.Precision)+t1.Scale) " + //$NON-NLS-1$
+ "ELSE (4+t1.Length) END) as atttypmod, " + //$NON-NLS-1$
"CASE WHEN (t1.NullType = 'No Nulls') THEN true ELSE false END as
attnotnull, " + //$NON-NLS-1$
"false as attisdropped, " + //$NON-NLS-1$
"false as atthasdef " + //$NON-NLS-1$
Modified:
branches/7.4.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected
===================================================================
---
branches/7.4.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2011-06-16
15:20:10 UTC (rev 3252)
+++
branches/7.4.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2011-06-17
22:10:42 UTC (rev 3253)
@@ -1,257 +1,257 @@
integer integer string
integer short short integer boolean boolean boolean
oid attrelid attname
atttypid attlen attnum atttypmod attnotnull attisdropped atthasdef
-1 1 PART_ID
1043 -1 1 4 true false false
-2 1 PART_NAME
1043 -1 2 255 false false false
-3 1 PART_COLOR
1043 -1 3 30 false false false
-4 1 PART_WEIGHT
1043 -1 4 255 false false false
-5 2 SHIPPER_ID
21 2 1 0 true false false
-6 2 SHIPPER_NAME
1043 -1 2 30 false false false
-7 3 STATUS_ID
21 2 1 0 true false false
-8 3 STATUS_NAME
1043 -1 2 30 false false false
-9 4 SUPPLIER_ID
1043 -1 1 10 true false false
-10 4 PART_ID
1043 -1 2 4 true false false
-11 4 QUANTITY
21 2 3 0 false false false
-12 4 SHIPPER_ID
21 2 4 0 false false false
-13 5 SUPPLIER_ID
1043 -1 1 10 true false false
-14 5 SUPPLIER_NAME
1043 -1 2 30 false false false
-15 5 SUPPLIER_STATUS
21 2 3 0 false false false
-16 5 SUPPLIER_CITY
1043 -1 4 30 false false false
-17 5 SUPPLIER_STATE
1043 -1 5 2 false false false
-18 6 VDBName
1043 -1 1 255 true false false
-19 6 SchemaName
1043 -1 2 255 true false false
-20 6 Name
1043 -1 3 255 true false false
-21 6 TargetSchemaName
1043 -1 4 255 false false false
-22 6 TargetName
1043 -1 5 4000 false false false
-23 6 Valid
16 1 6 0 false false false
-24 6 LoadState
1043 -1 7 255 false false false
-25 6 Updated
1114 8 8 0 false false false
-26 6 Cardinality
23 4 9 10 false false false
-27 7 resourcePath
1043 -1 1 255 false false false
-28 7 contents
14939 -1 2 0 false false false
-29 8 VDBName
1043 -1 1 255 true false false
-30 8 SchemaName
1043 -1 2 255 false false false
-31 8 TableName
1043 -1 3 255 true false false
-32 8 Name
1043 -1 4 255 true false false
-33 8 Position
23 4 5 10 true false false
-34 8 NameInSource
1043 -1 6 255 false false false
-35 8 DataType
1043 -1 7 100 true false false
-36 8 Scale
23 4 8 10 true false false
-37 8 Length
23 4 9 10 true false false
-38 8 IsLengthFixed
16 1 10 1 true false false
-39 8 SupportsSelect
16 1 11 1 true false false
-40 8 SupportsUpdates
16 1 12 1 true false false
-41 8 IsCaseSensitive
16 1 13 1 true false false
-42 8 IsSigned
16 1 14 1 true false false
-43 8 IsCurrency
16 1 15 1 true false false
-44 8 IsAutoIncremented
16 1 16 1 true false false
-45 8 NullType
1043 -1 17 20 true false false
-46 8 MinRange
1043 -1 18 50 false false false
-47 8 MaxRange
1043 -1 19 50 false false false
-48 8 DistinctCount
23 4 20 10 false false false
-49 8 NullCount
23 4 21 10 false false false
-50 8 SearchType
1043 -1 22 20 true false false
-51 8 Format
1043 -1 23 255 false false false
-52 8 DefaultValue
1043 -1 24 255 false false false
-53 8 JavaClass
1043 -1 25 500 true false false
-54 8 Precision
23 4 26 10 true false false
-55 8 CharOctetLength
23 4 27 10 false false false
-56 8 Radix
23 4 28 10 true false false
-57 8 UID
1043 -1 29 50 true false false
-58 8 Description
1043 -1 30 255 false false false
-59 8 OID
23 4 31 10 true false false
-60 9 Name
1043 -1 1 100 true false false
-61 9 IsStandard
16 1 2 1 false false false
-62 9 IsPhysical
16 1 3 1 false false false
-63 9 TypeName
1043 -1 4 100 true false false
-64 9 JavaClass
1043 -1 5 500 true false false
-65 9 Scale
23 4 6 10 false false false
-66 9 TypeLength
23 4 7 10 true false false
-67 9 NullType
1043 -1 8 20 true false false
-68 9 IsSigned
16 1 9 1 true false false
-69 9 IsAutoIncremented
16 1 10 1 true false false
-70 9 IsCaseSensitive
16 1 11 1 true false false
-71 9 Precision
23 4 12 10 true false false
-72 9 Radix
23 4 13 10 false false false
-73 9 SearchType
1043 -1 14 20 true false false
-74 9 UID
1043 -1 15 50 true false false
-75 9 RuntimeType
1043 -1 16 64 false false false
-76 9 BaseType
1043 -1 17 64 false false false
-77 9 Description
1043 -1 18 255 false false false
-78 9 OID
23 4 19 10 true false false
-79 10 VDBName
1043 -1 1 255 true false false
-80 10 SchemaName
1043 -1 2 255 false false false
-81 10 TableName
1043 -1 3 2048 true false false
-82 10 Name
1043 -1 4 255 true false false
-83 10 KeyName
1043 -1 5 255 false false false
-84 10 KeyType
1043 -1 6 20 true false false
-85 10 RefKeyUID
1043 -1 7 50 false false false
-86 10 UID
1043 -1 8 50 true false false
-87 10 Position
23 4 9 10 false false false
-88 10 OID
23 4 10 10 true false false
-89 11 VDBName
1043 -1 1 255 true false false
-90 11 SchemaName
1043 -1 2 255 false false false
-91 11 TableName
1043 -1 3 2048 true false false
-92 11 Name
1043 -1 4 255 true false false
-93 11 Description
1043 -1 5 255 false false false
-94 11 NameInSource
1043 -1 6 255 false false false
-95 11 Type
1043 -1 7 20 true false false
-96 11 IsIndexed
16 1 8 1 true false false
-97 11 RefKeyUID
1043 -1 9 50 false false false
-98 11 UID
1043 -1 10 50 true false false
-99 11 OID
23 4 11 10 true false false
-100 12 VDBName
1043 -1 1 255 true false false
-101 12 SchemaName
1043 -1 2 255 false false false
-102 12 ProcedureName
1043 -1 3 255 true false false
-103 12 Name
1043 -1 4 255 true false false
-104 12 DataType
1043 -1 5 25 true false false
-105 12 Position
23 4 6 10 true false false
-106 12 Type
1043 -1 7 100 true false false
-107 12 Optional
16 1 8 1 true false false
-108 12 Precision
23 4 9 10 true false false
-109 12 TypeLength
23 4 10 10 true false false
-110 12 Scale
23 4 11 10 true false false
-111 12 Radix
23 4 12 10 true false false
-112 12 NullType
1043 -1 13 10 true false false
-113 12 UID
1043 -1 14 50 false false false
-114 12 Description
1043 -1 15 255 false false false
-115 12 OID
23 4 16 10 true false false
-116 13 VDBName
1043 -1 1 255 true false false
-117 13 SchemaName
1043 -1 2 255 false false false
-118 13 Name
1043 -1 3 255 true false false
-119 13 NameInSource
1043 -1 4 255 false false false
-120 13 ReturnsResults
16 1 5 1 true false false
-121 13 UID
1043 -1 6 50 true false false
-122 13 Description
1043 -1 7 255 false false false
-123 13 OID
23 4 8 10 true false false
-124 14 Name
1043 -1 1 255 true false false
-125 14 Value
1043 -1 2 255 true false false
-126 14 UID
1043 -1 3 50 true false false
-127 14 OID
23 4 4 10 true false false
-128 14 ClobValue
14939 -1 5 2097152 false false false
-129 15 PKTABLE_CAT
1043 -1 1 255 false false false
-130 15 PKTABLE_SCHEM
1043 -1 2 255 false false false
-131 15 PKTABLE_NAME
1043 -1 3 255 false false false
-132 15 PKCOLUMN_NAME
1043 -1 4 255 false false false
-133 15 FKTABLE_CAT
1043 -1 5 255 false false false
-134 15 FKTABLE_SCHEM
1043 -1 6 255 false false false
-135 15 FKTABLE_NAME
1043 -1 7 255 false false false
-136 15 FKCOLUMN_NAME
1043 -1 8 255 false false false
-137 15 KEY_SEQ
21 2 9 5 false false false
-138 15 UPDATE_RULE
23 4 10 10 false false false
-139 15 DELETE_RULE
23 4 11 10 false false false
-140 15 FK_NAME
1043 -1 12 255 false false false
-141 15 PK_NAME
1043 -1 13 255 false false false
-142 15 DEFERRABILITY
23 4 14 10 false false false
-143 16 VDBName
1043 -1 1 255 false false false
-144 16 Name
1043 -1 2 255 false false false
-145 16 IsPhysical
16 1 3 1 true false false
-146 16 UID
1043 -1 4 50 true false false
-147 16 Description
1043 -1 5 255 false false false
-148 16 PrimaryMetamodelURI
1043 -1 6 255 true false false
-149 16 OID
23 4 7 10 true false false
-150 17 VDBName
1043 -1 1 255 false false false
-151 17 SchemaName
1043 -1 2 255 false false false
-152 17 Name
1043 -1 3 255 true false false
-153 17 Type
1043 -1 4 20 true false false
-154 17 NameInSource
1043 -1 5 255 false false false
-155 17 IsPhysical
16 1 6 1 true false false
-156 17 SupportsUpdates
16 1 7 1 true false false
-157 17 UID
1043 -1 8 50 true false false
-158 17 Cardinality
23 4 9 10 true false false
-159 17 Description
1043 -1 10 255 false false false
-160 17 IsSystem
16 1 11 1 false false false
-161 17 IsMaterialized
16 1 12 0 true false false
-162 17 OID
23 4 13 10 true false false
-163 18 Name
1043 -1 1 255 true false false
-164 18 Version
1043 -1 2 50 true false false
-165 19 oid
23 4 1 0 false false false
-166 19 nspname
1043 -1 2 0 false false false
-167 20 oid
23 4 1 0 false false false
-168 20 relname
1043 -1 2 0 false false false
-169 20 relnamespace
23 4 3 0 false false false
-170 20 relkind
1042 1 4 0 false false false
-171 20 relam
23 4 5 0 false false false
-172 20 reltuples
700 4 6 0 false false false
-173 20 relpages
23 4 7 0 false false false
-174 20 relhasrules
16 1 8 0 false false false
-175 20 relhasoids
16 1 9 0 false false false
-176 21 oid
23 4 1 0 false false false
-177 21 attrelid
23 4 2 0 false false false
-178 21 attname
1043 -1 3 0 false false false
-179 21 atttypid
23 4 4 0 false false false
-180 21 attlen
21 2 5 0 false false false
-181 21 attnum
21 2 6 0 false false false
-182 21 atttypmod
23 4 7 0 false false false
-183 21 attnotnull
16 1 8 0 false false false
-184 21 attisdropped
16 1 9 0 false false false
-185 21 atthasdef
16 1 10 0 false false false
-186 22 oid
23 4 1 0 false false false
-187 22 typname
1043 -1 2 0 false false false
-188 22 typnamespace
23 4 3 0 false false false
-189 22 typlen
21 2 4 0 false false false
-190 22 typtype
1042 1 5 0 false false false
-191 22 typbasetype
23 4 6 0 false false false
-192 22 typtypmod
23 4 7 0 false false false
-193 22 typrelid
23 4 8 0 false false false
-194 22 typelem
23 4 9 0 false false false
-195 23 oid
23 4 1 0 false false false
-196 23 indexrelid
23 4 2 0 false false false
-197 23 indrelid
23 4 3 0 false false false
-198 23 indisclustered
16 1 4 0 false false false
-199 23 indisunique
16 1 5 0 false false false
-200 23 indisprimary
16 1 6 0 false false false
-201 23 indexprs
1043 -1 7 0 false false false
-202 23 indkey
1043 -1 8 0 false false false
-203 24 oid
23 4 1 0 false false false
-204 24 amname
1043 -1 2 0 false false false
-205 25 oid
23 4 1 0 false false false
-206 25 proname
1043 -1 2 0 false false false
-207 25 proretset
16 1 3 0 false false false
-208 25 prorettype
23 4 4 0 false false false
-209 25 pronargs
21 2 5 0 false false false
-210 25 proargtypes
<null> <null> 6 0 false false false
-211 25 proargnames
<null> <null> 7 0 false false false
-212 25 proargmodes
<null> <null> 8 0 false false false
-213 25 proallargtypes
<null> <null> 9 0 false false false
-214 25 pronamespace
23 4 10 0 false false false
-215 26 oid
23 4 1 0 false false false
-216 26 tgconstrrelid
23 4 2 0 false false false
-217 26 tgfoid
23 4 3 0 false false false
-218 26 tgargs
23 4 4 0 false false false
-219 26 tgnargs
23 4 5 0 false false false
-220 26 tgdeferrable
16 1 6 0 false false false
-221 26 tginitdeferred
16 1 7 0 false false false
-222 26 tgconstrname
1043 -1 8 0 false false false
-223 26 tgrelid
23 4 9 0 false false false
-224 27 adrelid
23 4 1 0 false false false
-225 27 adnum
23 4 2 0 false false false
-226 27 adbin
1043 -1 3 0 false false false
-227 27 adsrc
1043 -1 4 0 false false false
-228 28 oid
23 4 1 0 false false false
-229 28 datname
1043 -1 2 0 false false false
-230 28 encoding
23 4 3 0 false false false
-231 28 datlastsysoid
23 4 4 0 false false false
-232 28 datallowconn
1042 1 5 0 false false false
-233 28 datconfig
<null> <null> 6 0 false false false
-234 28 datacl
<null> <null> 7 0 false false false
-235 28 datdba
23 4 8 0 false false false
-236 28 dattablespace
23 4 9 0 false false false
-237 29 oid
23 4 1 0 false false false
-238 29 usename
1043 -1 2 0 false false false
-239 29 usecreatedb
16 1 3 0 false false false
-240 29 usesuper
16 1 4 0 false false false
-241 30 attrelid
23 4 1 0 false false false
-242 30 attnum
21 2 2 0 false false false
-243 30 attname
1043 -1 3 0 false false false
-244 30 relname
1043 -1 4 0 false false false
-245 30 nspname
1043 -1 5 0 false false false
-246 30 autoinc
16 1 6 0 false false false
-247 30 typoid
23 4 7 0 false false false
-248 31 oid
23 4 1 0 false false false
-249 31 typname
1043 -1 2 0 false false false
-250 31 name
1043 -1 3 0 false false false
-251 31 uid
1043 -1 4 0 false false false
-252 31 typlen
21 2 5 0 false false false
+1 1 PART_ID
1043 -1 1 8 true false false
+2 1 PART_NAME
1043 -1 2 259 false false false
+3 1 PART_COLOR
1043 -1 3 34 false false false
+4 1 PART_WEIGHT
1043 -1 4 259 false false false
+5 2 SHIPPER_ID
21 2 1 4 true false false
+6 2 SHIPPER_NAME
1043 -1 2 34 false false false
+7 3 STATUS_ID
21 2 1 4 true false false
+8 3 STATUS_NAME
1043 -1 2 34 false false false
+9 4 SUPPLIER_ID
1043 -1 1 14 true false false
+10 4 PART_ID
1043 -1 2 8 true false false
+11 4 QUANTITY
21 2 3 4 false false false
+12 4 SHIPPER_ID
21 2 4 4 false false false
+13 5 SUPPLIER_ID
1043 -1 1 14 true false false
+14 5 SUPPLIER_NAME
1043 -1 2 34 false false false
+15 5 SUPPLIER_STATUS
21 2 3 4 false false false
+16 5 SUPPLIER_CITY
1043 -1 4 34 false false false
+17 5 SUPPLIER_STATE
1043 -1 5 6 false false false
+18 6 VDBName
1043 -1 1 259 true false false
+19 6 SchemaName
1043 -1 2 259 true false false
+20 6 Name
1043 -1 3 259 true false false
+21 6 TargetSchemaName
1043 -1 4 259 false false false
+22 6 TargetName
1043 -1 5 4004 false false false
+23 6 Valid
16 1 6 4 false false false
+24 6 LoadState
1043 -1 7 259 false false false
+25 6 Updated
1114 8 8 4 false false false
+26 6 Cardinality
23 4 9 14 false false false
+27 7 resourcePath
1043 -1 1 259 false false false
+28 7 contents
14939 -1 2 4 false false false
+29 8 VDBName
1043 -1 1 259 true false false
+30 8 SchemaName
1043 -1 2 259 false false false
+31 8 TableName
1043 -1 3 259 true false false
+32 8 Name
1043 -1 4 259 true false false
+33 8 Position
23 4 5 14 true false false
+34 8 NameInSource
1043 -1 6 259 false false false
+35 8 DataType
1043 -1 7 104 true false false
+36 8 Scale
23 4 8 14 true false false
+37 8 Length
23 4 9 14 true false false
+38 8 IsLengthFixed
16 1 10 5 true false false
+39 8 SupportsSelect
16 1 11 5 true false false
+40 8 SupportsUpdates
16 1 12 5 true false false
+41 8 IsCaseSensitive
16 1 13 5 true false false
+42 8 IsSigned
16 1 14 5 true false false
+43 8 IsCurrency
16 1 15 5 true false false
+44 8 IsAutoIncremented
16 1 16 5 true false false
+45 8 NullType
1043 -1 17 24 true false false
+46 8 MinRange
1043 -1 18 54 false false false
+47 8 MaxRange
1043 -1 19 54 false false false
+48 8 DistinctCount
23 4 20 14 false false false
+49 8 NullCount
23 4 21 14 false false false
+50 8 SearchType
1043 -1 22 24 true false false
+51 8 Format
1043 -1 23 259 false false false
+52 8 DefaultValue
1043 -1 24 259 false false false
+53 8 JavaClass
1043 -1 25 504 true false false
+54 8 Precision
23 4 26 14 true false false
+55 8 CharOctetLength
23 4 27 14 false false false
+56 8 Radix
23 4 28 14 true false false
+57 8 UID
1043 -1 29 54 true false false
+58 8 Description
1043 -1 30 259 false false false
+59 8 OID
23 4 31 14 true false false
+60 9 Name
1043 -1 1 104 true false false
+61 9 IsStandard
16 1 2 5 false false false
+62 9 IsPhysical
16 1 3 5 false false false
+63 9 TypeName
1043 -1 4 104 true false false
+64 9 JavaClass
1043 -1 5 504 true false false
+65 9 Scale
23 4 6 14 false false false
+66 9 TypeLength
23 4 7 14 true false false
+67 9 NullType
1043 -1 8 24 true false false
+68 9 IsSigned
16 1 9 5 true false false
+69 9 IsAutoIncremented
16 1 10 5 true false false
+70 9 IsCaseSensitive
16 1 11 5 true false false
+71 9 Precision
23 4 12 14 true false false
+72 9 Radix
23 4 13 14 false false false
+73 9 SearchType
1043 -1 14 24 true false false
+74 9 UID
1043 -1 15 54 true false false
+75 9 RuntimeType
1043 -1 16 68 false false false
+76 9 BaseType
1043 -1 17 68 false false false
+77 9 Description
1043 -1 18 259 false false false
+78 9 OID
23 4 19 14 true false false
+79 10 VDBName
1043 -1 1 259 true false false
+80 10 SchemaName
1043 -1 2 259 false false false
+81 10 TableName
1043 -1 3 2052 true false false
+82 10 Name
1043 -1 4 259 true false false
+83 10 KeyName
1043 -1 5 259 false false false
+84 10 KeyType
1043 -1 6 24 true false false
+85 10 RefKeyUID
1043 -1 7 54 false false false
+86 10 UID
1043 -1 8 54 true false false
+87 10 Position
23 4 9 14 false false false
+88 10 OID
23 4 10 14 true false false
+89 11 VDBName
1043 -1 1 259 true false false
+90 11 SchemaName
1043 -1 2 259 false false false
+91 11 TableName
1043 -1 3 2052 true false false
+92 11 Name
1043 -1 4 259 true false false
+93 11 Description
1043 -1 5 259 false false false
+94 11 NameInSource
1043 -1 6 259 false false false
+95 11 Type
1043 -1 7 24 true false false
+96 11 IsIndexed
16 1 8 5 true false false
+97 11 RefKeyUID
1043 -1 9 54 false false false
+98 11 UID
1043 -1 10 54 true false false
+99 11 OID
23 4 11 14 true false false
+100 12 VDBName
1043 -1 1 259 true false false
+101 12 SchemaName
1043 -1 2 259 false false false
+102 12 ProcedureName
1043 -1 3 259 true false false
+103 12 Name
1043 -1 4 259 true false false
+104 12 DataType
1043 -1 5 29 true false false
+105 12 Position
23 4 6 14 true false false
+106 12 Type
1043 -1 7 104 true false false
+107 12 Optional
16 1 8 5 true false false
+108 12 Precision
23 4 9 14 true false false
+109 12 TypeLength
23 4 10 14 true false false
+110 12 Scale
23 4 11 14 true false false
+111 12 Radix
23 4 12 14 true false false
+112 12 NullType
1043 -1 13 14 true false false
+113 12 UID
1043 -1 14 54 false false false
+114 12 Description
1043 -1 15 259 false false false
+115 12 OID
23 4 16 14 true false false
+116 13 VDBName
1043 -1 1 259 true false false
+117 13 SchemaName
1043 -1 2 259 false false false
+118 13 Name
1043 -1 3 259 true false false
+119 13 NameInSource
1043 -1 4 259 false false false
+120 13 ReturnsResults
16 1 5 5 true false false
+121 13 UID
1043 -1 6 54 true false false
+122 13 Description
1043 -1 7 259 false false false
+123 13 OID
23 4 8 14 true false false
+124 14 Name
1043 -1 1 259 true false false
+125 14 Value
1043 -1 2 259 true false false
+126 14 UID
1043 -1 3 54 true false false
+127 14 OID
23 4 4 14 true false false
+128 14 ClobValue
14939 -1 5 2097156 false false false
+129 15 PKTABLE_CAT
1043 -1 1 259 false false false
+130 15 PKTABLE_SCHEM
1043 -1 2 259 false false false
+131 15 PKTABLE_NAME
1043 -1 3 259 false false false
+132 15 PKCOLUMN_NAME
1043 -1 4 259 false false false
+133 15 FKTABLE_CAT
1043 -1 5 259 false false false
+134 15 FKTABLE_SCHEM
1043 -1 6 259 false false false
+135 15 FKTABLE_NAME
1043 -1 7 259 false false false
+136 15 FKCOLUMN_NAME
1043 -1 8 259 false false false
+137 15 KEY_SEQ
21 2 9 9 false false false
+138 15 UPDATE_RULE
23 4 10 14 false false false
+139 15 DELETE_RULE
23 4 11 14 false false false
+140 15 FK_NAME
1043 -1 12 259 false false false
+141 15 PK_NAME
1043 -1 13 259 false false false
+142 15 DEFERRABILITY
23 4 14 14 false false false
+143 16 VDBName
1043 -1 1 259 false false false
+144 16 Name
1043 -1 2 259 false false false
+145 16 IsPhysical
16 1 3 5 true false false
+146 16 UID
1043 -1 4 54 true false false
+147 16 Description
1043 -1 5 259 false false false
+148 16 PrimaryMetamodelURI
1043 -1 6 259 true false false
+149 16 OID
23 4 7 14 true false false
+150 17 VDBName
1043 -1 1 259 false false false
+151 17 SchemaName
1043 -1 2 259 false false false
+152 17 Name
1043 -1 3 259 true false false
+153 17 Type
1043 -1 4 24 true false false
+154 17 NameInSource
1043 -1 5 259 false false false
+155 17 IsPhysical
16 1 6 5 true false false
+156 17 SupportsUpdates
16 1 7 5 true false false
+157 17 UID
1043 -1 8 54 true false false
+158 17 Cardinality
23 4 9 14 true false false
+159 17 Description
1043 -1 10 259 false false false
+160 17 IsSystem
16 1 11 5 false false false
+161 17 IsMaterialized
16 1 12 4 true false false
+162 17 OID
23 4 13 14 true false false
+163 18 Name
1043 -1 1 259 true false false
+164 18 Version
1043 -1 2 54 true false false
+165 19 oid
23 4 1 4 false false false
+166 19 nspname
1043 -1 2 4 false false false
+167 20 oid
23 4 1 4 false false false
+168 20 relname
1043 -1 2 4 false false false
+169 20 relnamespace
23 4 3 4 false false false
+170 20 relkind
1042 1 4 4 false false false
+171 20 relam
23 4 5 4 false false false
+172 20 reltuples
700 4 6 4 false false false
+173 20 relpages
23 4 7 4 false false false
+174 20 relhasrules
16 1 8 4 false false false
+175 20 relhasoids
16 1 9 4 false false false
+176 21 oid
23 4 1 4 false false false
+177 21 attrelid
23 4 2 4 false false false
+178 21 attname
1043 -1 3 4 false false false
+179 21 atttypid
23 4 4 4 false false false
+180 21 attlen
21 2 5 4 false false false
+181 21 attnum
21 2 6 4 false false false
+182 21 atttypmod
23 4 7 4 false false false
+183 21 attnotnull
16 1 8 4 false false false
+184 21 attisdropped
16 1 9 4 false false false
+185 21 atthasdef
16 1 10 4 false false false
+186 22 oid
23 4 1 4 false false false
+187 22 typname
1043 -1 2 4 false false false
+188 22 typnamespace
23 4 3 4 false false false
+189 22 typlen
21 2 4 4 false false false
+190 22 typtype
1042 1 5 4 false false false
+191 22 typbasetype
23 4 6 4 false false false
+192 22 typtypmod
23 4 7 4 false false false
+193 22 typrelid
23 4 8 4 false false false
+194 22 typelem
23 4 9 4 false false false
+195 23 oid
23 4 1 4 false false false
+196 23 indexrelid
23 4 2 4 false false false
+197 23 indrelid
23 4 3 4 false false false
+198 23 indisclustered
16 1 4 4 false false false
+199 23 indisunique
16 1 5 4 false false false
+200 23 indisprimary
16 1 6 4 false false false
+201 23 indexprs
1043 -1 7 4 false false false
+202 23 indkey
1043 -1 8 4 false false false
+203 24 oid
23 4 1 4 false false false
+204 24 amname
1043 -1 2 4 false false false
+205 25 oid
23 4 1 4 false false false
+206 25 proname
1043 -1 2 4 false false false
+207 25 proretset
16 1 3 4 false false false
+208 25 prorettype
23 4 4 4 false false false
+209 25 pronargs
21 2 5 4 false false false
+210 25 proargtypes
<null> <null> 6 4 false false false
+211 25 proargnames
<null> <null> 7 4 false false false
+212 25 proargmodes
<null> <null> 8 4 false false false
+213 25 proallargtypes
<null> <null> 9 4 false false false
+214 25 pronamespace
23 4 10 4 false false false
+215 26 oid
23 4 1 4 false false false
+216 26 tgconstrrelid
23 4 2 4 false false false
+217 26 tgfoid
23 4 3 4 false false false
+218 26 tgargs
23 4 4 4 false false false
+219 26 tgnargs
23 4 5 4 false false false
+220 26 tgdeferrable
16 1 6 4 false false false
+221 26 tginitdeferred
16 1 7 4 false false false
+222 26 tgconstrname
1043 -1 8 4 false false false
+223 26 tgrelid
23 4 9 4 false false false
+224 27 adrelid
23 4 1 4 false false false
+225 27 adnum
23 4 2 4 false false false
+226 27 adbin
1043 -1 3 4 false false false
+227 27 adsrc
1043 -1 4 4 false false false
+228 28 oid
23 4 1 4 false false false
+229 28 datname
1043 -1 2 4 false false false
+230 28 encoding
23 4 3 4 false false false
+231 28 datlastsysoid
23 4 4 4 false false false
+232 28 datallowconn
1042 1 5 4 false false false
+233 28 datconfig
<null> <null> 6 4 false false false
+234 28 datacl
<null> <null> 7 4 false false false
+235 28 datdba
23 4 8 4 false false false
+236 28 dattablespace
23 4 9 4 false false false
+237 29 oid
23 4 1 4 false false false
+238 29 usename
1043 -1 2 4 false false false
+239 29 usecreatedb
16 1 3 4 false false false
+240 29 usesuper
16 1 4 4 false false false
+241 30 attrelid
23 4 1 4 false false false
+242 30 attnum
21 2 2 4 false false false
+243 30 attname
1043 -1 3 4 false false false
+244 30 relname
1043 -1 4 4 false false false
+245 30 nspname
1043 -1 5 4 false false false
+246 30 autoinc
16 1 6 4 false false false
+247 30 typoid
23 4 7 4 false false false
+248 31 oid
23 4 1 4 false false false
+249 31 typname
1043 -1 2 4 false false false
+250 31 name
1043 -1 3 4 false false false
+251 31 uid
1043 -1 4 4 false false false
+252 31 typlen
21 2 5 4 false false false
Row Count : 252
getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel
getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision
getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable
isReadOnly isSearchable isSigned isWritable
oid 4 PartsSupplier java.lang.Integer oid integer
pg_catalog pg_attribute 11 10 0
false false false false 2 true
true false false
Show replies by date