Postgres Pro
Downloads
Home   >   mailing lists

Re: How to show the current schema or search path in the psql PROMP - Mailing list pgsql-general

From Alban Hertroys
Subject Re: How to show the current schema or search path in the psql PROMP
Date
Msg-id F0F09869-7B12-4DBB-B849-62DE8B8E9082@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: How to show the current schema or search path in the psql PROMP  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
Responses Re: How to show the current schema or search path in the psql PROMP  (Schwaighofer Clemens <clemens.schwaighofer@tequila.jp>)
List pgsql-general
Tree view 
On 14 Jun 2010, at 2:02, Clemens Schwaighofer wrote:

> Right now I added two simple wrappers in my .psqlrc
>
> \set shsh 'SHOW search_path;'
> \set setsh 'SET search_path TO'
>
> So I can at least set and check the schema more quickly.


That only saves you a few key-presses though. Is your psql built with libreadline? Without it you don't get
TAB-completion,that would be a nuisance! 

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4c160039286219954085656!

pgsql-general by date:

Previous
From: Janning
Date:
Subject: Re: checkpoint spikes
Next
From: Schwaighofer Clemens
Date:
Subject: Re: How to show the current schema or search path in the psql PROMP