Feature Request

Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes:

Hey,

This might not be much, but can there maybe be a future feature for
having a shortcut to "set search_path='schema-name';"
similiar to \c dbname ??

pei=# \set X 'set search_path = '
pei=# :X public;
SET
pei=# show search_path;
search_path
-------------
public

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On 20/2/06 1:26 pm, "Peter Eisentraut" <peter_e@gmx.net> wrote:

Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes:

Hey,

This might not be much, but can there maybe be a future feature for
having a shortcut to "set search_path='schema-name';"
similiar to \c dbname ??

pei=# \set X 'set search_path = '
pei=# :X public;
SET
pei=# show search_path;
search_path
-------------
public

That seems quite handy to know! can these be saved anywhere such that I
don't have to run the \set <...> command every session?

Thanks

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

ALTER USER bob SET search_path ...?

On 2/20/06, Adam Witney <awitney@sgul.ac.uk> wrote:

On 20/2/06 1:26 pm, "Peter Eisentraut" <peter_e@gmx.net> wrote:

Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes:

Hey,

This might not be much, but can there maybe be a future feature for
having a shortcut to "set search_path='schema-name';"
similiar to \c dbname ??

pei=# \set X 'set search_path = '
pei=# :X public;
SET
pei=# show search_path;
search_path
-------------
public

That seems quite handy to know! can these be saved anywhere such that I
don't have to run the \set <...> command every session?

Thanks

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

ALTER USER bob SET search_path ...?

Sorry I didn't mean the search_path example, but I was thinking I could
setup a short cut for a common query, eg:

\set logins <SQL query>
:logins

Could save this such that the short cut is available every time I open psql?

Thanks

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Am Montag, 20. Februar 2006 14:33 schrieb Adam Witney:

That seems quite handy to know! can these be saved anywhere such that I
don't have to run the \set <...> command every session?

~/.psqlrc

--
Peter Eisentraut
http://developer.postgresql.org/~petere/