| 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: | Whole Thread | Raw Message | 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 |
| 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 |