@@ -487,7 +487,7 @@ discard block |
||
487 | 487 | break; |
488 | 488 | case 'mssql': |
489 | 489 | $sql = 'SELECT name FROM sysobjects ' |
490 | - . "WHERE type = 'U' ORDER BY name"; |
|
490 | + . "WHERE type = 'U' ORDER BY name"; |
|
491 | 491 | break; |
492 | 492 | case 'mysql': |
493 | 493 | $sql = 'SHOW TABLES'; |
@@ -497,22 +497,22 @@ discard block |
||
497 | 497 | break; |
498 | 498 | case 'pgsql': |
499 | 499 | $sql = 'SELECT c.relname AS table_name ' |
500 | - . 'FROM pg_class c, pg_user u ' |
|
501 | - . "WHERE c.relowner = u.usesysid AND c.relkind = 'r' " |
|
502 | - . 'AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) ' |
|
503 | - . "AND c.relname !~ '^(pg_|sql_)' " |
|
504 | - . 'UNION ' |
|
505 | - . 'SELECT c.relname AS table_name ' |
|
506 | - . 'FROM pg_class c ' |
|
507 | - . "WHERE c.relkind = 'r' " |
|
508 | - . 'AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) ' |
|
509 | - . 'AND NOT EXISTS (SELECT 1 FROM pg_user WHERE usesysid = c.relowner) ' |
|
510 | - . "AND c.relname !~ '^pg_'"; |
|
500 | + . 'FROM pg_class c, pg_user u ' |
|
501 | + . "WHERE c.relowner = u.usesysid AND c.relkind = 'r' " |
|
502 | + . 'AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) ' |
|
503 | + . "AND c.relname !~ '^(pg_|sql_)' " |
|
504 | + . 'UNION ' |
|
505 | + . 'SELECT c.relname AS table_name ' |
|
506 | + . 'FROM pg_class c ' |
|
507 | + . "WHERE c.relkind = 'r' " |
|
508 | + . 'AND NOT EXISTS (SELECT 1 FROM pg_views WHERE viewname = c.relname) ' |
|
509 | + . 'AND NOT EXISTS (SELECT 1 FROM pg_user WHERE usesysid = c.relowner) ' |
|
510 | + . "AND c.relname !~ '^pg_'"; |
|
511 | 511 | break; |
512 | 512 | case 'sqlite': |
513 | 513 | $sql = "SELECT name FROM sqlite_master WHERE type='table' " |
514 | - . 'UNION ALL SELECT name FROM sqlite_temp_master ' |
|
515 | - . "WHERE type='table' ORDER BY name"; |
|
514 | + . 'UNION ALL SELECT name FROM sqlite_temp_master ' |
|
515 | + . "WHERE type='table' ORDER BY name"; |
|
516 | 516 | break; |
517 | 517 | default: |
518 | 518 | throw new Exception( |