pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: use of arrow keys to traverse history
7+ messages / 5 participants
[nested] [flat]
* use of arrow keys to traverse history
@ 2001-04-25 18:42 ` Peter J. Schoenster <borg@errorcode.com>
2001-04-25 18:13 ` Re: use of arrow keys to traverse history Andrew Perrin <andrew_perrin@unc.edu>
2001-04-25 22:08 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
1 sibling, 2 replies; 7+ messages in thread
From: Peter J. Schoenster @ 2001-04-25 18:42 UTC (permalink / raw)
To: pgsql-sql
Hi,
Not sure where this question belongs ... I thought postgresql was
running under the bash shell where I can use up and down arrow
keys to traverse my command history. I can do this in mysql but
oddly not in oracle or postgresql.
/home/postgres
-rw-r--r-- 1 postgres postgres 1422 Feb 16 15:50 .Xdefaults
-rw------- 1 postgres postgres 458 Feb 17 16:59 .bash_history
-rw-r--r-- 1 postgres postgres 24 Feb 16 15:50 .bash_logout
-rw-r--r-- 1 postgres postgres 230 Feb 16 15:50 .bash_profile
-rw-r--r-- 1 postgres postgres 313 Feb 17 16:36 .bashrc
Which in my ignorance leads me to believe that postgres will run in
the bash shell and so I expect the use of arrow keys or command
history.
Clues appreciated.
Peter
---------------------------
"Reality is that which, when you stop believing in it, doesn't go
away".
-- Philip K. Dick
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
@ 2001-04-25 18:13 ` Andrew Perrin <andrew_perrin@unc.edu>
1 sibling, 0 replies; 7+ messages in thread
From: Andrew Perrin @ 2001-04-25 18:13 UTC (permalink / raw)
To: borg@errorcode.com; +Cc: pgsql-sql
These do suggest (although not require) that the *user* postgres will be
running bash when logged in. To check for sure, do:
finger postgres
which will give you the current shell among other things.
However, this doesn't speak to what I think you're asking, which is
command history and completion within psql (the program), not postgres
(the user). If that's what you want, you have to compile psql with gnu
readline support, which means you also have to have the gnu readline
libraries available on your machine.
Andy Perrin
"Peter J. Schoenster" wrote:
>
> Hi,
>
> Not sure where this question belongs ... I thought postgresql was
> running under the bash shell where I can use up and down arrow
> keys to traverse my command history. I can do this in mysql but
> oddly not in oracle or postgresql.
>
> /home/postgres
>
> -rw-r--r-- 1 postgres postgres 1422 Feb 16 15:50 .Xdefaults
> -rw------- 1 postgres postgres 458 Feb 17 16:59 .bash_history
> -rw-r--r-- 1 postgres postgres 24 Feb 16 15:50 .bash_logout
> -rw-r--r-- 1 postgres postgres 230 Feb 16 15:50 .bash_profile
> -rw-r--r-- 1 postgres postgres 313 Feb 17 16:36 .bashrc
>
> Which in my ignorance leads me to believe that postgres will run in
> the bash shell and so I expect the use of arrow keys or command
> history.
>
> Clues appreciated.
>
> Peter
>
> ---------------------------
> "Reality is that which, when you stop believing in it, doesn't go
> away".
> -- Philip K. Dick
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
--------------------------------------------------------------
Andrew J. Perrin - Programmer/Analyst, Desktop Support
Children's Primary Care Research Group, UNC - Chapel Hill
(919)966-9394 * andrew_perrin@unc.edu
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
@ 2001-04-25 22:08 ` Grant <grant@conprojan.com.au>
2001-04-25 16:12 ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
1 sibling, 1 reply; 7+ messages in thread
From: Grant @ 2001-04-25 22:08 UTC (permalink / raw)
To: pgsql-sql
I am finding that I can't use the cursor keys at all in psql after I
upgraded to v7.1. I have installed v7.1 on redhat 7.1, mandrake 7.2,
redhat 6.2 and none of them allow me to use the cursors keys, where as
v7.0.3 did. I haven't changed anything on the system except upgrade
postgresql to v7.1. Any ideas?
Thanks.
On Wed, 25 Apr 2001, Peter J. Schoenster wrote:
> Hi,
>
> Not sure where this question belongs ... I thought postgresql was
> running under the bash shell where I can use up and down arrow
> keys to traverse my command history. I can do this in mysql but
> oddly not in oracle or postgresql.
>
> /home/postgres
>
> -rw-r--r-- 1 postgres postgres 1422 Feb 16 15:50 .Xdefaults
> -rw------- 1 postgres postgres 458 Feb 17 16:59 .bash_history
> -rw-r--r-- 1 postgres postgres 24 Feb 16 15:50 .bash_logout
> -rw-r--r-- 1 postgres postgres 230 Feb 16 15:50 .bash_profile
> -rw-r--r-- 1 postgres postgres 313 Feb 17 16:36 .bashrc
>
> Which in my ignorance leads me to believe that postgres will run in
> the bash shell and so I expect the use of arrow keys or command
> history.
>
> Clues appreciated.
>
> Peter
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
2001-04-25 22:08 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
@ 2001-04-25 16:12 ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 22:16 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
0 siblings, 1 reply; 7+ messages in thread
From: Martín Marqués @ 2001-04-25 16:12 UTC (permalink / raw)
To: Grant <grant@conprojan.com.au>; pgsql-sql
On Jue 26 Abr 2001 01:08, Grant wrote:
> I am finding that I can't use the cursor keys at all in psql after I
> upgraded to v7.1. I have installed v7.1 on redhat 7.1, mandrake 7.2,
> redhat 6.2 and none of them allow me to use the cursors keys, where as
> v7.0.3 did. I haven't changed anything on the system except upgrade
> postgresql to v7.1. Any ideas?
That's because your version (talking about binaries) are not compiled with
readline support. :-)
Saludos... :-)
--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
2001-04-25 22:08 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
2001-04-25 16:12 ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
@ 2001-04-25 22:16 ` Grant <grant@conprojan.com.au>
2001-04-26 13:50 ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
0 siblings, 1 reply; 7+ messages in thread
From: Grant @ 2001-04-25 22:16 UTC (permalink / raw)
To: pgsql-sql
> That's because your version (talking about binaries) are not compiled with
> readline support. :-)
Which binaries are not compiled with readline support?
Why did this change from 7.0.3 -> 7.1?
Thanks.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
2001-04-25 18:42 ` use of arrow keys to traverse history Peter J. Schoenster <borg@errorcode.com>
2001-04-25 22:08 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
2001-04-25 16:12 ` Re: use of arrow keys to traverse history Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 22:16 ` Re: use of arrow keys to traverse history Grant <grant@conprojan.com.au>
@ 2001-04-26 13:50 ` Martín Marqués <martin@bugs.unl.edu.ar>
0 siblings, 0 replies; 7+ messages in thread
From: Martín Marqués @ 2001-04-26 13:50 UTC (permalink / raw)
To: pgsql-sql
On Jue 26 Abr 2001 01:16, Grant wrote:
> > That's because your version (talking about binaries) are not compiled
> > with readline support. :-)
>
> Which binaries are not compiled with readline support?
>
> Why did this change from 7.0.3 -> 7.1?
I don't have the slightest idea.
Are you on rpms? If so, download the src.rpm and check the SPEC file for the
config options, and then compile with rpm --rebuild <package>
Saludos... :-)
--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: use of arrow keys to traverse history
@ 2001-04-25 19:17 ` Dorin Grunberg <dorin@visgen.com>
1 sibling, 0 replies; 7+ messages in thread
From: Dorin Grunberg @ 2001-04-25 19:17 UTC (permalink / raw)
To: borg@errorcode.com; pgsql-sql
You need to install Readline library. I know I used readline 4.1 and it
works great.
Dorin
At 12:42 PM 4/25/2001 -0600, Peter J. Schoenster wrote:
>Hi,
>
>Not sure where this question belongs ... I thought postgresql was
>running under the bash shell where I can use up and down arrow
>keys to traverse my command history. I can do this in mysql but
>oddly not in oracle or postgresql.
>
>/home/postgres
>
>-rw-r--r-- 1 postgres postgres 1422 Feb 16 15:50 .Xdefaults
>-rw------- 1 postgres postgres 458 Feb 17 16:59 .bash_history
>-rw-r--r-- 1 postgres postgres 24 Feb 16 15:50 .bash_logout
>-rw-r--r-- 1 postgres postgres 230 Feb 16 15:50 .bash_profile
>-rw-r--r-- 1 postgres postgres 313 Feb 17 16:36 .bashrc
>
>Which in my ignorance leads me to believe that postgres will run in
>the bash shell and so I expect the use of arrow keys or command
>history.
>
>Clues appreciated.
>
>Peter
>
>---------------------------
>"Reality is that which, when you stop believing in it, doesn't go
>away".
> -- Philip K. Dick
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2001-04-26 13:50 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-25 18:42 ` Peter J. Schoenster <borg@errorcode.com>
2001-04-25 18:13 ` Andrew Perrin <andrew_perrin@unc.edu>
2001-04-25 22:08 ` Grant <grant@conprojan.com.au>
2001-04-25 16:12 ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 22:16 ` Grant <grant@conprojan.com.au>
2001-04-26 13:50 ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-04-25 19:17 ` Dorin Grunberg <dorin@visgen.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox