From 0f6e82715ca1051f8476508673ee17e4881dad93 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Wed, 10 Jan 2018 05:31:12 +0000 Subject: [PATCH] lib/php/db/types/pgsql.php --- 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 0837a2e0..c7f03217 100644 --- a/lib/php/db/types/pgsql.php +++ b/lib/php/db/types/pgsql.php @@ -24,7 +24,8 @@ $DB_TYPES['pgsql'] = array ( '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 = 'public'", +# NB 10.01.18 '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'", +'tables' => "SELECT table_name as name,LOWER(CASE table_type WHEN 'BASE TABLE' THEN 'TABLE' ELSE table_type END) as type FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema = 'public'", 'table.sql.create' => function($sql) { $sql = preg_replace('/ESCAPE \'.*?\'/','',$sql); -- 2.47.3