summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--db.lua2
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