
org.postgresql.jdbc.PgDatabaseMetaData.class Maven / Gradle / Ivy
The newest version!
???? 4?
j k l mn
opqrtsqtuvw
xy z{
|t}
~
~????t?
o?
o?
o??
o???????????
%j
%??
%??????????
?
?@ ?
o???
o???
???
???
???
Dj??
C???????????????????????t??t???
o??t?????
j?
j?
j?
?? ???t????? ?????
???????
??
o??????
%???
?? ????????tt? ??????? ? ??
o
?
o !"#$%&'()*+,-
?./01?2?3?456789t:;<
?=>?@ABCDEFGHIJKLMNOPQRST
UV ?W ?XYZ[Z\] ?^_ ?` ?Yab
?c
?d
?e
?f
?g ?hi
?jklmnopqrstuvwxyz
j ?{|}~
?
???????????????? ???????????
???????????????t?t??????????
??x
?? ?? ??????????????????????????????????????????????????
??
??
?????
o?
??
????????
??
????
??
??
?
??
o
o
!"#$%&'()*+,-./012 keywords Ljava/lang/String;
ConstantValue
connection "Lorg/postgresql/jdbc/PgConnection; NAMEDATALEN I INDEX_MAX_KEYS tableTypeClauses Ljava/util/Map; Signature XLjava/util/Map;>; %(Lorg/postgresql/jdbc/PgConnection;)V Code LineNumberTable LocalVariableTable this (Lorg/postgresql/jdbc/PgDatabaseMetaData; conn getMaxIndexKeys ()I sql stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet;
StackMapTable3?4
Exceptions getMaxNameLength allProceduresAreCallable ()Z allTablesAreSelectable getURL ()Ljava/lang/String; getUserName
isReadOnly nullsAreSortedHigh nullsAreSortedLow nullsAreSortedAtStart nullsAreSortedAtEnd getDatabaseProductName getDatabaseProductVersion
getDriverName getDriverVersion getDriverMajorVersion getDriverMinorVersion usesLocalFiles usesLocalFilePerTable supportsMixedCaseIdentifiers storesUpperCaseIdentifiers storesLowerCaseIdentifiers storesMixedCaseIdentifiers "supportsMixedCaseQuotedIdentifiers storesUpperCaseQuotedIdentifiers storesLowerCaseQuotedIdentifiers storesMixedCaseQuotedIdentifiers getIdentifierQuoteString getSQLKeywords getNumericFunctions getStringFunctions funcs getSystemFunctions getTimeDateFunctions
timeDateFuncs getSearchStringEscape getExtraNameCharacters supportsAlterTableWithAddColumn supportsAlterTableWithDropColumn supportsColumnAliasing nullPlusNonNullIsNull supportsConvert (II)Z fromType toType supportsTableCorrelationNames &supportsDifferentTableCorrelationNames supportsExpressionsInOrderBy supportsOrderByUnrelated supportsGroupBy supportsGroupByUnrelated supportsGroupByBeyondSelect supportsLikeEscapeClause supportsMultipleResultSets supportsMultipleTransactions supportsNonNullableColumns supportsMinimumSQLGrammar supportsCoreSQLGrammar supportsExtendedSQLGrammar supportsANSI92EntryLevelSQL supportsANSI92IntermediateSQL supportsANSI92FullSQL $supportsIntegrityEnhancementFacility supportsOuterJoins supportsFullOuterJoins supportsLimitedOuterJoins
getSchemaTerm getProcedureTerm getCatalogTerm isCatalogAtStart getCatalogSeparator !supportsSchemasInDataManipulation supportsSchemasInProcedureCalls !supportsSchemasInTableDefinitions !supportsSchemasInIndexDefinitions %supportsSchemasInPrivilegeDefinitions "supportsCatalogsInDataManipulation supportsCatalogsInProcedureCalls "supportsCatalogsInTableDefinitions "supportsCatalogsInIndexDefinitions &supportsCatalogsInPrivilegeDefinitions supportsPositionedDelete supportsPositionedUpdate supportsSelectForUpdate supportsStoredProcedures supportsSubqueriesInComparisons supportsSubqueriesInExists supportsSubqueriesInIns supportsSubqueriesInQuantifieds supportsCorrelatedSubqueries
supportsUnion supportsUnionAll supportsOpenCursorsAcrossCommit !supportsOpenCursorsAcrossRollback "supportsOpenStatementsAcrossCommit $supportsOpenStatementsAcrossRollback getMaxCharLiteralLength getMaxBinaryLiteralLength getMaxColumnNameLength getMaxColumnsInGroupBy getMaxColumnsInIndex getMaxColumnsInOrderBy getMaxColumnsInSelect getMaxColumnsInTable getMaxConnections getMaxCursorNameLength getMaxIndexLength getMaxSchemaNameLength getMaxProcedureNameLength getMaxCatalogNameLength
getMaxRowSize doesMaxRowSizeIncludeBlobs getMaxStatementLength getMaxStatements getMaxTableNameLength getMaxTablesInSelect getMaxUserNameLength getDefaultTransactionIsolation supportsTransactions !supportsTransactionIsolationLevel (I)Z level 5supportsDataDefinitionAndDataManipulationTransactions (supportsDataManipulationTransactionsOnly %dataDefinitionCausesTransactionCommit #dataDefinitionIgnoredInTransactions escapeQuotes &(Ljava/lang/String;)Ljava/lang/String; s sb Ljava/lang/StringBuilder;?
getProcedures L(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; catalog
schemaPattern procedureNamePattern getProcedureColumns ^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; tuple [[B argOid
columnMode i
columnTypeOid columnsql
columnstmt columnrs schema [B
procedureName specificName
returnType returnTypeType returnTypeRelid strArgTypes st Ljava/util/StringTokenizer; argTypes Ljava/util/List; argNames [Ljava/lang/String;
argNamesArray Ljava/sql/Array; argModes
argModesArray numArgs allArgTypes [Ljava/lang/Long; allArgTypesArray columnNamePattern columns f [Lorg/postgresql/core/Field; v isnullableUnknown LocalVariableTypeTable "Ljava/util/List; Ljava/util/List<[[B>;??_?5 getTables _(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet; clause clauses type orclause tableNamePattern types select orderby
useSchemas 5Ljava/util/Map;
getSchemas ()Ljava/sql/ResultSet; :(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; getCatalogs
getTableTypes
getColumns sqlType typeOid typeMod typtype pgType defval
decimalDigits
columnSize baseTypeOid autoinc numberOfFields6 getColumnPrivileges acl relPermissions grantable grants grantor grantee userToGrantable Entry InnerClasses Ljava/util/Map$Entry; privilege grantees permName
schemaName tableName column owner relAcl permissions permNames table kLjava/util/Map;>;>; %Ljava/util/List<[Ljava/lang/String;>; NLjava/util/Map$Entry;>; HLjava/util/Map;>; 7] getTablePrivileges
grantTuple granteeUser
parseACLArray $(Ljava/lang/String;)Ljava/util/List; c C aclString acls inQuotes Z
beginIndex prevChar $Ljava/util/List; 8(Ljava/lang/String;)Ljava/util/List; addACLPrivileges $(Ljava/lang/String;Ljava/util/Map;)V privs sqlpriv permissionByGrantor usersWithPermission grant
privileges
equalIndex
slashIndex user ?(Ljava/lang/String;Ljava/util/Map;>;>;)V parseACL 5(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map; perms aclArray ?(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map;>;>; getBestRowIdentifier N(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet; scope nullable getVersionColumns getPrimaryKeys getImportedExportedKeys ?(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; primaryCatalog
primarySchema primaryTable foreignCatalog
foreignSchema foreignTable getImportedKeys getExportedKeys getCrossReference getTypeInfo tuple1 typname bZero b10 bf bt bliteral bNullable bSearchable getIndexInfo N(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)Ljava/sql/ResultSet; from where unique approximate supportsResultSetType supportsResultSetConcurrency concurrency ownUpdatesAreVisible ownDeletesAreVisible ownInsertsAreVisible othersUpdatesAreVisible othersDeletesAreVisible othersInsertsAreVisible updatesAreDetected deletesAreDetected insertsAreDetected supportsBatchUpdates getUDTs N(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[I)Ljava/sql/ResultSet; Ljava/util/Iterator; firstQualifier secondQualifier typeNamePattern [I sqlwhen toAdd (Ljava/util/Iterator;3
getConnection ()Ljava/sql/Connection; createMetaDataStatement ()Ljava/sql/Statement; getMaxLogicalLobSize ()J supportsRefCursors getRowIdLifetime ()Ljava/sql/RowIdLifetime; &supportsStoredFunctionsUsingCallSyntax $autoCommitFailureClosesAllResultSets getClientInfoProperties isWrapperFor (Ljava/lang/Class;)Z iface Ljava/lang/Class; Ljava/lang/Class<*>; (Ljava/lang/Class<*>;)Z unwrap %(Ljava/lang/Class;)Ljava/lang/Object; Ljava/lang/Class; 1(Ljava/lang/Class;)TT; getFunctions functionNamePattern getFunctionColumns getPseudoColumns generatedKeyAlwaysReturned supportsSavepoints supportsNamedParameters supportsMultipleOpenResults supportsGetGeneratedKeys
getSuperTypes getSuperTables
getAttributes attributeNamePattern supportsResultSetHoldability holdability getResultSetHoldability getDatabaseMajorVersion getDatabaseMinorVersion getJDBCMajorVersion getJDBCMinorVersion getSQLStateType locatorsUpdateCopy supportsStatementPooling ()V ht
SourceFile PgDatabaseMetaData.java?f?????? FSELECT setting FROM pg_catalog.pg_settings WHERE name='max_index_keys'68;39:;?<f !org/postgresql/util/PSQLException PUnable to determine a value for MaxIndexKeys due to missing system catalog data. java/lang/Object=>?@AB?CDEF<G<H ?SELECT t.typlen FROM pg_catalog.pg_type t, pg_catalog.pg_namespace n WHERE t.typnamespace=n.oid AND t.typname='name' AND n.nspname='pg_catalog' 4Unable to find name datatype in the system catalogs. typlenDI??????
PostgreSQLJ? org/postgresql/util/DriverInfo PostgreSQL JDBC Driver 42.0.0 " &org/postgresql/jdbc/PgDatabaseMetaDataGabort,acl,add,aggregate,append,archive,arch_store,backward,binary,boolean,change,cluster,copy,database,delimiter,delimiters,do,extend,explain,forward,heavy,index,inherits,isnull,light,listen,load,merge,nothing,notify,notnull,oids,purge,rename,replace,retrieve,returns,rule,recipe,setof,stdin,stdout,store,vacuum,verbose,version $org/postgresql/jdbc/EscapedFunctions zabs,acos,asin,atan,atan2,ceiling,cos,cot,degrees,exp,floor,log,log10,mod,pi,power,radians,round,sign,sin,sqrt,tan,truncate Lascii,char,concat,lcase,left,length,ltrim,repeat,rtrim,space,substring,ucase java/lang/StringBuilderKL ,replaceM? database,ifnull,user ocurdate,curtime,dayname,dayofmonth,dayofweek,dayofyear,hour,minute,month,monthname,now,quarter,second,week,year
,timestampadd \ function database .???? java/sql/ConnectionN? E 'Ok java/sql/DatabaseMetaData?SELECT NULL AS PROCEDURE_CAT, n.nspname AS PROCEDURE_SCHEM, p.proname AS PROCEDURE_NAME, NULL, NULL, NULL, d.description AS REMARKS, 2 AS PROCEDURE_TYPE, p.proname || '_' || p.oid AS SPECIFIC_NAME FROM pg_catalog.pg_namespace n, pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_description d ON (p.oid=d.objoid) LEFT JOIN pg_catalog.pg_class c ON (d.classoid=c.oid AND c.relname='pg_proc') LEFT JOIN pg_catalog.pg_namespace pn ON (c.relnamespace=pn.oid AND pn.nspname='pg_catalog') WHERE p.pronamespace=n.oid P? AND n.nspname LIKE jk AND p.proname LIKE 7 ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, p.oid::text :; org/postgresql/core/Field java/util/ArrayList
PROCEDURE_CAT org/postgresql/core/Oid?Q PROCEDURE_SCHEM PROCEDURE_NAME COLUMN_NAME COLUMN_TYPE DATA_TYPE TYPE_NAME PRECISION LENGTH SCALE RADIX NULLABLE REMARKS
COLUMN_DEF
SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTECT_LENGTH ORDINAL_POSITION IS_NULLABLE
SPECIFIC_NAMESELECT n.nspname,p.proname,p.prorettype,p.proargtypes, t.typtype,t.typrelid, p.proargnames, p.proargmodes, p.proallargtypes, p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n, pg_catalog.pg_type t WHERE p.pronamespace=n.oid AND p.prorettype=t.oid , ORDER BY n.nspname, p.proname, p.oid::text nspnameRS pronameTk _ oidUS
prorettypeVW typrelid proargtypes java/util/StringTokenizer?XY?Z?[\]^ proargnames_`5_a proargmodesb? proallargtypes bc^ d e p returnValuedMefghEie $Kj o tk?lm java/lang/Long OSELECT a.attname,a.atttypid FROM pg_catalog.pg_attribute a WHERE a.attrelid = $ AND a.attnum > 0 ORDER BY a.attnum atttypid attname !org/postgresql/core/BaseStatementno SCHEMASSELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid , ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME AND c.relname LIKE AND (false ??lp
java/util/Map java/lang/String OR ( ) ) ??>SELECT nspname AS TABLE_SCHEM, NULL AS TABLE_CATALOG FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND (nspname !~ '^pg_toast_temp_' OR nspname = replace((pg_catalog.current_schemas(true))[1], 'pg_temp_', 'pg_toast_temp_')) AND nspname LIKE ORDER BY TABLE_SCHEM TABLE_CATq?rstuvwxy
TABLE_TYPE TABLE_SCHEM
TABLE_NAME COLUMN_SIZE
BUFFER_LENGTH DECIMAL_DIGITS NUM_PREC_RADIX CHAR_OCTET_LENGTH SCOPE_CATLOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE IS_AUTOINCREMENTz{|}~ SELECT * FROM ( ?SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen, Irow_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, a.attnum,?pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE c.relkind in ('r','v','f','m') and a.attnum > 0 AND NOT a.attisdropped ) c WHERE true AND attname LIKE # ORDER BY nspname,c.relname,attnum atttypmod relname java/sql/Types adsrc int4 nextval(? serial int8 bigserial?????? 10 bit varbit 2
attnotnull?? description attnum[e NO YES typbasetype GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE /SELECT n.nspname,c.relname,r.rolname,c.relacl,
a.attacl, a.attname 8 FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c, 2 pg_catalog.pg_roles r, pg_catalog.pg_attribute a WHERE c.relnamespace = n.oid AND c.relowner = r.oid AND c.oid = a.attrelid AND c.relkind = 'r' ) AND a.attnum > 0 AND NOT a.attisdropped AND n.nspname = AND c.relname = AND a.attname LIKE ORDER BY attname rolname relacl?? attacl???s??7??;a java/util/Map$Entry?a java/util/List?a ?SELECT n.nspname,c.relname,r.rolname,c.relacl FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c, pg_catalog.pg_roles r WHERE c.relnamespace = n.oid AND c.relowner = r.oid AND c.relkind = 'r' ORDER BY nspname, relname ???????????? =?I / PUBLIC INSERT SELECT UPDATE DELETE TRUNCATE RULE
REFERENCES TRIGGER EXECUTE USAGE CREATE CREATE TEMP UNKNOWN java/util/HashMap?? arwdDxt arwdxt { }???? SCOPE
PSEUDO_COLUMN?SELECT a.attname, a.atttypid, atttypmod FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) WHERE true AND ct.relname = AND i.indisprimary ORDER BY a.attnum ctid tidhIMSELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN (SELECT i.indexrelid, i.indrelid, i.indisprimary, information_schema._pg_expandarray(i.indkey) AS keys FROM pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true : AND i.indisprimary ORDER BY table_name, pk_name, key_seq?SELECT NULL::text AS PKTABLE_CAT, pkn.nspname AS PKTABLE_SCHEM, pkc.relname AS PKTABLE_NAME, pka.attname AS PKCOLUMN_NAME, NULL::text AS FKTABLE_CAT, fkn.nspname AS FKTABLE_SCHEM, fkc.relname AS FKTABLE_NAME, fka.attname AS FKCOLUMN_NAME, pos.n AS KEY_SEQ, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS UPDATE_RULE, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS DELETE_RULE, con.conname AS FK_NAME, pkic.relname AS PK_NAME, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS DEFERRABILITY FROM pg_catalog.pg_namespace pkn, pg_catalog.pg_class pkc, pg_catalog.pg_attribute pka, pg_catalog.pg_namespace fkn, pg_catalog.pg_class fkc, pg_catalog.pg_attribute fka, pg_catalog.pg_constraint con, pg_catalog.generate_series(1,
) pos(n), pg_catalog.pg_class pkic?| , pg_catalog.pg_depend dep $ WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND pkic.relkind = 'i' ? AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid AND pkic.oid = con.conindid AND pkn.nspname = AND fkn.nspname = AND pkc.relname = AND fkc.relname = 3 ORDER BY fkn.nspname,fkc.relname,con.conname,pos.n 4 ORDER BY pkn.nspname,pkc.relname, con.conname,pos.n LITERAL_PREFIX LITERAL_SUFFIX
CREATE_PARAMS CASE_SENSITIVE
SEARCHABLE UNSIGNED_ATTRIBUTE FIXED_PREC_SCALE AUTO_INCREMENT LOCAL_TYPE_NAME
MINIMUM_SCALE
MAXIMUM_SCALE ?SELECT t.typname,t.oid FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) WHERE n.nspname != 'pg_toast' 0TeV??E?d?d?d 1000x?ax?|?SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN 1 ELSE CASE am.amname WHEN 'hash' THEN 2 ELSE 3 END END AS TYPE, (i.keys).n AS ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false)) AS COLUMN_NAME, ?| ? CASE am.amname WHEN 'btree' THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ? CASE am.amcanorder WHEN true THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, D pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION FROM pg_catalog.pg_class ct > JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) 6 JOIN (SELECT i.indexrelid, i.indrelid, i.indoption, 6 i.indisunique, i.indisclustered, i.indpred, i.indexprs, ? information_schema._pg_expandarray(i.indkey) AS keys & FROM pg_catalog.pg_index i) i ON (ct.oid = i.indrelid) 9 JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) 2 JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true 4SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ? FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_am am AND n.oid = ct.relnamespace , pg_catalog.pg_index i o ct.relname AS TABLE_NAME, NOT i.indisunique AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, ci.relname AS INDEX_NAME, CASE i.indisclustered WHEN true THEN ELSE CASE am.amname WHEN 'hash' THEN ELSE END END AS TYPE, a.attnum AS ORDINAL_POSITION, - CASE WHEN i.indexprs IS NULL THEN a.attname L ELSE pg_catalog.pg_get_indexdef(ci.oid,a.attnum,false) END AS COLUMN_NAME, NULL AS ASC_OR_DESC, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, C pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION [ WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND ci.relam=am.oid AND i.indisunique 9 ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION java/sql/ResultSetselect null as type_cat, n.nspname as type_schem, t.typname as type_name, null as class_name, CASE WHEN t.typtype='c' then 2002 else 2001 end as data_type, pg_catalog.obj_description(t.oid, 'pg_type') as remarks, CASE WHEN t.typtype = 'd' then (select CASE?? when typname = then ? else 1111 end from pg_type where oid=t.typbasetype) else null end as base_type from pg_catalog.pg_type t, pg_catalog.pg_namespace n where t.typnamespace = n.oid and n.nspname != 'pg_catalog' and n.nspname != 'pg_toast' and (false or t.typtype = 'c' or t.typtype = 'd' and t.typtype IN ('c','d') ?E?E?e and t.typname like and n.nspname like * order by data_type, type_schem, type_name8??? getRowIdLifetime()??? NAME MAX_LEN
DEFAULT_VALUE DESCRIPTION ApplicationName ?The name of the application currently utilizing the connection.??E?p java/sql/SQLException Cannot unwrap to ??pquv 0getPseudoColumns(String, String, String, String) #getSuperTypes(String,String,String) +getSuperTables(String,String,String,String) *getAttributes(String,String,String,String)???? TABLE Mc.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' NOSCHEMAS 'c.relkind = 'r' AND c.relname !~ '^pg_' VIEW Sc.relkind = 'v' AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema' 'c.relkind = 'v' AND c.relname !~ '^pg_' INDEX Mc.relkind = 'i' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' 'c.relkind = 'i' AND c.relname !~ '^pg_' SEQUENCE c.relkind = 'S' TYPE Mc.relkind = 'c' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' 'c.relkind = 'c' AND c.relname !~ '^pg_' SYSTEM TABLE Rc.relkind = 'r' AND (n.nspname = 'pg_catalog' OR n.nspname = 'information_schema') ac.relkind = 'r' AND c.relname ~ '^pg_' AND c.relname !~ '^pg_toast_' AND c.relname !~ '^pg_temp_' SYSTEM TOAST TABLE *c.relkind = 'r' AND n.nspname = 'pg_toast' ,c.relkind = 'r' AND c.relname ~ '^pg_toast_' SYSTEM TOAST INDEX *c.relkind = 'i' AND n.nspname = 'pg_toast' ,c.relkind = 'i' AND c.relname ~ '^pg_toast_' SYSTEM VIEW Sc.relkind = 'v' AND (n.nspname = 'pg_catalog' OR n.nspname = 'information_schema') &c.relkind = 'v' AND c.relname ~ '^pg_' SYSTEM INDEX Sc.relkind = 'i' AND (n.nspname = 'pg_catalog' OR n.nspname = 'information_schema') ac.relkind = 'v' AND c.relname ~ '^pg_' AND c.relname !~ '^pg_toast_' AND c.relname !~ '^pg_temp_' TEMPORARY TABLE ,c.relkind = 'r' AND n.nspname ~ '^pg_temp_' ,c.relkind = 'r' AND c.relname ~ '^pg_temp_' TEMPORARY INDEX ,c.relkind = 'i' AND n.nspname ~ '^pg_temp_' ,c.relkind = 'i' AND c.relname ~ '^pg_temp_' TEMPORARY VIEW ,c.relkind = 'v' AND n.nspname ~ '^pg_temp_' ,c.relkind = 'v' AND c.relname ~ '^pg_temp_' TEMPORARY SEQUENCE ,c.relkind = 'S' AND n.nspname ~ '^pg_temp_' ,c.relkind = 'S' AND c.relname ~ '^pg_temp_'
FOREIGN TABLE c.relkind = 'f' MATERIALIZED VIEW c.relkind = 'm' java/sql/Statement java/lang/Throwable java/sql/Array org/postgresql/jdbc/PgConnection java/util/Iterator createStatement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; next close org/postgresql/util/GT tr 9(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/String; org/postgresql/util/PSQLState UNEXPECTED_ERROR Lorg/postgresql/util/PSQLState; 4(Ljava/lang/String;Lorg/postgresql/util/PSQLState;)V getInt (I)I !org/postgresql/util/JdbcBlackHole (Ljava/sql/ResultSet;)V (Ljava/sql/Statement;)V (Ljava/lang/String;)I getDBVersionNumber append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString getStandardConformingStrings escapeString isEmpty (Ljava/lang/String;I)V getBytes (Ljava/lang/String;)[B getString encodeString getLong (Ljava/lang/String;)J (Ljava/lang/String;)V
hasMoreTokens nextToken valueOf $(Ljava/lang/String;)Ljava/lang/Long; add (Ljava/lang/Object;)Z getArray $(Ljava/lang/String;)Ljava/sql/Array; ()Ljava/lang/Object; size equals java/lang/Integer (I)Ljava/lang/String; ()Lorg/postgresql/core/TypeInfo; org/postgresql/core/TypeInfo
getSQLType getPGType (I)Ljava/lang/StringBuilder; intValue get (I)Ljava/lang/Object; createDriverResultSet B([Lorg/postgresql/core/Field;Ljava/util/List;)Ljava/sql/ResultSet; &(Ljava/lang/Object;)Ljava/lang/Object;
getCatalog keySet ()Ljava/util/Set;
java/util/Set toArray (([Ljava/lang/Object;)[Ljava/lang/Object; java/util/Arrays sort ([Ljava/lang/Object;)V !org/postgresql/core/ServerVersion v8_4 #Lorg/postgresql/core/ServerVersion; haveMinimumServerVersion (Lorg/postgresql/core/Version;)Z contains (Ljava/lang/CharSequence;)Z getScale (II)I getPrecision getDisplaySize
getBoolean (Ljava/lang/String;)Z putAll (Ljava/util/Map;)V entrySet iterator ()Ljava/util/Iterator; hasNext getValue getKey length charAt (I)C substring (II)Ljava/lang/String;
startsWith endsWith set '(ILjava/lang/Object;)Ljava/lang/Object; lastIndexOf put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; v9_0 (I)J getMaximumPrecision requiresQuotingSqlType isCaseSensitive isSigned clone v8_3 v9_6 getPGTypeNamesWithSQLTypes indexOf (II)Ljava/sql/Statement; getClass ()Ljava/lang/Class; org/postgresql/Driver notImplemented O(Ljava/lang/Class;Ljava/lang/String;)Ljava/sql/SQLFeatureNotSupportedException; java/lang/Class isAssignableFrom cast getName getServerMajorVersion getServerMinorVersion ! ; ?? ? ! ?? ?? ?? ?? ? ? ? ?? ? X *? *? *? *+? ? ? # 2 3 $ %? ?? ?? ?? ? g*? ? ^L*? ? MN,+? N-? ? ,? ?
Y? ?
? ? ?*-? ? -? ,? ? :-? ,? ?*? ? J U U W U ? B 6 8
: ; = > % ? + @ 5 A ? E J G N H R I U G [ H b K? *
X?? P?? N?? g?? ? ? ????U?? ? ? ?? ? d*? ? YL*? ? MN,+? N-? ? ?
Y? ?
? ? ?*-? ? -? ,? ? :-? ,? ?*? d? E P P R P ? : O Q
T U W X % Y 9 \ E ^ I _ M ` P ^ V _ ] b? *
S?? K?? I?? d?? ? ? 9???V?? ? ? ?? ? , ? ? g? ?? ? ? ?? ? , ? ? k? ?? ? ? ?? ? 2 *? ? ? ? o? ?? ? ? ?? ? 2 *? ? ? ? s? ?? ? ? ?? ? 2 *? ? ? ? w? ?? ? ? ?? ? , ? ? {? ?? ? ? ?? ? , ? ? ? ?? ? ? ?? ? , ? ? ?? ?? ? ? ?? ? , ? ? ?? ?? ? ? ?? ? - ? ? ?? ?? ? ? ?? ? 2 *? ? ? ? ?? ?? ? ? ?? ? - ? ? ?? ?? ?? ? - ? ? ?? ?? ?? ? - *? ? ?? ?? ?? ? , ? ? ?? ?? ?? ? , ? ? ?? ?? ? ? ?? ? , ? ? ?? ?? ? ? ?? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? - ? ? ?? ?? ? ? ? ? - !? ? ? ?? ? ? ? ? - #? ? ? ?? ? ?
? ? U $L? %Y? &+? '(? '? )L+? ? ( *? ?? ? ? ? ? ? - *? ? .? ?? ? ?
? ? U +L? %Y? &+? ',? '? )L+? ? 2 9 =? ?? ? ? ? ? ? - -? ? L? ?? ? ? ? ? - .? ? ]? ?? ? ? ? ? , ? ? f? ?? ? ? ? ? , ? ? o? ?? ? ? ? ? , ? ? s? ?? ? ? ? ? , ? ? w? ?? ? ? ? ? , ? ? {? ?? ? ? ? @ ? ? ? ?? ? ? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? ? ? , ? ? ?? ?? ? ? !? ? , ? ? ?? ?? ? ? "? ? , ? ? ?? ?? ? ? #? ? , ? ? ?? ?? ? ? $? ? , ? ? ?? ?? ? ? %? ? , ? ? ?? ?? ? ? &? ? , ? ? ?? ?? ? ? '? ? , ? ? ?? ?? ? ? (? ? , ? ? ?? ?? ? ? )? ? , ? ? ? ?? ? ? *? ? , ? ? ? ?? ? ? +? ? , ? ? ? ?? ? ? ,? ? , ? ? $? ?? ? ? -? ? , ? ? -? ?? ? ? .? ? - /? ? 8? ?? ? ? /? ? - 0? ? A? ?? ? ? 0? ? - 1? ? J? ?? ? ? 1? ? , ? ? N? ?? ? ? 2? ? - 2? ? R? ?? ? ? 3? ? , ? ? [? ?? ? ? 4? ? , ? ? d? ?? ? ? 5? ? , ? ? m? ?? ? ? 6? ? , ? ? v? ?? ? ? 7? ? , ? ? ? ?? ? ? 8? ? , ? ? ?? ?? ? ? 9? ? , ? ? ?? ?? ? ? :? ? , ? ? ?? ?? ? ? ;? ? , ? ? ?? ?? ? ? <? ? , ? ? ?? ?? ? ? =? ? , ? ? ?? ?? ? ? >? ? , ? ? ?? ?? ? ? ?? ? , ? ? ?? ?? ? ? @? ? , ? ? ?? ?? ? ? A? ? , ? ? ?? ?? ? ? B? ? , ? ? ?? ?? ? ? C? ? , ? ? ?? ?? ? ? D? ? , ? ? ?? ?? ? ? E? ? , ? ? ?? ?? ? ? F? ? , ? ? ?? ?? ? ? G? ? , ? ? ?? ?? ? ? H? ? , ? ? ?? ?? ? ? I? ? , ? ? ?? ?? ? ? J? ? , ? ? ?? ?? ? ? K? ? , ? ? ?? ?? ? ? L? ? , ? ? ? ?? ? ? M? ? , ? ? ? ?? ? ? N? ? / *? 3? ?
? ?? ? ? O? ? , ? ? ? ?? ? ? P? ? / *? 4? ? ? ?? ? ? Q? ? , ? ? ? ?? ? ? R? ? , ? ? ? ?? ? ? S? ? . @? ? *? ?? ? ? T? ? . ? ? 8? ?? ? ? U? ? / *? 3? ? <? ?? ? ? V? ? , ? ? @? ?? ? ? W? ? / *? 3? ? D? ?? ? ? X? ? / *? 3? ? H? ?? ? ? Y? ? / *? 3? ? L? ?? ? ? Z? ? - 5? ? P? ?? ? ? [? ? , ? ? T? ?? ? ? \? ? , ? ? X? ?? ? ? ]? ? , ? ? \? ?? ? ? ^? ? / *? 3? ? `? ?? ? ? _? ? , ? ? d? ?? ? ? `? ? / *? 3? ? h? ?? ? ? a? ? , ? ? l? ?? ? ? b? ? , ? ? p? ?? ? ? cd ? z 4? 1 / / 1 / 1 1 1 /?? ? z 0 2?? 4?? 4e? ? 0? ? f? ? , ? ? ?? ?? ? ? g? ? , ? ? ?? ?? ? ? h? ? , ? ? ?? ?? ? ? i? ? , ? ? ?? ?? ? ? jk ? ? 9? %Y? &M*? ? 7?
,8? 'W,9? 'W,*? +? :? 'W,9? 'W,? )? ? ? ? ? ? ? -? 4?? 9?? 9l? 1mn ? ? o? ? pq ? ? x<:,? (,? =? !? %Y? &? '>? '*,? ?? '? ):-? (-? =? !? %Y? &? '@? '*-? ?? '? ):? %Y? &? 'A? '? ):*? B? ? ? ? ? ? -? 8? V? l?? 4 x?? xr? xs? xt? t?? ? ? -?(? ? uv ? ? ! ?6? C:? DY? E:? CYF? HS? CYI? HS? CYJ? HS? CYK? HS? CYL? HS? CYM? HS? CYN? HS? CYO? HS? CYP? HS ? CYQ? HS
? CYR? HS? CYS? HS? CYT? HS
? CYU? HS? CYV? HS? CYW? HS? CYX? HS? CYY? HS? CYZ? HS? CY[? HS\:,? (,? =? !? %Y? &? '>? '*,? ?? '? ):-? (-? =? !? %Y? &? '@? '*-? ?? '? ):? %Y? &? ']? '? ):?: *? ? :
? :? ??^? _ :`? _ :
*? ? %Y? &`? a ? 'b? 'c? a ? '? )? d:e? f ?6g? a :h? f ?6i? a :? jY? k:? DY? E:? l? ? m? n? o W???:p? q :? ? r ? s? s::t? q :? ? r ? s? s:? u 6:v? q :? ? r ? w? w:?6x? y? &z? y? {? y? |? y? ?? ?? }:SS
S*? ~? dS*? ? ? dS*? *? ? ?? ? ? ? dS*? *? ? ?? ? ? dSSS S
S*? ? ? dSS*? ? ? dS SS? o W6?d? }:SS
S? *? 2? dS? $*? ? %Y? &?? '`? ?? )? dS6? 2?? y? 6? 0? 2x? y? 6? ? 2?? y? 6*? ? ? dS? 2? ?6? ? ? ? ?? ?6*? *? ? ?? ? ? ? dS*? *? ? ?? ? ? dSSS S
S*? ? ? dSS*? `? ? dS SS? o W?????? y? |? y??? %Y? &?? '? ??? '? ):*? ? :? :? ? ??? f ?6? }: S S
S ?? _ S *? ? ? dS *? *? ? ?? ? ? ? dS *? *? ? ?? ? ? dS S S S
S *? ? ? dS S *? ? ? dS S S ? o W??*? ? ? ??X? ?
? *? B? ?? ? ? ? Z ? ? ? ? ? $? 4? D? T? c? r? ?? ?? ?? ?? ?? ?? ?? ????%?5?F?W?[?f?????????????? ???,8CO Z
env
???????????? ?!?"?&'*(1)6*<+B,O-W.^/i0z1?2?3?4?5?6?7?8?9?:?;?=?A?B?C DEGH$JEMHNZO`PrQxR?S?V?Y?Z?\?_?`?a?b?cdefgh$i7j>kEmOAUqnr?u?v?w?x?y?z?{?|?}?~???????#?)?/?5?>?E?K?[?b?i?s?v?}?????????? ? '1 ?wx ? y? ?Twx Hz? ? ?y? ?h{? ? ?|? ? ?wx ? ?}? ? ?~? ? ?? ???? ????
,X?? 8L?? CA?? O5?? Z*?? e?? n?? ???? ???? ???? ???? ???? ???? ???? ??? ?r? ?s? ?t? ??? ??? ??? ??? [K?? ???? ????
???? ? n?? ??? ? 3 ?? ???????? (? . }??? ? ???????? }?? } } }???? ? ! s?? ! s?? / w?,? ?? ? 6I ? !? ? ? ???????? }?? } } }???? s? s? w? ? .???? ??
???????? }?? ? ? ?? ? s ?:?:,? (,? =? !? %Y? &? '>? '*,? ?? '? ):?:-? (-? =? !? %Y? &? '?? '*-? ?? '? ):? ?? %Y? &? '?? '? ):? %Y? &:: ?6
6
? D 2:? ?? ? ? ?:
? #
? ? ? ?:?? '? '?? 'W????? %Y? &? '? )? '?? '? ):? %Y? &? '? '? ):*? B? ? ? N ? ? ? ? 1? 5? @? ^? c? y? ?? ?? ?? ?? ?? ?? ?? ??
?? ?
? ?? ? %??
? 4?? ? r?n ?? r? s? ?? ?? ?? 5 ??? ??
?? ? ? %??
? [ ? 1? ?? , ???? s??? ? / ???? s???o s ? A? ? ? ? ?? ? 1 *? ?? ? 4? ?? ? ? ?? ? ? I?N,? &,? =? ? %Y? &-? '?? '*,? ?? '? )N? %Y? &-? '?? '? )N*? B-? ? ? : > ? *A >C? * I?? Ir? Is? F?? ? ? *?? ? ?? ? ? I? CL? DY? EM+? CY?? HS? }N-*? *? ? ?? dS,-? o W*? B? ?+,? ? ? ? L M
N O !P 2Q :S? * I?? D??
<?? ! (wx ?
<?? ? ? ?? ? 8 ? ?? ? ? ?? ? ? sL+? ?? CM? DY? EN,? CY?? HS+:?66? ,2:? }:*? ? dS-? o W????*? B? ?,-? ? ? ? . X Y [ \ &] 5^ N_ T` aa j^ pd? > T wx N ?? ?? j?? a?? &