org.postgresql.jdbc.PgDatabaseMetaData.class Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of huaweicloud-dws-jdbc Show documentation
Show all versions of huaweicloud-dws-jdbc Show documentation
Data Warehouse Service JDBC driver
???? 4?
~ ? ?? ???
????x??????
?? ??
?x?
??
?????x?
??
??
???
??????
?? ?? ??
????x??
???????
-~
-??
-??????????
??
??@ ?
????
????
)??
????
????
L~??
K???????????????????????x??x???
???x?????
r?
r?
r?
?? ??x????? ????
)?????
?
?((
?
-
?
?
?
?x? ? ? ?
?!
?"#$%&
?' ?()*
+,-./0123456789 ?:;<=> ??@ABCDEFGHIJ
)KLMNOP ?QRS(T(U(VWXYZ[x\]^
)_`abcdefghijklmno
?pq ?r ?s)t?u?vw ?xy ?z t{|
)}
)~
)
)?
)? ??
)?????????????????
~ ??????
??
?????????(???????????? ????????????
?????????????????
R?x?
??
??(?(?(?(??
???
??
???
`?
?? ??? ??????????????????????(??
-???????
)?
)?
)???
?
??
?
? ! "#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTU InnerClasses keywords Ljava/lang/String;
connection "Lorg/postgresql/jdbc/PgConnection; nameDataLength I indexMaxKeys 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;
StackMapTableVW
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;?X 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 identity
decimalDigits
columnSize baseTypeOid autoinc numberOfFieldsY getColumnPrivileges acl relPermissions grantable grants grantor grantee userToGrantable Entry 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;>;Z 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 usersWithPermission permissionByGrantor 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 getPrimaryUniqueKeys 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 ti Lorg/postgresql/core/TypeInfo;[ 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; typOid Ljava/lang/Integer; Ljava/util/Iterator; firstQualifier secondQualifier typeNamePattern [I sqlwhen toAdd )Ljava/util/Iterator;D
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 pgFuncResultExists funcTypeSql getFunctionColumns functionName 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?z?????? FSELECT setting FROM pg_catalog.pg_settings WHERE name='max_index_keys'\L]^_?`z !org/postgresql/util/PSQLException PUnable to determine a value for MaxIndexKeys due to missing system catalog data. java/lang/Objectabcdef?ghij`k`l ?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. typlenhm ?
PostgreSQLn org/postgresql/util/DriverInfo PostgreSQL JDBC Driver 42.2.23 "oz??pqrst?select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]) /Unable to find keywords in the system catalogs.uv?abort,access,aggregate,also,analyse,analyze,backward,bit,cache,checkpoint,class,cluster,comment,concurrently,connection,conversion,copy,csv,database,delimiter,delimiters,disable,do,enable,encoding,encrypted,exclusive,explain,force,forward,freeze,greatest,handler,header,if,ilike,immutable,implicit,index,indexes,inherit,inherits,instead,isnull,least,limit,listen,load,location,lock,mode,move,nothing,notify,notnull,nowait,off,offset,oids,operator,owned,owner,password,prepared,procedural,quote,reassign,recheck,reindex,rename,replace,reset,restrict,returning,rule,setof,share,show,stable,statistics,stdin,stdout,storage,strict,sysid,tablespace,temp,template,truncate,trusted,unencrypted,unlisten,until,vacuum,valid,validator,verbose,volatilewxy java/lang/String $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/StringBuilderz{ ,replace| database,ifnull,user ocurdate,curtime,dayname,dayofmonth,dayofweek,dayofyear,hour,minute,month,monthname,now,quarter,second,week,year
,timestampadd \ function database .???? java/sql/Connection}? E '~| 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 ? AND n.nspname LIKE {| AND p.proname LIKE 7 ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, p.oid::text KL org/postgresql/core/Field java/util/ArrayList
PROCEDURE_CAT org/postgresql/core/Oid?? 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_OCTET_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 nspname?? pronameu| _ oid??
prorettype?? typrelid proargtypes java/util/StringTokenizer????????? proargnames???? proargmodes?? proallargtypes b?? d p returnValue|v??i?v org/postgresql/core/Tuple?? $z? o t???? java/lang/Long?? java/lang/Integer OSELECT a.attname,a.atttypid FROM pg_catalog.pg_attribute a WHERE a.attrelid = ; AND NOT a.attisdropped AND a.attnum > 0 ORDER BY a.attnum atttypid attname !org/postgresql/core/BaseStatement?? SCHEMAS?SELECT 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 'p' 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 'p' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION 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 ???y
java/util/Map OR ( ) ) org/postgresql/jdbc/PgResultSet????>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_CAT?????????
TABLE_TYPE TABLE_SCHEM
TABLE_NAME COLUMN_SIZE
BUFFER_LENGTH DECIMAL_DIGITS NUM_PREC_RADIX
SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE IS_AUTOINCREMENT IS_GENERATEDCOLUMN?r 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,?r )nullif(a.attidentity, '') as attidentity, null as attidentity,?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','p','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 nextval(?? int4 serial int8 bigserial int2?r smallserial attidentity?????? 10 bit varbit 2
attnotnull?? description attnum?v NO YES typbasetype GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE /SELECT n.nspname,c.relname,r.rolname,c.relacl,
a.attacl, a.attname FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c, 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????????_? java/util/Map$Entry?? java/util/List?? ?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 IN ('r','p','v','m','f') ORDER BY nspname, relname ???????????? =?m / 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 tid?m?SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, (i.keys).n AS KEY_SEQ, PK_NAME FROM ( SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, information_schema._pg_expandarray(i.keys) AS keys, ci.relname AS PK_NAME, a.attnum 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, i.indkey AS keys FROM pg_catalog.pg_index i ) i ON (a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true [ AND i.indisprimary ) i WHERE i.attnum = (i.keys).x ORDER BY table_name, pk_name, key_seq; SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, (information_schema._pg_expandarray(i.indkey)).n AS KEY_SEQ, ci.relname AS PK_NAME, information_schema._pg_expandarray(i.indkey) AS KEYS, a.attnum AS A_ATTNUM 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 pg_catalog.pg_index i ON ( a.attrelid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE true ' AND (i.indisprimary or i.indisunique) ?SELECT result.TABLE_CAT, result.TABLE_SCHEM, result.TABLE_NAME, result.COLUMN_NAME, result.KEY_SEQ, result.PK_NAME FROM ( 3 ) result where result.A_ATTNUM = (result.KEYS).x ; ORDER BY result.table_name, result.pk_name, result.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 'p' 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 'p' 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' ?r AND pkic.relkind = 'i' .AND (pkic.relkind = 'i' OR 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' AND (t.typrelid = 0 OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid)) 0 !org/postgresql/jdbc/TypeInfoCache?z????????i?u?u?u 1000????? (org/postgresql/jdbc/PgDatabaseMetaData$1??????r ?SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, NON_UNIQUE, INDEX_QUALIFIER, INDEX_NAME, TYPE, ORDINAL_POSITION, trim(both '"' from pg_catalog.pg_get_indexdef(ci_oid, ORDINAL_POSITION, false)) AS COLUMN_NAME,?r ? CASE amname WHEN 'btree' THEN CASE indoption[ORDINAL_POSITION - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, ? CASE amcanorder WHEN true THEN CASE indoption[ORDINAL_POSITION - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC, CARDINALITY, PAGES, FILTER_CONDITION from (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 / ELSE CASE am.amname WHEN 'hash' THEN ELSE END END AS TYPE, (information_schema._pg_expandarray(i.indkey)).n AS ORDINAL_POSITION, ci.oid AS ci_oid, am.amcanorder, am.amname, i.indoption, ci.reltuples AS CARDINALITY, ci.relpages AS PAGES, 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) JOIN pg_catalog.pg_index i ON (ct.oid = i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true AND i.indisunique ) 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 ? 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 9 END END AS TYPE, a.attnum AS ORDINAL_POSITION, CASE WHEN i.indexprs IS NULL THEN a.attname 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, 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 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 t.oid = z? 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') ?i?i?v and t.typname like and n.nspname like * order by data_type, type_schem, type_name\??? getRowIdLifetime()??? NAME MAX_LEN
DEFAULT_VALUE DESCRIPTION ApplicationName ?The name of the application currently utilizing the connection.??V?y java/sql/SQLException Cannot unwrap to ? 0 ? CASE WHEN (format_type(p.prorettype, null) = 'unknown') THEN 0 WHEN (substring(pg_get_function_result(p.oid) from 0 for 6) = 'TABLE') OR (substring(pg_get_function_result(p.oid) from 0 for 6) = 'SETOF') THEN 2 ELSE 1 END SELECT current_database() AS FUNCTION_CAT, n.nspname AS FUNCTION_SCHEM, p.proname AS FUNCTION_NAME, d.description AS REMARKS, ? AS FUNCTION_TYPE, p.proname || '_' || p.oid AS SPECIFIC_NAME FROM pg_catalog.pg_proc p INNER JOIN pg_catalog.pg_namespace n ON p.pronamespace=n.oid LEFT JOIN pg_catalog.pg_description d ON p.oid=d.objoid WHERE pg_function_is_visible(p.oid) 5 ORDER BY FUNCTION_SCHEM, FUNCTION_NAME, p.oid::text FUNCTION_CAT FUNCTION_SCHEM
FUNCTION_NAME e 0getPseudoColumns(String, String, String, String) #getSuperTypes(String,String,String) +getSuperTables(String,String,String,String) *getAttributes(String,String,String,String)???????? TABLE Tc.relkind IN ('r','p') AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' NOSCHEMAS .c.relkind IN ('r','p') 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_' PARTITIONED 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 hc.relkind = 'v' AND (n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' OR n.nspname = 'sys') &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 Hc.relkind = 'r' AND (n.nspname ~ '^pg_temp_' OR c.relpersistence = 'g') Hc.relkind = 'r' AND (c.relname ~ '^pg_temp_' OR c.relpersistence = 'g') LOCAL TEMPORARY 3c.relkind IN ('r','p') AND n.nspname ~ '^pg_temp_' 3c.relkind IN ('r','p') 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' &org/postgresql/jdbc/PgDatabaseMetaData java/sql/Statement java/lang/Throwable java/sql/Array org/postgresql/jdbc/PgConnection java/util/Iterator org/postgresql/core/TypeInfo 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 checkClosed !org/postgresql/core/ServerVersion v9_0 #Lorg/postgresql/core/ServerVersion; haveMinimumServerVersion (Lorg/postgresql/core/Version;)Z getString (I)Ljava/lang/String; %org/postgresql/util/internal/Nullness castNonNull &(Ljava/lang/Object;)Ljava/lang/Object; append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString getStandardConformingStrings escapeString isEmpty (Ljava/lang/String;I)V getBytes (Ljava/lang/String;)[B 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 ()Lorg/postgresql/core/TypeInfo;
getSQLType getPGType ([[B)V (I)Ljava/lang/StringBuilder; intValue get (I)Ljava/lang/Object; (I)Ljava/lang/Integer; createDriverResultSet B([Lorg/postgresql/core/Field;Ljava/util/List;)Ljava/sql/ResultSet; upperCaseFieldLabels #()Lorg/postgresql/jdbc/PgResultSet;
getCatalog keySet ()Ljava/util/Set;
java/util/Set toArray (([Ljava/lang/Object;)[Ljava/lang/Object; java/util/Arrays sort ([Ljava/lang/Object;)V v8_4 v10 contains (Ljava/lang/CharSequence;)Z v9_2 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; v11
cacheSQLTypes (I)J java/math/BigInteger (J)Ljava/math/BigInteger; toByteArray ()[B getMaximumPrecision requiresQuotingSqlType isCaseSensitive isSigned clone +(Lorg/postgresql/jdbc/PgDatabaseMetaData;)V java/util/Collections )(Ljava/util/List;Ljava/util/Comparator;)V v8_3 v9_6 getPGTypeOidsWithSQLTypes -(Ljava/lang/Object;)Ljava/lang/StringBuilder; 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 JDBC_MAJOR_VERSION JDBC_MINOR_VERSION !? C ?? ?? ?? ?? ?? ? ? ? ?? ? X *? *? *? *+? ? ? . 6 7 / 0? ?? ?? ?? ? g*? ? ^L*? ? MN,+? N-? ? ,? ?
Y? ?
? ? ?*-? ? -? ,? ? :-? ,? ?*? ? J U U W U ? F : <