From 4b89a027445461a800a12ab772f0f6d50ea40c0c Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Sat, 27 Feb 2016 18:39:00 +0000 Subject: [PATCH] db.tables no mor temporaries but views --- lib/php/db.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/php/db.php b/lib/php/db.php index a85cae47..9539aa7a 100644 --- a/lib/php/db.php +++ b/lib/php/db.php @@ -212,7 +212,7 @@ class db extends nb { $sql = "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%' ORDER BY name"; } elseif ($this->type == 'pgsql') { - $sql = "SELECT table_name FROM information_schema.tables WHERE table_type in('BASE TABLE','LOCAL TEMPORARY') AND table_schema NOT IN ('pg_catalog', 'information_schema')"; + $sql = "SELECT table_name FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema NOT IN ('pg_catalog', 'information_schema')"; } elseif ($this->type == 'mysql') { $sql = "SHOW TABLES"; -- 2.47.3