if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND p.proname LIKE " + escapeQuotes(procedureNamePattern); sql += " WHERE p.proname LIKE " + escapeQuotes(procedureNamePattern); if (procedureNamePattern != null) sql += " WHERE p.proname LIKE " + escapeQuotes(procedureNamePattern);
if (schema != null && !"".equals(schema)) sql += " AND n.nspname = " + escapeQuotes(schema); if (schema != null && !"".equals(schema)) where += " AND n.nspname = " + escapeQuotes(schema); sql += " AND ct.relname = " + escapeQuotes(table);
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND nspname LIKE " + escapeQuotes(schemaPattern); sql += " WHERE ''::text LIKE " + escapeQuotes(schemaPattern);
String pgType = (String)i.next(); int sqlType = connection.getTypeInfo().getSQLType(pgType); sql += " when typname = " + escapeQuotes(pgType) + " then " + sqlType; toAdd += " and t.typname like " + escapeQuotes(typeNamePattern); toAdd += " and n.nspname like " + escapeQuotes(schemaPattern);
if (schemaPattern != null && !"".equals(schemaPattern)) select += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); select += " AND c.relname LIKE " + escapeQuotes(tableNamePattern);
sql += " AND n.nspname = " + escapeQuotes(schema); where += " AND n.nspname = " + escapeQuotes(schema); sql += " AND ct.relname = " + escapeQuotes(tableName);
if (schema != null && !"".equals(schema)) sql += " AND n.nspname = " + escapeQuotes(schema); sql += " AND c.relname = " + escapeQuotes(table); if (columnNamePattern != null && !"".equals(columnNamePattern)) sql += " AND a.attname LIKE " + escapeQuotes(columnNamePattern);
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND c.relname LIKE " + escapeQuotes(tableNamePattern);
if (primarySchema != null && !"".equals(primarySchema)) sql += " AND pkn.nspname = " + escapeQuotes(primarySchema); sql += " AND fkn.nspname = " + escapeQuotes(foreignSchema); sql += " AND pkc.relname = " + escapeQuotes(primaryTable); sql += " AND fkc.relname = " + escapeQuotes(foreignTable); if (primarySchema != null && !"".equals(primarySchema)) where += " AND n1.nspname = " + escapeQuotes(primarySchema); where += " AND n2.nspname = " + escapeQuotes(foreignSchema); sql += "AND c1.relname=" + escapeQuotes(primaryTable); sql += "AND c2.relname=" + escapeQuotes(foreignTable);
if (schema != null && !"".equals(schema)) sql += " AND n.nspname = " + escapeQuotes(schema); if (schema != null && !"".equals(schema)) where += " AND n.nspname = " + escapeQuotes(schema); sql += " AND ct.relname = " + escapeQuotes(table) + " AND i.indisprimary " + " ORDER BY a.attnum ";
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND p.proname LIKE " + escapeQuotes(procedureNamePattern); if (procedureNamePattern != null) sql += " AND p.proname LIKE " + escapeQuotes(procedureNamePattern);
sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND c.relname LIKE " + escapeQuotes(tableNamePattern); sql += " AND c.relname LIKE " + escapeQuotes(tableNamePattern); sql += " AND attname LIKE " + escapeQuotes(columnNamePattern);
if (schema != null && !"".equals(schema)) where += " AND n.nspname = '" + escapeQuotes(schema) + "' "; if (table != null && !"".equals(table)) sql += " AND ct.relname = '" + escapeQuotes(table) + "' ";
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND p.proname LIKE " + escapeQuotes(procedureNamePattern); sql += " WHERE p.proname LIKE " + escapeQuotes(procedureNamePattern); if (procedureNamePattern != null) sql += " WHERE p.proname LIKE " + escapeQuotes(procedureNamePattern);
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE '" + escapeQuotes(schemaPattern) + "' "; sql += " AND p.proname LIKE '" + escapeQuotes(procedureNamePattern) + "' "; sql += " WHERE p.proname LIKE '" + escapeQuotes(procedureNamePattern) + "' "; if (procedureNamePattern != null) sql += " WHERE p.proname LIKE '" + escapeQuotes(procedureNamePattern) + "' ";
if (schema != null && !"".equals(schema)) sql += " AND n.nspname = " + escapeQuotes(schema); if (schema != null && !"".equals(schema)) where += " AND n.nspname = " + escapeQuotes(schema); sql += " AND ct.relname = " + escapeQuotes(table);
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND nspname LIKE " + escapeQuotes(schemaPattern); sql += " WHERE ''::text LIKE " + escapeQuotes(schemaPattern);
String pgType = (String)i.next(); int sqlType = connection.getTypeInfo().getSQLType(pgType); sql += " when typname = " + escapeQuotes(pgType) + " then " + sqlType; toAdd += " and t.typname like " + escapeQuotes(typeNamePattern); toAdd += " and n.nspname like " + escapeQuotes(schemaPattern);
if (schemaPattern != null && !"".equals(schemaPattern)) sql += " AND n.nspname LIKE " + escapeQuotes(schemaPattern); sql += " AND c.relname LIKE " + escapeQuotes(tableNamePattern);
if (schema != null && !"".equals(schema)) where += " AND n.nspname = '" + escapeQuotes(schema) + "' "; " WHERE ct.oid=i.indrelid AND ci.oid=i.indexrelid " + " AND a.attrelid=ci.oid AND i.indisprimary " + " AND ct.relname = '" + escapeQuotes(table) + "' " + where + " ORDER BY a.attnum ";