Author: mdrillin Date: 2011-06-08 15:48:27 -0400 (Wed, 08 Jun 2011) New Revision: 3237 Modified: branches/7.1.1.CP2/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. Fixed Unit Test Modified: branches/7.1.1.CP2/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected =================================================================== --- branches/7.1.1.CP2/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2011-06-08 18:28:42 UTC (rev 3236) +++ branches/7.1.1.CP2/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2011-06-08 19:48:27 UTC (rev 3237) @@ -1,247 +1,247 @@ 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 SearchType 1043 -1 20 20 true false false -49 8 Format 1043 -1 21 255 false false false -50 8 DefaultValue 1043 -1 22 255 false false false -51 8 JavaClass 1043 -1 23 500 true false false -52 8 Precision 23 4 24 10 true false false -53 8 CharOctetLength 23 4 25 10 false false false -54 8 Radix 23 4 26 10 true false false -55 8 UID 1043 -1 27 50 true false false -56 8 Description 1043 -1 28 255 false false false -57 8 OID 23 4 29 10 true false false -58 9 Name 1043 -1 1 100 true false false -59 9 IsStandard 16 1 2 1 false false false -60 9 IsPhysical 16 1 3 1 false false false -61 9 TypeName 1043 -1 4 100 true false false -62 9 JavaClass 1043 -1 5 500 true false false -63 9 Scale 23 4 6 10 false false false -64 9 TypeLength 23 4 7 10 true false false -65 9 NullType 1043 -1 8 20 true false false -66 9 IsSigned 16 1 9 1 true false false -67 9 IsAutoIncremented 16 1 10 1 true false false -68 9 IsCaseSensitive 16 1 11 1 true false false -69 9 Precision 23 4 12 10 true false false -70 9 Radix 23 4 13 10 false false false -71 9 SearchType 1043 -1 14 20 true false false -72 9 UID 1043 -1 15 50 true false false -73 9 RuntimeType 1043 -1 16 64 false false false -74 9 BaseType 1043 -1 17 64 false false false -75 9 Description 1043 -1 18 255 false false false -76 9 OID 23 4 19 10 true false false -77 10 VDBName 1043 -1 1 255 true false false -78 10 SchemaName 1043 -1 2 255 false false false -79 10 TableName 1043 -1 3 2048 true false false -80 10 Name 1043 -1 4 255 true false false -81 10 KeyName 1043 -1 5 255 false false false -82 10 KeyType 1043 -1 6 20 true false false -83 10 RefKeyUID 1043 -1 7 50 false false false -84 10 UID 1043 -1 8 50 true false false -85 10 Position 23 4 9 10 false false false -86 10 OID 23 4 10 10 true false false -87 11 VDBName 1043 -1 1 255 true false false -88 11 SchemaName 1043 -1 2 255 false false false -89 11 TableName 1043 -1 3 2048 true false false -90 11 Name 1043 -1 4 255 true false false -91 11 Description 1043 -1 5 255 false false false -92 11 NameInSource 1043 -1 6 255 false false false -93 11 Type 1043 -1 7 20 true false false -94 11 IsIndexed 16 1 8 1 true false false -95 11 RefKeyUID 1043 -1 9 50 false false false -96 11 UID 1043 -1 10 50 true false false -97 11 OID 23 4 11 10 true false false -98 12 VDBName 1043 -1 1 255 true false false -99 12 SchemaName 1043 -1 2 255 false false false -100 12 ProcedureName 1043 -1 3 255 true false false -101 12 Name 1043 -1 4 255 true false false -102 12 DataType 1043 -1 5 25 true false false -103 12 Position 23 4 6 10 true false false -104 12 Type 1043 -1 7 100 true false false -105 12 Optional 16 1 8 1 true false false -106 12 Precision 23 4 9 10 true false false -107 12 TypeLength 23 4 10 10 true false false -108 12 Scale 23 4 11 10 true false false -109 12 Radix 23 4 12 10 true false false -110 12 NullType 1043 -1 13 10 true false false -111 12 UID 1043 -1 14 50 false false false -112 12 Description 1043 -1 15 255 false false false -113 12 OID 23 4 16 10 true false false -114 13 VDBName 1043 -1 1 255 true false false -115 13 SchemaName 1043 -1 2 255 false false false -116 13 Name 1043 -1 3 255 true false false -117 13 NameInSource 1043 -1 4 255 false false false -118 13 ReturnsResults 16 1 5 1 true false false -119 13 UID 1043 -1 6 50 true false false -120 13 Description 1043 -1 7 255 false false false -121 13 OID 23 4 8 10 true false false -122 14 Name 1043 -1 1 255 true false false -123 14 Value 1043 -1 2 255 true false false -124 14 UID 1043 -1 3 50 true false false -125 14 OID 23 4 4 10 true false false -126 15 PKTABLE_CAT 1043 -1 1 255 false false false -127 15 PKTABLE_SCHEM 1043 -1 2 255 false false false -128 15 PKTABLE_NAME 1043 -1 3 255 false false false -129 15 PKCOLUMN_NAME 1043 -1 4 255 false false false -130 15 FKTABLE_CAT 1043 -1 5 255 false false false -131 15 FKTABLE_SCHEM 1043 -1 6 255 false false false -132 15 FKTABLE_NAME 1043 -1 7 255 false false false -133 15 FKCOLUMN_NAME 1043 -1 8 255 false false false -134 15 KEY_SEQ 21 2 9 5 false false false -135 15 UPDATE_RULE 23 4 10 10 false false false -136 15 DELETE_RULE 23 4 11 10 false false false -137 15 FK_NAME 1043 -1 12 255 false false false -138 15 PK_NAME 1043 -1 13 255 false false false -139 15 DEFERRABILITY 23 4 14 10 false false false -140 16 VDBName 1043 -1 1 255 false false false -141 16 Name 1043 -1 2 255 false false false -142 16 IsPhysical 16 1 3 1 true false false -143 16 UID 1043 -1 4 50 true false false -144 16 Description 1043 -1 5 255 false false false -145 16 PrimaryMetamodelURI 1043 -1 6 255 true false false -146 16 OID 23 4 7 10 true false false -147 17 VDBName 1043 -1 1 255 false false false -148 17 SchemaName 1043 -1 2 255 false false false -149 17 Name 1043 -1 3 255 true false false -150 17 Type 1043 -1 4 20 true false false -151 17 NameInSource 1043 -1 5 255 false false false -152 17 IsPhysical 16 1 6 1 true false false -153 17 SupportsUpdates 16 1 7 1 true false false -154 17 UID 1043 -1 8 50 true false false -155 17 Cardinality 23 4 9 10 true false false -156 17 Description 1043 -1 10 255 false false false -157 17 IsSystem 16 1 11 1 false false false -158 17 IsMaterialized 16 1 12 0 true false false -159 17 OID 23 4 13 10 true false false -160 18 Name 1043 -1 1 255 true false false -161 18 Version 1043 -1 2 50 true false false -162 19 oid 23 4 1 0 false false false -163 19 nspname 1043 -1 2 0 false false false -164 20 oid 23 4 1 0 false false false -165 20 relname 1043 -1 2 0 false false false -166 20 relnamespace 23 4 3 0 false false false -167 20 relkind 1042 1 4 0 false false false -168 20 relam 23 4 5 0 false false false -169 20 reltuples 700 4 6 0 false false false -170 20 relpages 23 4 7 0 false false false -171 20 relhasrules 16 1 8 0 false false false -172 20 relhasoids 1043 -1 9 0 false false false -173 21 oid 23 4 1 0 false false false -174 21 attrelid 23 4 2 0 false false false -175 21 attname 1043 -1 3 0 false false false -176 21 atttypid 23 4 4 0 false false false -177 21 attlen 21 2 5 0 false false false -178 21 attnum 21 2 6 0 false false false -179 21 atttypmod 23 4 7 0 false false false -180 21 attnotnull 16 1 8 0 false false false -181 21 attisdropped 16 1 9 0 false false false -182 21 atthasdef 16 1 10 0 false false false -183 22 oid 23 4 1 0 false false false -184 22 typname 1043 -1 2 0 false false false -185 22 typnamespace 23 4 3 0 false false false -186 22 typlen 21 2 4 0 false false false -187 22 typtype 1042 1 5 0 false false false -188 22 typbasetype 23 4 6 0 false false false -189 22 typtypmod 23 4 7 0 false false false -190 22 typrelid 23 4 8 0 false false false -191 23 oid 23 4 1 0 false false false -192 23 indexrelid 23 4 2 0 false false false -193 23 indrelid 23 4 3 0 false false false -194 23 indisclustered 16 1 4 0 false false false -195 23 indisunique 16 1 5 0 false false false -196 23 indisprimary 16 1 6 0 false false false -197 23 indexprs 1043 -1 7 0 false false false -198 23 indkey 1043 -1 8 0 false false false -199 24 oid 23 4 1 0 false false false -200 24 amname 1043 -1 2 0 false false false -201 25 oid 23 4 1 0 false false false -202 25 proname 1043 -1 2 0 false false false -203 25 proretset 16 1 3 0 false false false -204 25 prorettype 23 4 4 0 false false false -205 25 pronargs 21 2 5 0 false false false -206 25 proargtypes <null> <null> 6 0 false false false -207 25 proargnames <null> <null> 7 0 false false false -208 25 proargmodes <null> <null> 8 0 false false false -209 25 proallargtypes <null> <null> 9 0 false false false -210 25 pronamespace 23 4 10 0 false false false -211 26 oid 23 4 1 0 false false false -212 26 tgconstrrelid 23 4 2 0 false false false -213 26 tgfoid 23 4 3 0 false false false -214 26 tgargs 23 4 4 0 false false false -215 26 tgnargs 23 4 5 0 false false false -216 26 tgdeferrable 16 1 6 0 false false false -217 26 tginitdeferred 16 1 7 0 false false false -218 26 tgconstrname 1043 -1 8 0 false false false -219 26 tgrelid 23 4 9 0 false false false -220 27 adrelid 23 4 1 0 false false false -221 27 adnum 23 4 2 0 false false false -222 27 adbin 1043 -1 3 0 false false false -223 27 adsrc 1043 -1 4 0 false false false -224 28 oid 23 4 1 0 false false false -225 28 datname 1043 -1 2 0 false false false -226 28 encoding 23 4 3 0 false false false -227 28 datlastsysoid 23 4 4 0 false false false -228 28 datallowconn 1042 1 5 0 false false false -229 28 datconfig <null> <null> 6 0 false false false -230 28 datacl <null> <null> 7 0 false false false -231 28 datdba 23 4 8 0 false false false -232 28 dattablespace 23 4 9 0 false false false -233 29 oid 23 4 1 0 false false false -234 29 usename 1043 -1 2 0 false false false -235 29 usecreatedb 16 1 3 0 false false false -236 29 usesuper 16 1 4 0 false false false -237 30 attrelid 23 4 1 0 false false false -238 30 attnum 21 2 2 0 false false false -239 30 attname 1043 -1 3 0 false false false -240 30 relname 1043 -1 4 0 false false false -241 30 nspname 1043 -1 5 0 false false false -242 30 autoinc 16 1 6 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 SearchType 1043 -1 20 24 true false false +49 8 Format 1043 -1 21 259 false false false +50 8 DefaultValue 1043 -1 22 259 false false false +51 8 JavaClass 1043 -1 23 504 true false false +52 8 Precision 23 4 24 14 true false false +53 8 CharOctetLength 23 4 25 14 false false false +54 8 Radix 23 4 26 14 true false false +55 8 UID 1043 -1 27 54 true false false +56 8 Description 1043 -1 28 259 false false false +57 8 OID 23 4 29 14 true false false +58 9 Name 1043 -1 1 104 true false false +59 9 IsStandard 16 1 2 5 false false false +60 9 IsPhysical 16 1 3 5 false false false +61 9 TypeName 1043 -1 4 104 true false false +62 9 JavaClass 1043 -1 5 504 true false false +63 9 Scale 23 4 6 14 false false false +64 9 TypeLength 23 4 7 14 true false false +65 9 NullType 1043 -1 8 24 true false false +66 9 IsSigned 16 1 9 5 true false false +67 9 IsAutoIncremented 16 1 10 5 true false false +68 9 IsCaseSensitive 16 1 11 5 true false false +69 9 Precision 23 4 12 14 true false false +70 9 Radix 23 4 13 14 false false false +71 9 SearchType 1043 -1 14 24 true false false +72 9 UID 1043 -1 15 54 true false false +73 9 RuntimeType 1043 -1 16 68 false false false +74 9 BaseType 1043 -1 17 68 false false false +75 9 Description 1043 -1 18 259 false false false +76 9 OID 23 4 19 14 true false false +77 10 VDBName 1043 -1 1 259 true false false +78 10 SchemaName 1043 -1 2 259 false false false +79 10 TableName 1043 -1 3 2052 true false false +80 10 Name 1043 -1 4 259 true false false +81 10 KeyName 1043 -1 5 259 false false false +82 10 KeyType 1043 -1 6 24 true false false +83 10 RefKeyUID 1043 -1 7 54 false false false +84 10 UID 1043 -1 8 54 true false false +85 10 Position 23 4 9 14 false false false +86 10 OID 23 4 10 14 true false false +87 11 VDBName 1043 -1 1 259 true false false +88 11 SchemaName 1043 -1 2 259 false false false +89 11 TableName 1043 -1 3 2052 true false false +90 11 Name 1043 -1 4 259 true false false +91 11 Description 1043 -1 5 259 false false false +92 11 NameInSource 1043 -1 6 259 false false false +93 11 Type 1043 -1 7 24 true false false +94 11 IsIndexed 16 1 8 5 true false false +95 11 RefKeyUID 1043 -1 9 54 false false false +96 11 UID 1043 -1 10 54 true false false +97 11 OID 23 4 11 14 true false false +98 12 VDBName 1043 -1 1 259 true false false +99 12 SchemaName 1043 -1 2 259 false false false +100 12 ProcedureName 1043 -1 3 259 true false false +101 12 Name 1043 -1 4 259 true false false +102 12 DataType 1043 -1 5 29 true false false +103 12 Position 23 4 6 14 true false false +104 12 Type 1043 -1 7 104 true false false +105 12 Optional 16 1 8 5 true false false +106 12 Precision 23 4 9 14 true false false +107 12 TypeLength 23 4 10 14 true false false +108 12 Scale 23 4 11 14 true false false +109 12 Radix 23 4 12 14 true false false +110 12 NullType 1043 -1 13 14 true false false +111 12 UID 1043 -1 14 54 false false false +112 12 Description 1043 -1 15 259 false false false +113 12 OID 23 4 16 14 true false false +114 13 VDBName 1043 -1 1 259 true false false +115 13 SchemaName 1043 -1 2 259 false false false +116 13 Name 1043 -1 3 259 true false false +117 13 NameInSource 1043 -1 4 259 false false false +118 13 ReturnsResults 16 1 5 5 true false false +119 13 UID 1043 -1 6 54 true false false +120 13 Description 1043 -1 7 259 false false false +121 13 OID 23 4 8 14 true false false +122 14 Name 1043 -1 1 259 true false false +123 14 Value 1043 -1 2 259 true false false +124 14 UID 1043 -1 3 54 true false false +125 14 OID 23 4 4 14 true false false +126 15 PKTABLE_CAT 1043 -1 1 259 false false false +127 15 PKTABLE_SCHEM 1043 -1 2 259 false false false +128 15 PKTABLE_NAME 1043 -1 3 259 false false false +129 15 PKCOLUMN_NAME 1043 -1 4 259 false false false +130 15 FKTABLE_CAT 1043 -1 5 259 false false false +131 15 FKTABLE_SCHEM 1043 -1 6 259 false false false +132 15 FKTABLE_NAME 1043 -1 7 259 false false false +133 15 FKCOLUMN_NAME 1043 -1 8 259 false false false +134 15 KEY_SEQ 21 2 9 9 false false false +135 15 UPDATE_RULE 23 4 10 14 false false false +136 15 DELETE_RULE 23 4 11 14 false false false +137 15 FK_NAME 1043 -1 12 259 false false false +138 15 PK_NAME 1043 -1 13 259 false false false +139 15 DEFERRABILITY 23 4 14 14 false false false +140 16 VDBName 1043 -1 1 259 false false false +141 16 Name 1043 -1 2 259 false false false +142 16 IsPhysical 16 1 3 5 true false false +143 16 UID 1043 -1 4 54 true false false +144 16 Description 1043 -1 5 259 false false false +145 16 PrimaryMetamodelURI 1043 -1 6 259 true false false +146 16 OID 23 4 7 14 true false false +147 17 VDBName 1043 -1 1 259 false false false +148 17 SchemaName 1043 -1 2 259 false false false +149 17 Name 1043 -1 3 259 true false false +150 17 Type 1043 -1 4 24 true false false +151 17 NameInSource 1043 -1 5 259 false false false +152 17 IsPhysical 16 1 6 5 true false false +153 17 SupportsUpdates 16 1 7 5 true false false +154 17 UID 1043 -1 8 54 true false false +155 17 Cardinality 23 4 9 14 true false false +156 17 Description 1043 -1 10 259 false false false +157 17 IsSystem 16 1 11 5 false false false +158 17 IsMaterialized 16 1 12 4 true false false +159 17 OID 23 4 13 14 true false false +160 18 Name 1043 -1 1 259 true false false +161 18 Version 1043 -1 2 54 true false false +162 19 oid 23 4 1 4 false false false +163 19 nspname 1043 -1 2 4 false false false +164 20 oid 23 4 1 4 false false false +165 20 relname 1043 -1 2 4 false false false +166 20 relnamespace 23 4 3 4 false false false +167 20 relkind 1042 1 4 4 false false false +168 20 relam 23 4 5 4 false false false +169 20 reltuples 700 4 6 4 false false false +170 20 relpages 23 4 7 4 false false false +171 20 relhasrules 16 1 8 4 false false false +172 20 relhasoids 1043 -1 9 4 false false false +173 21 oid 23 4 1 4 false false false +174 21 attrelid 23 4 2 4 false false false +175 21 attname 1043 -1 3 4 false false false +176 21 atttypid 23 4 4 4 false false false +177 21 attlen 21 2 5 4 false false false +178 21 attnum 21 2 6 4 false false false +179 21 atttypmod 23 4 7 4 false false false +180 21 attnotnull 16 1 8 4 false false false +181 21 attisdropped 16 1 9 4 false false false +182 21 atthasdef 16 1 10 4 false false false +183 22 oid 23 4 1 4 false false false +184 22 typname 1043 -1 2 4 false false false +185 22 typnamespace 23 4 3 4 false false false +186 22 typlen 21 2 4 4 false false false +187 22 typtype 1042 1 5 4 false false false +188 22 typbasetype 23 4 6 4 false false false +189 22 typtypmod 23 4 7 4 false false false +190 22 typrelid 23 4 8 4 false false false +191 23 oid 23 4 1 4 false false false +192 23 indexrelid 23 4 2 4 false false false +193 23 indrelid 23 4 3 4 false false false +194 23 indisclustered 16 1 4 4 false false false +195 23 indisunique 16 1 5 4 false false false +196 23 indisprimary 16 1 6 4 false false false +197 23 indexprs 1043 -1 7 4 false false false +198 23 indkey 1043 -1 8 4 false false false +199 24 oid 23 4 1 4 false false false +200 24 amname 1043 -1 2 4 false false false +201 25 oid 23 4 1 4 false false false +202 25 proname 1043 -1 2 4 false false false +203 25 proretset 16 1 3 4 false false false +204 25 prorettype 23 4 4 4 false false false +205 25 pronargs 21 2 5 4 false false false +206 25 proargtypes <null> <null> 6 4 false false false +207 25 proargnames <null> <null> 7 4 false false false +208 25 proargmodes <null> <null> 8 4 false false false +209 25 proallargtypes <null> <null> 9 4 false false false +210 25 pronamespace 23 4 10 4 false false false +211 26 oid 23 4 1 4 false false false +212 26 tgconstrrelid 23 4 2 4 false false false +213 26 tgfoid 23 4 3 4 false false false +214 26 tgargs 23 4 4 4 false false false +215 26 tgnargs 23 4 5 4 false false false +216 26 tgdeferrable 16 1 6 4 false false false +217 26 tginitdeferred 16 1 7 4 false false false +218 26 tgconstrname 1043 -1 8 4 false false false +219 26 tgrelid 23 4 9 4 false false false +220 27 adrelid 23 4 1 4 false false false +221 27 adnum 23 4 2 4 false false false +222 27 adbin 1043 -1 3 4 false false false +223 27 adsrc 1043 -1 4 4 false false false +224 28 oid 23 4 1 4 false false false +225 28 datname 1043 -1 2 4 false false false +226 28 encoding 23 4 3 4 false false false +227 28 datlastsysoid 23 4 4 4 false false false +228 28 datallowconn 1042 1 5 4 false false false +229 28 datconfig <null> <null> 6 4 false false false +230 28 datacl <null> <null> 7 4 false false false +231 28 datdba 23 4 8 4 false false false +232 28 dattablespace 23 4 9 4 false false false +233 29 oid 23 4 1 4 false false false +234 29 usename 1043 -1 2 4 false false false +235 29 usecreatedb 16 1 3 4 false false false +236 29 usesuper 16 1 4 4 false false false +237 30 attrelid 23 4 1 4 false false false +238 30 attnum 21 2 2 4 false false false +239 30 attname 1043 -1 3 4 false false false +240 30 relname 1043 -1 4 4 false false false +241 30 nspname 1043 -1 5 4 false false false +242 30 autoinc 16 1 6 4 false false false Row Count : 242 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