2 b c d ef ghijklm bn op q gr st uvwx yz {| } u~ u u g g g g   @ g    Mb L u u u o o o r M u  M g r g  g    r M        g      !"#$%&'()*+,-./0123456789:;<=>?@ ABCD E F GHIJKL uMNOPQR STUVWXYZ[\]^_` abcd e f g h i j Mkl mn opqrstuvwxyz{| }~  b   u u  u  u                  g!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLkeywordsLjava/lang/String; ConstantValue connection.Lorg/postgresql/jdbc2/AbstractJdbc2Connection; NAMEDATALENIINDEX_MAX_KEYStableTypeClausesLjava/util/Hashtable;1(Lorg/postgresql/jdbc2/AbstractJdbc2Connection;)VCodeLineNumberTableLocalVariableTablethis4Lorg/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData;conngetMaxIndexKeys()IsqlfromrsLjava/sql/ResultSet; StackMapTable KM ExceptionsNgetMaxNameLengthallProceduresAreCallable()ZallTablesAreSelectablegetURL()Ljava/lang/String; getUserName isReadOnlynullsAreSortedHighnullsAreSortedLownullsAreSortedAtStartnullsAreSortedAtEndgetDatabaseProductNamegetDatabaseProductVersion getDriverNamegetDriverVersiongetDriverMajorVersiongetDriverMinorVersionusesLocalFilesusesLocalFilePerTablesupportsMixedCaseIdentifiersstoresUpperCaseIdentifiersstoresLowerCaseIdentifiersstoresMixedCaseIdentifiers"supportsMixedCaseQuotedIdentifiers storesUpperCaseQuotedIdentifiers storesLowerCaseQuotedIdentifiers storesMixedCaseQuotedIdentifiersgetIdentifierQuoteStringgetSQLKeywordsgetNumericFunctionsgetStringFunctionsfuncsgetSystemFunctionsgetTimeDateFunctions timeDateFuncsgetSearchStringEscapegetExtraNameCharacterssupportsAlterTableWithAddColumn supportsAlterTableWithDropColumnsupportsColumnAliasingnullPlusNonNullIsNullsupportsConvert(II)ZfromTypetoTypesupportsTableCorrelationNames&supportsDifferentTableCorrelationNamessupportsExpressionsInOrderBysupportsOrderByUnrelatedsupportsGroupBysupportsGroupByUnrelatedsupportsGroupByBeyondSelectsupportsLikeEscapeClausesupportsMultipleResultSetssupportsMultipleTransactionssupportsNonNullableColumnssupportsMinimumSQLGrammarsupportsCoreSQLGrammarsupportsExtendedSQLGrammarsupportsANSI92EntryLevelSQLsupportsANSI92IntermediateSQLsupportsANSI92FullSQL$supportsIntegrityEnhancementFacilitysupportsOuterJoinssupportsFullOuterJoinssupportsLimitedOuterJoins getSchemaTermgetProcedureTermgetCatalogTermisCatalogAtStartgetCatalogSeparator!supportsSchemasInDataManipulationsupportsSchemasInProcedureCalls!supportsSchemasInTableDefinitions!supportsSchemasInIndexDefinitions%supportsSchemasInPrivilegeDefinitions"supportsCatalogsInDataManipulation supportsCatalogsInProcedureCalls"supportsCatalogsInTableDefinitions"supportsCatalogsInIndexDefinitions&supportsCatalogsInPrivilegeDefinitionssupportsPositionedDeletesupportsPositionedUpdatesupportsSelectForUpdatesupportsStoredProceduressupportsSubqueriesInComparisonssupportsSubqueriesInExistssupportsSubqueriesInInssupportsSubqueriesInQuantifiedssupportsCorrelatedSubqueries supportsUnionsupportsUnionAllsupportsOpenCursorsAcrossCommit!supportsOpenCursorsAcrossRollback"supportsOpenStatementsAcrossCommit$supportsOpenStatementsAcrossRollbackgetMaxBinaryLiteralLengthgetMaxCharLiteralLengthgetMaxColumnNameLengthgetMaxColumnsInGroupBygetMaxColumnsInIndexgetMaxColumnsInOrderBygetMaxColumnsInSelectgetMaxColumnsInTablegetMaxConnectionsgetMaxCursorNameLengthgetMaxIndexLengthgetMaxSchemaNameLengthgetMaxProcedureNameLengthgetMaxCatalogNameLength getMaxRowSizedoesMaxRowSizeIncludeBlobsgetMaxStatementLengthgetMaxStatementsgetMaxTableNameLengthgetMaxTablesInSelectgetMaxUserNameLengthgetDefaultTransactionIsolationsupportsTransactions!supportsTransactionIsolationLevel(I)Zlevel5supportsDataDefinitionAndDataManipulationTransactions(supportsDataManipulationTransactionsOnly%dataDefinitionCausesTransactionCommit#dataDefinitionIgnoredInTransactions escapeQuotes&(Ljava/lang/String;)Ljava/lang/String;s getProceduresL(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;catalog schemaPatternprocedureNamePatterngetProcedureColumns^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;itempAllArgTypes[Jtuple[[BargOid columnMode columnTypeOid columnsqlcolumnrsschema[B procedureName returnTypereturnTypeTypereturnTypeRelid strArgTypesstLjava/util/StringTokenizer;argTypesLjava/util/Vector;argNames[Ljava/lang/String; argNamesArrayLjava/sql/Array;argModes argModesArraynumArgs allArgTypes[Ljava/lang/Long;allArgTypesArraycolumnNamePatternf[Lorg/postgresql/core/Field;vO getTables_(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;selectorderby useSchemas tableTypeclauseclausestableNamePatterntypes getSchemas()Ljava/sql/ResultSet; tempSchema getCatalogs getTableTypeseLjava/util/Enumeration;P getColumns_(ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;numberOfFieldssqlType baseTypeOidautoinctypeOidtypeModtyptypepgTypedefval decimalDigits columnSize jdbcVersionQgetColumnPrivilegesgrantee grantablej privilegegrantees schemaName tableNamecolumnowneracl permissions permNamestable getTablePrivilegessortStringArray([Ljava/lang/String;)Vtmp parseACLArray&(Ljava/lang/String;)Ljava/util/Vector;cC aclStringaclsinQuotesZ beginIndexprevCharaddACLPrivileges*(Ljava/lang/String;Ljava/util/Hashtable;)VsqlprivusersWithPermission privileges equalIndexnameprivsparseACL;(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Hashtable;aclArraygetBestRowIdentifierN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet;scopenullablewheregetVersionColumnsgetPrimaryKeysgetImportedExportedKeys(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;ruleactionfKeyName updateRule deleteRule keySequence fkeyColumn pkeyColumnfkNametargstokenselement deferrability deferrableinitiallyDeferredprimaryCatalog primarySchema primaryTableforeignCatalog foreignSchema foreignTabletuplesgetImportedKeysgetExportedKeysgetCrossReference getTypeInfotuple1typnamebZerob10bfbtbliteral bNullable bSearchable getIndexInfoN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)Ljava/sql/ResultSet;unique approximatetokenize8(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector;tokendelimiterIndexinput delimiterresultstartend delimiterSizesupportsResultSetTypetypesupportsResultSetConcurrency concurrencyownUpdatesAreVisibleownDeletesAreVisibleownInsertsAreVisibleothersUpdatesAreVisibleothersDeletesAreVisibleothersInsertsAreVisibleupdatesAreDetecteddeletesAreDetectedinsertsAreDetectedsupportsBatchUpdatesgetUDTsN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[I)Ljava/sql/ResultSet;Ljava/util/Iterator;firstQualifiersecondQualifiertypeNamePattern[ItoAddR getConnection()Ljava/sql/Connection;rowChangesAreDetectedrowChangesAreVisiblecreateMetaDataStatement()Ljava/sql/Statement;()Vht SourceFile"AbstractJdbc2DatabaseMetaData.java ^   8.0Q STFSELECT setting FROM pg_catalog.pg_settings WHERE name='max_index_keys'7.3pg_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 UV- t1.typelem=t2.oid AND t1.typname='oidvector' W X\Y Z[M \!org/postgresql/util/PSQLExceptionPUnable to determine a value for MaxIndexKeys due to missing system catalog data.] ^_ `a b cd e^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 cf   7.2 PostgreSQL gPostgreSQL Native Driverh i"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,versionzabs,acos,asin,atan,atan2,ceiling,cos,cot,degrees,exp,floor,log,log10,mod,pi,power,radians,round,sign,sin,sqrt,tan,truncateLascii,char,concat,lcase,left,length,ltrim,repeat,rtrim,space,substring,ucase,replacedatabase,ifnull,user ifnull,userocurdate,curtime,dayname,dayofmonth,dayofweek,dayofyear,hour,minute,month,monthname,now,quarter,second,week,year ,timestampadd\6.47.1functiondatabase.6.5   7.0 jSELECT 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 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 kl AND n.nspname LIKE ' '  AND p.proname LIKE '* ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME 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 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/Fieldjava/util/Vector PROCEDURE_CAT mPROCEDURE_SCHEMPROCEDURE_NAME COLUMN_NAME COLUMN_TYPE DATA_TYPE TYPE_NAME PRECISIONLENGTHSCALERADIXNULLABLEREMARKSLSELECT n.nspname,p.proname,p.prorettype,p.proargtypes, t.typtype,t.typrelid 8.12, p.proargnames, p.proargmodes, p.proallargtypes =, p.proargnames, NULL AS proargmodes, NULL AS proallargtypes C, NULL AS proargnames, NULL AS proargmodes, NULL AS proallargtypes  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 SELECT NULL AS nspname,p.proname,p.prorettype,p.proargtypes,t.typtype,t.typrelid, NULL AS proargnames, NULL AS proargmodes, NULL AS proallargtypes FROM pg_proc p,pg_type t WHERE p.prorettype=t.oid  ORDER BY p.proname nspname noproname prorettype pq rtyprelid proargtypesjava/util/StringTokenizer s tjava/lang/Long u vw proargnames xyO xz proargmodes {proallargtypes8.3 |T }bdp returnValue ~o W ( d $ Uo  !SELECT a.attname,a.atttypid FROM  pg_catalog."pg_attribute a WHERE a.attrelid = $ AND a.attnum > 0 ORDER BY a.attnum atttypidattname!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' 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/Hashtablejava/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 FROM pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~ '^pg_temp_' OR nspname = 9) AND (nspname !~ '^pg_toast_temp_' OR nspname = replace(5, 'pg_temp_', 'pg_toast_temp_')) ORDER BY TABLE_SCHEM3SELECT ''::text AS TABLE_SCHEM ORDER BY TABLE_SCHEM TABLE_CAT  P  z  TABLE_TYPE TABLE_SCHEM TABLE_NAME COLUMN_SIZE BUFFER_LENGTHDECIMAL_DIGITSNUM_PREC_RADIX COLUMN_DEF SQL_DATA_TYPESQL_DATETIME_SUBCHAR_OCTET_LENGTHORDINAL_POSITION IS_NULLABLE SCOPE_CATLOG SCOPE_SCHEMA SCOPE_TABLESOURCE_DATA_TYPEIS_AUTOINCREMENT8.4SELECT * 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  atttypmodrelnameadsrcint4nextval( fserialint8 bigserial   10bitvarbit2 attnotnull T descriptionattnumNOYES typbasetype %GRANTORGRANTEE PRIVILEGE IS_GRANTABLE1SELECT n.nspname,c.relname,u.usename,c.relacl,a.attname FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c, pg_catalog.pg_user u, pg_catalog.pg_attribute a WHERE c.relnamespace = n.oid AND u.usesysid = c.relowner AND c.oid = a.attrelid AND c.relkind = 'r' AND a.attnum > 0 AND NOT a.attisdropped  AND n.nspname = '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 usenamerelacl SELECT n.nspname,c.relname,u.usename,c.relacl FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c, pg_catalog.pg_user u WHERE c.relnamespace = n.oid AND u.usesysid = c.relowner 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 f    T T = fPUBLIC INSERTSELECTUPDATEDELETETRUNCATERULE REFERENCESTRIGGEREXECUTEUSAGECREATE CREATE TEMPUNKNOWN { =arwdRxt}  SCOPE PSEUDO_COLUMN 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 i.indisprimary  AND ct.relname = ' ORDER BY a.attnum ctidtid f4SELECT 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 & ORDER BY table_name, pk_name, key_seq PKTABLE_CAT PKTABLE_SCHEM PKTABLE_NAME PKCOLUMN_NAME FKTABLE_CAT FKTABLE_SCHEM FKTABLE_NAME FKCOLUMN_NAMEKEY_SEQ UPDATE_RULE DELETE_RULEFK_NAMEPK_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 = '' ORDER BY fkn.nspname,fkc.relname,pos.n' ORDER BY pkn.nspname,pkc.relname,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 n rnoactioncascadesetnull setdefaultrestrict\000 67   LITERAL_PREFIXLITERAL_SUFFIX CREATE_PARAMSCASE_SENSITIVE SEARCHABLEUNSIGNED_ATTRIBUTEFIXED_PREC_SCALEAUTO_INCREMENTLOCAL_TYPE_NAME MINIMUM_SCALE MAXIMUM_SCALESELECT 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_') 0t' p d   1000 z 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 R  \z 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') d d and t.typname like ' and n.nspname like '* order by data_type, type_schem, type_name XTABLEMc.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema''c.relkind = 'r' AND c.relname !~ '^pg_'VIEWSc.relkind = 'v' AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema''c.relkind = 'v' AND c.relname !~ '^pg_'INDEXMc.relkind = 'i' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema''c.relkind = 'i' AND c.relname !~ '^pg_'SEQUENCEc.relkind = 'S'TYPEMc.relkind = 'c' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema''c.relkind = 'c' AND c.relname !~ '^pg_' SYSTEM TABLERc.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 VIEWSc.relkind = 'v' AND (n.nspname = 'pg_catalog' OR n.nspname = 'information_schema') &c.relkind = 'v' AND c.relname ~ '^pg_' SYSTEM INDEXSc.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_' 2org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaDatajava/lang/Objectjava/sql/ResultSetjava/sql/SQLExceptionjava/sql/Arrayjava/util/Enumeration,org/postgresql/jdbc2/AbstractJdbc2Connectionjava/util/IteratorhaveMinimumServerVersion(Ljava/lang/String;)Zappend-(Ljava/lang/String;)Ljava/lang/StringBuilder;toStringcreateStatementjava/sql/Statement executeQuery((Ljava/lang/String;)Ljava/sql/ResultSet;nextorg/postgresql/util/GTtrorg/postgresql/util/PSQLStateUNEXPECTED_ERRORLorg/postgresql/util/PSQLState;4(Ljava/lang/String;Lorg/postgresql/util/PSQLState;)VgetInt(I)Iclose(Ljava/lang/String;)IgetDBVersionNumberorg/postgresql/Driver getVersion escapeStringequals(Ljava/lang/Object;)Z(Ljava/lang/String;I)VgetBytes(Ljava/lang/String;)[BgetLong(Ljava/lang/String;)J getString(Ljava/lang/String;)V hasMoreTokens nextToken addElement(Ljava/lang/Object;)VgetArray$(Ljava/lang/String;)Ljava/sql/Array;()Ljava/lang/Object;sizehaveMinimumCompatibleVersion(J)V encodeStringjava/lang/Integer(I)Ljava/lang/String; ()Lorg/postgresql/core/TypeInfo;org/postgresql/core/TypeInfo getSQLType getPGType(I)Ljava/lang/StringBuilder;intValue elementAt(I)Ljava/lang/Object;createDriverResultSetD([Lorg/postgresql/core/Field;Ljava/util/Vector;)Ljava/sql/ResultSet;get&(Ljava/lang/Object;)Ljava/lang/Object; getCatalogkeys()Ljava/util/Enumeration;hasMoreElements nextElementindexOfgetScale(II)I getPrecisiongetDisplaySize getBoolean compareTolengthcharAt(I)C substring(II)Ljava/lang/String; startsWithendsWith setElementAt(Ljava/lang/Object;I)V lastIndexOfput8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;(I)[B(I)JgetMaximumPrecisionrequiresQuotingisCaseSensitiveisSignedclone(Ljava/lang/String;I)IgetPGTypeNamesWithSQLTypes()Ljava/util/Iterator;hasNext(II)Ljava/sql/Statement;!)X****+( )7*{* L1*  M M Y  ,L*+M,Y*,,*6 ,/03%5+9.;G=U>^@nByCE>(.G8U*! &    \*Q* LL*+M,Y*,,*d* ILNRT*U3WCYOZU\*9*+\&   ,i   ,u   2*    2*!   2*"   4 *#    ,   ,   G*# @  -$   2*%   -&   .'   - , ,    ,   !,*   ",5   #,@   $,K   %,X   &,c   ',n   (,y   )-(   *-)   +-*   ,s%+L* Y +,L+#%"-#  .M*-.    /s%/L* Y +0L+#%"0#  1-1   2-2   3,   44 **    5,A   6,M   7,R   78@W 9:  ;,c   <,o   =,|   >4 *3    ?,   @4 *3    A4 *3    B4 *4    C,   D,   E,   F,   G,   H,    I4 *    J,'   K,2   L,>   M4 *4I    N4 *4T    O4 *4_    P-5l   Q-6x   R-7   S,   T-8   U4 *    V4 *    W4 *    X4 *    Y4 *    Z,   [,   \,   ],   ^,   _,   `,   a4 *9*    b,6   c,B   d,N   e,Z   f,i   g4 *4w    h,   i4 *4    j,   k,   l,   m,   n,   o,   p/*:   q,   r/*;   s,   t,    u.@   v. /   w/*::   x,H   y/*:M   z/*:X   {/*:]   |N*4< h ik   },w   ~M*=@    ,   /*:   ,   /*:   ,   ,   w'*  #%''   ,   ,   ,   ,   = *+>%    ?*w?:,/2,@& Y A*,BC:-& Y D*-BC: Y E:*4iF:*# Y G:-& Y H*-BC: Y I:DJ:-& Y H*-BC: Y I:*KNK MSU@WDYg[]_bdfhjnprt3vHpb????I@&1&*   ^ L:MYN:LYOPSLYQPSLYRPSLYSPSLYTPSLYUPSLYVPSLYWPSLYXPS LYYPS LYZPS LY[PS LY\PS*]:*^ Y _:>* Y `: Y a: Y b:,/2,@& Y A*,BC:-& Y D*-BC: Y c:Dd:-& Y D*-BC: Y e:*:Qfg: hg: ij6 kl: mj6 nl:oYp:MYN:qrYstu:vw:xyy::zw:xyy:{6:|w:_*}~x:<x:r:6rY/S6 @ @ @ :S S S*S*S** S** SSS S S *S Su6& :S S S*2S$* Y `S62@ 62@6*S26r6**S**SSS S S *S Su @ @:* Y : Y  :*:j6 :S S SgS*S**S**SSS S S *S SuK*K 0@P_n!:Pfs'1<GS^ju!08CTZ _!#+%2&7'=(C*H+[-|/0123589;=>?@A%B+C;DAEH#NIgKkLwMOPQSTUVWXYZ#[=\C]I^O_U`eakbrcud|fgit%;0*2k$*k<@ G5 S) ^ j u~'p!$E&* a  !y!y7"6 !p  yy%/      \ *B::,/2,@& Y A*,BC:::::*#5 Y :a*40 Y :( Y :-& Y *-BC: Y :6J2:  / : Y  : Y : Y :*Kn !DKOSWc5@ P U a7H;Sa  P1 8OWhOp [ DI  y8$ y&H  Q*:M*M Y ,,LL*K+"f hijl@mCpFr*1@QF $  FLLMYNM+LYPSN-**S,-u*K+, !27*FA 9!%  FLM>,+,S+L:MYN:LYPS>+$:*+2Su*K> .28AQY_mtzH_ zx8SAJy$&   pA 6 66MYN:L:LYPSLYPSLYPSLYSPSLYUPSLYVPSLYPSLYPSLYPS LYPS LY[PS LY\PS LYPS LYPSLYPSLYPSLYPSLYPSFLYPSLYPSLYPSLYPSLYPS* *Ѷ : 2: Y  Ӷ: *Ѷ Y  Զ:  Y  ն: Y  ֶ: -/2-@& Y  A*-BC: 12@' Y  *BC: *ѶF Y  ׶: -*# : *4 : : *612@' Y  *BC: 12@' Y  ۶*BC: Y  ܶ: * :  :  j6  ݹ6  S  fgS  ޹gS  gS kl:@ 6%@ 6* 6 *S* : *S S ߹l:J@5 *S%@ *S*  6*  6*  6 *S *S  *S@ @  *S  * S   gS   ߹gS  S S  2S  gS * SG j6 S S S **S):: *S u\ *Kt %,<L\l{/?PUfw "8 E h w        ) . 0) 28 4\ 6r 8 9 ; < = ? @ A B D F G H I K N% O5 PB QH TS VX Xb Zm [} ] _ ` d e f g j k n p r, uL vZ wh xn yt z~ { | ~           & ) 0 .     8"  | E5SucAAAAAA%%,W  $ {:E2$>2% p  g!:C     _    3         ] *+,- 4       L:MYN:-N:LYPSLYPSLYPSLYSPSLYPSLYPSLYPSLYPS*::,62,@- Y *,BC:: Y *-BC:12@' Y *BC: Y :*:5fg: ޹g: g: l: l: *  :::6S6*2:2M:6{|: @::S S S S* S*SS*SuR*K:      0 @ P ` p     ? U e o z    ! " # $ % & ( * + - . / 1+ 2> 3E 4J 5P 6V 7\ 8i 9v :} ; < / + ? @ B3+g>TEMz$     eTU% `  y'$A[  y     cL:MYN:LYPSLYPSLYPSLYPSLYPSLYPSLYPS*;:,72,@. Y A*,BC::-/2-@& Y *-BC: Y :*:#fg:޹g: l: l: *  :  :  :6 S 6 * 2:  2M:6{u: @::SS S* S*SS*SuY*K2 e f h i0 j@ kP l` mp n q s x z   ! + 6 A M Y c m t w               ! ' 5 < B H K R 3`MF|6A M Y c m twcccc\S!B /& U  y'$AT  y    ;<*d3`=*#*2*2*2N**2S*-S݄˱&  $ * . 4 : *$ &8;  ʻMYNL* *+=> 66*K*6"\=,+* u`>6+**d u6+{?+:( $( d :+ +^       ) 1 ? L W b g k q \ 1: Q+E-  &@ > E+ >+ ::+`:66 CDRTUXaldrttw|x:`:X:P:H:@:8:0:(: ::::,M:  MYN: , W u*     # , 9 B                " # % & ( ) + - .% 0. 17 3> D 5f B  /EEE=/,F !  U+ Y , L+!NY":6-{-:*#& = @ B$ C- D9 FD GL DR IHD0"UUU$1-(!E7L:MYN:LY$PSLYSPSLYUPSLYVPSLYPSLYPSLYPSLY%PS2: *@&:': ,72,@. Y  *,BC: (: Y )*+,*-BC -: * :  :  j6  ݹ6* 6* 6* 6 *S  gS ** S ** S *S S *S *S u*K& q r t u0 v? wO x^ ym z} { ! 1 ; B N Y k }           # & 8B N Yk}777777 0'W  ! 1     P b         L:MYN:LY$PSLYSPSLYUPSLYVPSLYPSLYPSLYPSLY%PS:S*.S**/0S*/SSSS*Su*KV   0 ? O ^ m } H    v   2:*E1:&:':,<2,@3 Y *,BC: 2:(: Y 3456*+:-02-@' Y ,*-BC: Y 7:*K:      , R W \ ( * , .f =8W\ Y,R  j    4L:LY8PSLY9PSLY:PSLY;PSLY<PSLY=PSLY>PSLY?PSLY@PS LYAPS LYBPS LYCPS LYDPS LYEPS2: *tF: ** Y  G*;H:  Y  I: Y  J: ,02,@' Y  K*,BC: 22@( Y  L*BC: -02-@' Y  M*-BC: 22@( Y  N*BC: - Y  O:  Y  P: *K *uQ:R: ,02,@' Y  S*,BC: ?2@5 Y  T*BC: U:V: Y WXYZ[\]^_` abcdefghijk : -' Y  l*-BC: ( Y  m*BC: Y  n: -@* Y  o: Y  p: =* Y  q: Y  r: Y  s: * : MYN:  W: tS tS tS tS u:  u:{d :6v@6w@ 63x@ 6"y@ 6z@6 *S  u:hd :6w@ 63x@ 6"y@ 6z@6 *S 62:2:2:  u:{|:{:} :dh`6{:{:*S*S tS *S  tS6 ~6  ~6 66 *S u*K ~ = ? @) A: BK C\ Dm E F G H I J K L Q ^ ` { |A ~X o |       9 = W n z                  + E Q h           ! " $ ( * ,. -1 .< /B 0M 1S 2^ 3d 4o 5r 7 ; = @ B C D E F G H I J K O R S T Z `$ a, c7 fB hF kP lZ nf qi rs t w x z { |           `#l mh heURJ| $PB7, !"#! !   x o$ &A  G303 F  6    )="/ ~   3 >  n    %S *+,- *      &S *+,-*      't*+,-=H !"#  (-LLMYNM+LYVPS+LYUPS+LYWPS+LYPS+LYPS+LYPS+LY[PS+LYPS+LYPS+ LYPS+ LYPS+ LYPS+ LYPS+ LYPS+LYPS+LYPS+LYPS+LYPS* NN*-:*:*:*:*:*: *: *: o: u: 6 * S ** 0S **S*  S  S  S *S  S  *S  S  S  S *S S, u @- :*S S,u4 @* :*S S,u*K+,Apqst+u9vIwYxiyxz{|}~&29=LXco{ #)0MTqx6))b X* M-'=LX+c,o-{./ 0 1  9c        !    .    A0  23 22:*1:::*4 Y : Y : Y :,A2,@8 Y *,BC:2::: Y : * Y  :  Y  : Y  : * Y  : @*# Y  :  Y  : Y  ,*-BC:  Y  : Y  : *K v +B \"s$&+,-0;=.AEE\IhKMOSV[]_&`z 22222425. * T \2    x<%O  67OMYNM>*6+64*+6,*u* :,u`>,:gh ijln$o)q2r5v>wDxJzM{R> 8$&9O:O;G< E=?>9?@L   A @  B8l  AC   D6A  E6A  F6A  G6A  H6  I6A  J6A  K6  L6A  M,   NOT :*:M:*06 Y *B: Y :2: Y :6Y.K4 Y : Y : Y : Y :-d-.6-.6)-` M - M-`N Y *-B:,( Y *,B: Y : Y ¶:*K:!)9dg~  /3;CIP!^&f)o+/13457);9+TP^;YQCQRSTxU(VS9&.$(  WX/*B   Y6IA  Z6NA  [\8*ðS   ]^;-Y"Y"K*W*ŶW*ƶWY"K*W*ȶW*ɶWY"K*W*˶W*̶WY"K*W*ζW*ζWY"K*W*жW*ѶWY"K*W*ӶW*ԶWY"K*W*ֶW*׶WY"K*W*ٶW*ڶWY"K*W*ܶW*ݶWY"K*W*߶W*WY"K*W*W*WY"K*W*W*WY"K*W*W*WY"K*W*W*W: '19 D!N"X#`$k%u&'()*+,-./01234567#8.98:B;J<U=_>i?q@|ABCDEFGHIJKLMNO PQ"R,S _`a