"(SELECT+TABLENAME::text+FROM pg_tables WHERE SCHEMANAME={db} OFFSET 0 LIMIT 1)",
1651
-
"(SELECT+TABLENAME::text+FROM pg_tables WHERE SCHEMANAME LIKE {db} OFFSET 0 LIMIT 1)",
1652
-
"(SELECT+TABLENAME::text+FROM pg_tables WHERE SCHEMANAME IN({db}) OFFSET 0 LIMIT 1)",
1653
-
"(SELECT TABLE_NAME::text+FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA={db} OFFSET 0 LIMIT 1)",
1654
-
"(SELECT TABLE_NAME::text+FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE {db} OFFSET 0 LIMIT 1)",
1655
-
"(SELECT TABLE_NAME::text+FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA IN({db}) OFFSET 0 LIMIT 1)",
1650
+
"(SELECTTABLENAME::textFROM pg_tables WHERE SCHEMANAME={db} OFFSET 0 LIMIT 1)",
1651
+
"(SELECTTABLENAME::textFROM pg_tables WHERE SCHEMANAME LIKE {db} OFFSET 0 LIMIT 1)",
1652
+
"(SELECTTABLENAME::textFROM pg_tables WHERE SCHEMANAME IN({db}) OFFSET 0 LIMIT 1)",
1653
+
"(SELECT TABLE_NAME::textFROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA={db} OFFSET 0 LIMIT 1)",
1654
+
"(SELECT TABLE_NAME::textFROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE {db} OFFSET 0 LIMIT 1)",
1655
+
"(SELECT TABLE_NAME::textFROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA IN({db}) OFFSET 0 LIMIT 1)",
1656
1656
],
1657
1657
"Microsoft SQL Server": [
1658
1658
"(SELECT TOP 1 {db}..sysusers.name+CHAR(46)+{db}..sysobjects.name AS table_name FROM {db}..sysobjects INNER JOIN {db}..sysusers ON {db}..sysobjects.uid={db}..sysusers.uid WHERE {db}..sysobjects.xtype IN (CHAR(117),CHAR(118)) AND {db}..sysusers.name+CHAR(46)+{db}..sysobjects.name NOT IN (SELECT TOP 0 {db}..sysusers.name+'.'+{db}..sysobjects.name AS table_name FROM {db}..sysobjects INNER JOIN {db}..sysusers ON {db}..sysobjects.uid={db}..sysusers.uid WHERE {db}..sysobjects.xtype IN (CHAR(117),CHAR(118)) ORDER BY {db}..sysusers.name+'.'+{db}..sysobjects.name)ORDER BY {db}..sysusers.name+'.'+{db}..sysobjects.name)",
"(SELECT COUNT(COLUMN_NAME)::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE {db} AND TABLE_NAME LIKE {tbl})",
1687
-
"(SELECT COUNT(COLUMN_NAME)::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA={db} AND TABLE_NAME={tbl})",
1688
-
"(SELECT COUNT(COLUMN_NAME)::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}))",
1686
+
"(SELECT COUNT(COLUMN_NAME)::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE {db} AND TABLE_NAME LIKE {tbl})",
1687
+
"(SELECT COUNT(COLUMN_NAME)::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA={db} AND TABLE_NAME={tbl})",
1688
+
"(SELECT COUNT(COLUMN_NAME)::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}))",
1689
1689
"(SELECT COUNT(*) FROM pg_namespace,pg_type,pg_attribute b JOIN pg_class a ON a.oid=b.attrelid WHERE a.relnamespace=pg_namespace.oid AND pg_type.oid=b.atttypid AND attnum>0 AND nspname={db} AND a.relname={tbl})",
"(SELECT COLUMN_NAME::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE {db} AND TABLE_NAME LIKE {tbl} OFFSET 0 LIMIT 1)",
1718
-
"(SELECT COLUMN_NAME::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA={db} AND TABLE_NAME={tbl} OFFSET 0 LIMIT 1)",
1719
-
"(SELECT COLUMN_NAME::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}) OFFSET 0 LIMIT 1)",
1720
-
"(SELECT CONCAT(COLUMN_NAME)::text+FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}) OFFSET 0 LIMIT 1)",
1717
+
"(SELECT COLUMN_NAME::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE {db} AND TABLE_NAME LIKE {tbl} OFFSET 0 LIMIT 1)",
1718
+
"(SELECT COLUMN_NAME::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA={db} AND TABLE_NAME={tbl} OFFSET 0 LIMIT 1)",
1719
+
"(SELECT COLUMN_NAME::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}) OFFSET 0 LIMIT 1)",
1720
+
"(SELECT CONCAT(COLUMN_NAME)::textFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA IN({db}) AND TABLE_NAME IN({tbl}) OFFSET 0 LIMIT 1)",
1721
1721
"(SELECT attname FROM pg_namespace,pg_type,pg_attribute b JOIN pg_class a ON a.oid=b.attrelid WHERE a.relnamespace=pg_namespace.oid AND pg_type.oid=b.atttypid AND attnum>0 AND nspname={db} AND a.relname={tbl} OFFSET 0 LIMIT 1)",