\dn suggests schemas only

2 files changed, 11 insertions, 0 deletions

diff --git a/pgcli/packages/sqlcompletion.py b/pgcli/packages/sqlcompletion.py
index 91bd616d..b4379437 100644
--- a/pgcli/packages/sqlcompletion.py
+++ b/pgcli/packages/sqlcompletion.py
@@ -86,6 +86,9 @@ def suggest_special(text):
     if cmd == '\\c':
         return [{'type': 'database'}]
 
+    if cmd == '\\dn':
+        return [{'type': 'schema'}]
+
     if arg:
         # Try to distinguish "\d name" from "\d schema.name"
         # Note that this will fail to obtain a schema name if wildcards are
diff --git a/tests/test_pgspecial.py b/tests/test_pgspecial.py
index e16631a2..39f9f979 100644
--- a/tests/test_pgspecial.py
+++ b/tests/test_pgspecial.py
@@ -11,6 +11,14 @@ def test_slash_d_suggests_special():
     assert sorted_dicts(suggestions) == sorted_dicts(
         [{'type': 'special'}])
 
+def test_dn_suggests_schemata():
+    suggestions = suggest_type('\\dn ', '\\dn ')
+    assert suggestions == [{'type': 'schema'}]
+
+    suggestions = suggest_type('\\dn xxx', '\\dn xxx')
+    assert suggestions == [{'type': 'schema'}]
+
+
 def test_d_suggests_tables_and_schemas():
     suggestions = suggest_type('\d ', '\d ')
     assert sorted_dicts(suggestions) == sorted_dicts([