[PATCH] psql \n shortcut for set search_path =

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
Thread:
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2012-07-10 11:47:49 Re: expression evaluation with expected datatypes
Previous Message Heikki Linnakangas 2012-07-10 09:38:52 Re: Testing of various opclasses for ranges