[PATCH] psql \n shortcut for set search_path =

Lists: pgsql-hackers
From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] psql \n shortcut for set search_path =
Date: 2012-07-10 10:45:20
Message-ID: CAMon-aQSUr+AdJ0GSL3BX6zf7xyt6b7-63ViyxUvXWspyA2AEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi,

Attached please find a trivial patch for psql which adds a \n meta command
as a shortcut for typing set search_path =.

This allows you to navigate a database very quickly in psql as follows:

\dn

\n my_schema

\d

\d my_table

etc.

Not yet done: updating documentation (psql internal help, psql man page,
main documentation).

If this is something that is desired (I hope so as this is something I now
use a lot), I will update the documentation and resubmit.

Cheers,

Colin

Attachment Content-Type Size
psql_slash_n.patch application/octet-stream 1.1 KB