[teiid-commits] teiid SVN: r3253 - in branches/7.4.x: test-integration/common/src/test/resources/TestODBCSchema and 1 other directory.

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