branch: elpa/pg
commit d069564698a492196574e85c32bb071a8565dff4
Author: Eric Marsden <eric.mars...@risk-engineering.org>
Commit: Eric Marsden <eric.mars...@risk-engineering.org>
Formatting.
---
pg.el | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pg.el b/pg.el
index eb2198e38f8..00818aaac7f 100644
--- a/pg.el
+++ b/pg.el
@@ -3707,7 +3707,7 @@ Queries the information schema."
(let* ((default-schema (if (eq (pgcon-server-variant con) 'cratedb)
"postgres"
"public"))
- (res (pg-exec con "SELECT table_schema,table_name FROM
information_schema.tables
+ (res (pg-exec con "SELECT DISTINCT table_schema,table_name FROM
information_schema.tables
WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
AND table_type='BASE TABLE'")))
(cl-loop
for tuple in (pg-result res :tuples)
