From 850c9fd1e027c736c7ba1fb1ed5bce1acb3d6a38 Mon Sep 17 00:00:00 2001
From: Nathan Gass
Date: Fri, 8 Jan 2021 15:41:40 +0100
Subject: handle schemas in table names

---
 it_dbi_postgres.class | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/it_dbi_postgres.class b/it_dbi_postgres.class
index 9192948..46c0393 100644
--- a/it_dbi_postgres.class
+++ b/it_dbi_postgres.class
@@ -52,7 +52,8 @@ function _tables($p = array())
 
 function _get_field_defs()
 {
-	$where = $this->_where(['t.table_name' => $this->_p['table'], 't.table_catalog' => $this->_p['db']]);
+	list($table_name, $table_schema) = array_reverse(explode('.', $this->_p['table'], 2));
+	$where = $this->_where(['t.table_name' => $table_name, 't.table_schema' => $table_schema ?: 'public', 't.table_catalog' => $this->_p['db']]);
 
 	// recreate Key column of mysql show columns
 	$res = $this->query('SELECT column_name,constraint_type,ordinal_position FROM information_schema.table_constraints AS t JOIN information_schema.key_column_usage USING (constraint_name, constraint_schema, constraint_catalog) ' . $where);
-- 
cgit v1.2.3