[PATCH] Add \ns command to psql

From: "Colin 't Hart" <colin(at)sharpheart(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] Add \ns command to psql
Date: 2013-04-16 09:40:16
Message-ID: CAMon-aS+8P9EVCDVMJfECQvxRzb59Adfab_ts_M7LaRECOetfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Here's a new version of a small patch to psql I'm using locally.

It adds a command \ns to psql which is a shortcut to set the
SEARCH_PATH variable.

I'd like to make a case for including this patch as it makes use of
schemas/namespaces much easier. There was resistance to including this
before just because some developers don't use schemas very much. But
we use a lot of them. And I'm sure we're not alone.

Previously I used just \n but there was some resistance to this
because the single letter commands are becoming scarce.

I've also added tab completion making this command much more useful. I
don't think tab completition would be possible if this command was
defined as a variable (which was another suggestion offered at the
time).

Cheers,

Colin

Attachment Content-Type Size
command.c.diff application/octet-stream 1.6 KB
tab-complete.c.diff application/octet-stream 655 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2013-04-16 11:38:16 Re: COPY and Volatile default expressions
Previous Message Pavel Stehule 2013-04-16 09:25:18 Re: "stored procedures"