Edit C:\galaxie\jobs\GALAXIE__JOBs\backup\GALAXIE__PCKG_0.3\lib\org\postgresql\jdbc2\AbstractJdbc2DatabaseMetaData.class
Êþº¾ 3 ? ? ¡¢ £¤¥¦§¨© ?ª «¬ £®¯°±²¯³´µ ¶· ¸¹ º±»±³¼½¾¿±À £Á £Â £ÃÄÅ £ÆÇ ÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÐ×ØÙÚ Û Ü@ Ý £Þßàá £â ãäåæ Áçè éêëìíîïðñò ó ôõö W?÷ Vøùúûüýþÿ ±± £± ? ?!" ?# ? $%±&'(Ý)*+, £-äÇ ?./0ÿ1Ñ2 34 £567689 :;< ?=>-?@ABCDE ¬FGHIJKLMNOPQRSTUV W ÀXYZ[\] ^_`abcdefghijk £l À* Àmnopqpr stuvwxyz{|}~?????????????????? Á????6?6?6??????±?? Á¡¢£¤ ¥¦§¨©ª«¬®¯°±²³ ´µ À¶·¸¹º Á» Á¼ Á½ Á¾ Á¿ ÁÀÁ ÁÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓ 9? ÀÔÕÖ×ØÙÚ Û ÜÝÞßàáâãäåæçèéê6ëìíîïðñòóôõö÷øùúûüýþÿ !"#$%&'()*+,-./±0±1234567 89±: ;<=>?@ABCDEFGHIç±J6K6L6M6NO PQÉ RQSTUVWXYZ[\]^_`abcdefghijk Ál Ámn6opqrstuv Áw Áxyz{ £|}~???????????????????????????????? ¡¢£¤¥¦§¨©ª« keywords Ljava/lang/String; ConstantValue connection .Lorg/postgresql/jdbc2/AbstractJdbc2Connection; NAMEDATALEN I INDEX_MAX_KEYS tableTypeClauses Ljava/util/Map; <init> 1(Lorg/postgresql/jdbc2/AbstractJdbc2Connection;)V Code LineNumberTable LocalVariableTable this 4Lorg/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData; conn getMaxIndexKeys ()I sql from stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet; StackMapTableZª¬ 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 getMaxBinaryLiteralLength getMaxCharLiteralLength 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 M(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; jdbcVersion getProcedureColumns ^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; columnNamePattern _(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; i tempAllArgTypes [J tuple [[B argOid columnMode 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 columns f [Lorg/postgresql/core/Field; v isnullableUnknownè·¯ getTables _(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet; select orderby useSchemas tableType clause clauses tableNamePattern types getSchemas ()Ljava/sql/ResultSet; ;(ILjava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; tempSchema getCatalogs getTableTypes e Ljava/util/Iterator;° getColumns numberOfFields sqlType baseTypeOid autoinc typeOid typeMod typtype pgType defval decimalDigits columnSize± getColumnPrivileges acl relPermissions grants grantable l grantor grantee j privilege grantees granteeUsers g k schemaName tableName column owner relAcl permissions permNames tableY getTablePrivileges grantTuple sortStringArray ([Ljava/lang/String;)V tmp parseACLArray $(Ljava/lang/String;)Ljava/util/List; c C aclString acls inQuotes Z beginIndex prevChar addACLPrivileges $(Ljava/lang/String;Ljava/util/Map;)V privs permissionByGrantor sqlpriv usersWithPermission grant privileges equalIndex slashIndex user parseACL 5(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map; perms aclArray getBestRowIdentifier N(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet; where 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; rule action fKeyName updateRule deleteRule keySequence fkeyColumn pkeyColumn fkName targs tokens element deferrability deferrable initiallyDeferred primaryCatalog primarySchema primaryTable foreignCatalog foreignSchema foreignTable tuples 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; unique approximate tokenize 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; token delimiterIndex input delimiter result start end delimiterSize supportsResultSetType type 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; firstQualifier secondQualifier typeNamePattern [I toAdd getConnection ()Ljava/sql/Connection; rowChangesAreDetected rowChangesAreVisible createMetaDataStatement ()Ljava/sql/Statement; <clinit> ()V ht SourceFile "AbstractJdbc2DatabaseMetaData.java? 8.0±²³ FSELECT setting FROM pg_catalog.pg_settings WHERE name='max_index_keys' 7.3 ?pg_catalog.pg_namespace n, pg_catalog.pg_type t1, pg_catalog.pg_type t2 WHERE t1.typnamespace=n.oid AND n.nspname='pg_catalog' AND pg_type t1, pg_type t2 WHERE java/lang/StringBuilder SELECT t1.typlen/t2.typlen FROM ´µ - t1.typelem=t2.oid AND t1.typname='oidvector'¶:·?¬¸¹º7»? !org/postgresql/util/PSQLException PUnable to determine a value for MaxIndexKeys due to missing system catalog data.¼½µ¾¿ÀÁÂà ?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' /SELECT typlen FROM pg_type WHERE typname='name' 4Unable to find name datatype in the system catalogs. typlenÂÄ9:;:<7 7.2 PostgreSQLÅ: PostgreSQL Native DriverÆÇ: "Gabort,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 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 ,replace database,ifnull,user ifnull,user ocurdate,curtime,dayname,dayofmonth,dayofweek,dayofyear,hour,minute,month,monthname,now,quarter,second,week,year ,timestampadd \ 6.4 7.1 function database . 6.55'&' 7.0È7 8.1 E 'ɵº¿ ?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 9 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 ?SELECT NULL AS PROCEDURE_CAT, NULL AS PROCEDURE_SCHEM, p.proname AS PROCEDURE_NAME, NULL, NULL, NULL, d.description AS REMARKS, 2 AS PROCEDURE_TYPE @ FROM pg_proc p LEFT JOIN pg_description d ON (p.oid=d.objoid) D LEFT JOIN pg_class c ON (d.classoid=c.oid AND c.relname='pg_proc') WHERE p.proname LIKE & ORDER BY PROCEDURE_NAME, p.oid::text ?SELECT NULL AS PROCEDURE_CAT, NULL AS PROCEDURE_SCHEM, p.proname AS PROCEDURE_NAME, NULL, NULL, NULL, NULL AS REMARKS, 2 AS PROCEDURE_TYPE FROM pg_proc p ??ÁÄ org/postgresql/core/Field java/util/ArrayList PROCEDURE_CATÌ 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_NAME LSELECT n.nspname,p.proname,p.prorettype,p.proargtypes, t.typtype,t.typrelid 2, p.proargnames, p.proargmodes, p.proallargtypes =, p.proargnames, NULL AS proargmodes, NULL AS proallargtypes C, NULL AS proargnames, NULL AS proargmodes, NULL AS 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 ÎSELECT NULL AS nspname,p.proname,p.prorettype,p.proargtypes,t.typtype,t.typrelid, NULL AS proargnames, NULL AS proargmodes, NULL AS proallargtypes, p.oid FROM pg_proc p,pg_type t WHERE p.prorettype=t.oid ! ORDER BY p.proname, p.oid::text nspnameÍÎ pronameϵ _ oidÐÎ prorettypeÑÒ typrelid proargtypes java/util/StringTokenizerÓÔ7 java/lang/LongÕ:ÖË proargnames×د×Ù proargmodesÚ' proallargtypes 8.3Û³Ü b d p returnValueݶÞfßàáÃâÞ $´ã o tä'åæ !SELECT 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/BaseStatementçè 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 NOSCHEMAS CASE c.relname ~ '^pg_' WHEN true THEN CASE c.relname ~ '^pg_toast_' WHEN true THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END WHEN false THEN CASE c.relname ~ '^pg_temp_' WHEN true THEN 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 WHEN false THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END ELSE NULL END ELSE NULL 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' ELSE NULL END ELSE NULL END ORDER BY TABLE_TYPE,TABLE_NAME HSELECT NULL AS TABLE_CAT, NULL AS TABLE_SCHEM, c.relname AS TABLE_NAME, ) AS TABLE_TYPE, d.description AS REMARKS FROM pg_class c C LEFT JOIN pg_description d ON (c.oid=d.objoid AND d.objsubid = 0) J LEFT JOIN pg_class dc ON (d.classoid = dc.oid AND dc.relname='pg_class') WHERE true 0 LEFT JOIN pg_description d ON (c.oid=d.objoid) AS TABLE_TYPE, NULL AS REMARKS AND c.relname LIKE AND (false åé java/util/Map java/lang/String OR ( ) ) ùû Xsubstring(textin(array_out(pg_catalog.current_schemas(true))) from '{(pg_temp_[0-9]+),') 7.4 %(pg_catalog.current_schemas(true))[1] SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG c FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = 9) AND (nspname !~ '^pg_toast_temp_' OR nspname = replace( !, 'pg_temp_', 'pg_toast_temp_')) AND nspname LIKE ORDER BY TABLE_SCHEM SELECT ''::text AS TABLE_SCHEM WHERE ''::text LIKE TABLE_CATê:ëìíîï°ð7ºÙ() 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_AUTOINCREMENT 8.4 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 a.attnum > 0 AND NOT a.attisdropped ) c WHERE true 'SELECT NULL::text AS nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,pg_get_expr(def.adbin,def.adrelid) AS adsrc,dsc.description,NULL::oid AS typbasetype,t.typtype FROM pg_class c JOIN pg_attribute a ON (a.attrelid=c.oid) JOIN pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') WHERE a.attnum > 0 ~SELECT NULL::text AS nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,def.adsrc,dsc.description,NULL::oid AS typbasetype, 'b' AS typtype FROM pg_class c JOIN pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_description dsc ON (a.oid=dsc.objoid) WHERE a.attnum > 0 ÷SELECT NULL::text AS nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attlen,a.attnum,NULL AS adsrc,NULL AS description,NULL AS typbasetype, 'b' AS typtype FROM pg_class c, pg_attribute a WHERE a.attrelid=c.oid AND a.attnum > 0 AND attname LIKE # ORDER BY nspname,c.relname,attnum atttypmod relname adsrc int4 nextval(ñÄ serial int8 bigserialòóôóõó 10 bit varbit 2 attnotnullö³ description attnum÷Þ NO YES typbasetypeÄ % GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE6SELECT 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 = -SELECT n.nspname,c.relname,r.rolname,c.relacl,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 ÌSELECT NULL::text AS nspname,c.relname,u.usename,c.relacl,a.attname FROM pg_class c, pg_user u,pg_attribute a WHERE u.usesysid = c.relowner AND c.oid = a.attrelid AND a.attnum > 0 AND c.relkind = 'r' AND c.relname = AND a.attname LIKE ORDER BY attname rolname relacl@A attacløù 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 = 'r' ?SELECT NULL::text AS nspname,c.relname,u.usename,c.relacl FROM pg_class c, pg_user u WHERE u.usesysid = c.relowner AND c.relkind = 'r' ORDER BY nspname, relname úÄû'üýþÿ ³³ =Ä / PUBLIC INSERT SELECT UPDATE DELETE TRUNCATE RULE REFERENCES TRIGGER EXECUTE USAGE CREATE CREATE TEMP UNKNOWN java/util/HashMap arwdRxt 8.2 arwdxt arwdDxt { }+,56 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 ? FROM pg_catalog.pg_namespace n, pg_catalog.pg_class ct, pg_catalog.pg_class ci, pg_catalog.pg_attribute a, pg_catalog.pg_index i AND ct.relnamespace = n.oid ; FROM pg_class ct, pg_class ci, pg_attribute a, pg_index i *SELECT a.attname, a.atttypid, a.atttypmod 1 WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid AND a.attrelid=ci.oid AND ct.relname = AND i.indisprimary ORDER BY a.attnum ctid tidáÄMSELECT 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 4SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, /SELECT NULL AS TABLE_CAT, NULL AS TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME, a.attnum AS KEY_SEQ, ci.relname AS PK_NAME : AND i.indisprimary ORDER BY table_name, pk_name, key_seq PKTABLE_CAT PKTABLE_SCHEM PKTABLE_NAME PKCOLUMN_NAME FKTABLE_CAT FKTABLE_SCHEM FKTABLE_NAME FKCOLUMN_NAME KEY_SEQ UPDATE_RULE DELETE_RULE FK_NAME PK_NAME DEFERRABILITYySELECT 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), / information_schema._pg_keypositions() pos(n), ì pg_catalog.pg_depend dep, pg_catalog.pg_class pkic 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 con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::regclass::oid AND dep.refclassid = 'pg_class'::regclass::oid 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 ?SELECT DISTINCT n1.nspname as pnspname,n2.nspname as fnspname, ì FROM pg_catalog.pg_namespace n1 JOIN pg_catalog.pg_class c1 ON (c1.relnamespace = n1.oid) JOIN pg_catalog.pg_index i ON (c1.oid=i.indrelid) JOIN pg_catalog.pg_class ic ON (i.indexrelid=ic.oid) JOIN pg_catalog.pg_attribute a ON (ic.oid=a.attrelid), pg_catalog.pg_namespace n2 JOIN pg_catalog.pg_class c2 ON (c2.relnamespace=n2.oid), pg_catalog.pg_trigger t1 JOIN pg_catalog.pg_proc p1 ON (t1.tgfoid=p1.oid), pg_catalog.pg_trigger t2 JOIN pg_catalog.pg_proc p2 ON (t2.tgfoid=p2.oid) AND n1.nspname = AND n2.nspname = @SELECT DISTINCT NULL::text as pnspname, NULL::text as fnspname, FROM pg_class c1 JOIN pg_index i ON (c1.oid=i.indrelid) JOIN pg_class ic ON (i.indexrelid=ic.oid) JOIN pg_attribute a ON (ic.oid=a.attrelid), pg_class c2, pg_trigger t1 JOIN pg_proc p1 ON (t1.tgfoid=p1.oid), pg_trigger t2 JOIN pg_proc p2 ON (t2.tgfoid=p2.oid) c1.relname as prelname, c2.relname as frelname, t1.tgconstrname, a.attnum as keyseq, ic.relname as fkeyname, t1.tgdeferrable, t1.tginitdeferred, t1.tgnargs,t1.tgargs, p1.proname as updaterule, p2.proname as deleterule WHERE (t1.tgrelid=c1.oid AND t1.tgisconstraint AND t1.tgconstrrelid=c2.oid %AND p1.proname ~ '^RI_FKey_.*_upd$') AND (t2.tgrelid=c1.oid AND t2.tgisconstraint AND t2.tgconstrrelid=c2.oid %AND p2.proname ~ '^RI_FKey_.*_del$') AND i.indisprimary AND c1.relname= AND c2.relname= ORDER BY fnspname, frelname pnspname, prelname ,keyseqÍÏÞ noaction cascade setnull setdefault restrict \000tu <unnamed>ö®KL 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' CSELECT typname,oid FROM pg_type WHERE NOT (typname ~ '^pg_toast_') 0Ñ Ã ®®® 1000É ÙÉ?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.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, 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 (SELECT i.indexrelid, i.indrelid, i.indoption, 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) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) JOIN pg_catalog.pg_am am ON (ci.relam = am.oid) WHERE true ? 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 l, pg_catalog.pg_attribute ai, pg_catalog.pg_index i LEFT JOIN pg_catalog.pg_proc ip ON (i.indproc = ip.oid) 6 AND ai.attnum = i.indkey[0] AND ai.attrelid = ct.oid , pg_catalog.pg_index i ? FROM pg_class ct, pg_class ci, pg_attribute a, pg_am am, pg_attribute ai, pg_index i LEFT JOIN pg_proc ip ON (i.indproc = ip.oid) 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, x CASE WHEN i.indexprs IS NULL THEN a.attname ELSE pg_catalog.pg_get_indexdef(ci.oid,a.attnum,false) END AS COLUMN_NAME, f CASE i.indproc WHEN 0 THEN a.attname ELSE ip.proname || '(' || ai.attname || ')' END AS COLUMN_NAME, K 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 8 pg_get_expr(i.indpred, i.indrelid) AS FILTER_CONDITION NULL 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 ñþÞselect 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') ñÃà and t.typname like and n.nspname like * order by data_type, type_schem, type_name· TABLE Mc.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' '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' 2org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData java/lang/Object java/sql/Statement java/sql/ResultSet java/sql/SQLException java/sql/Array java/util/Iterator ,org/postgresql/jdbc2/AbstractJdbc2Connection haveMinimumServerVersion (Ljava/lang/String;)Z append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString createStatement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; next close org/postgresql/util/GT tr org/postgresql/util/PSQLState UNEXPECTED_ERROR Lorg/postgresql/util/PSQLState; 4(Ljava/lang/String;Lorg/postgresql/util/PSQLState;)V getInt (I)I (Ljava/lang/String;)I getDBVersionNumber org/postgresql/Driver getVersion getStandardConformingStrings escapeString equals (Ljava/lang/Object;)Z (Ljava/lang/String;I)V getBytes (Ljava/lang/String;)[B getString encodeString getLong (Ljava/lang/String;)J (Ljava/lang/String;)V hasMoreTokens nextToken add getArray $(Ljava/lang/String;)Ljava/sql/Array; ()Ljava/lang/Object; size haveMinimumCompatibleVersion (J)V 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 iterator ()Ljava/util/Iterator; hasNext indexOf getScale (II)I getPrecision getDisplaySize getBoolean valueOf putAll (Ljava/util/Map;)V compareTo 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; (I)[B (I)J getMaximumPrecision requiresQuoting isCaseSensitive isSigned clone (Ljava/lang/String;I)I getPGTypeNamesWithSQLTypes (II)Ljava/sql/Statement;! * § X *· *µ *µ *+µ ± ! ' ( "