Modify db to only report tables in public schema for postgresql

We can add proper schema support in the future

1 files changed, 1 insertions, 1 deletions

diff --git a/db.lua b/db.lua
index 214cf39..3236e1a 100644
--- a/db.lua
+++ b/db.lua
@@ -126,7 +126,7 @@ end
 export.listtables = function(dbobject)
 	local result = {}
 	if dbobject.engine == mymodule.engine.postgresql then
-		local tab = dbobject.getselectresponse("SELECT tablename FROM pg_tables WHERE tablename !~* 'pg_*' ORDER BY tablename ASC")
+		local tab = dbobject.getselectresponse("SELECT tablename FROM pg_tables WHERE tablename !~* 'pg_*' AND schemaname = 'public' ORDER BY tablename ASC")
 		for i,t in ipairs(tab) do
 			result[#result+1] = t.tablename
 		end