From a72e0996ca79be935ed4a04c737d83e63c872d5d Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Wed, 29 Mar 2017 16:49:11 +0100 Subject: [PATCH] postgres table from only public schema --- lib/php/db/types/pgsql.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/php/db/types/pgsql.php b/lib/php/db/types/pgsql.php index ce315d52..85b9fa08 100644 --- a/lib/php/db/types/pgsql.php +++ b/lib/php/db/types/pgsql.php @@ -25,7 +25,8 @@ ORDER BY 1", 'databases' => 'SELECT datname as name,pg_catalog.pg_get_userbyid(datdba) as owner,pg_catalog.pg_encoding_encoding) as encoding, datcollate as "collate",datctype as "Ctype" FROM pg_catalog.pg_database', 'sql.drop' => 'DROP IF EXISTS "" CASCADE', -'tables' => "SELECT table_name as name,LOWER(CASE table_type WHEN 'BASE TABLE' THEN 'TABLE' ELSE table_type END) as type,table_type FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema NOT IN ('pg_catalog', 'information_schema')", +#'tables' => "SELECT table_name as name,LOWER(CASE table_type WHEN 'BASE TABLE' THEN 'TABLE' ELSE table_type END) as type,table_type FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema NOT IN ('pg_catalog', 'information_schema')", +'tables' => "SELECT table_name as name,LOWER(CASE table_type WHEN 'BASE TABLE' THEN 'TABLE' ELSE table_type END) as type,table_type FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema = 'public'", # NB 02.08.16 'create' => function(&$field) { # NB 02.08.16 $r = array( -- 2.47.3