pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PSQL History not working
3+ messages / 3 participants
[nested] [flat]

* PSQL History not working
@ 2004-12-01 13:25 Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
  2004-12-01 15:38 ` Re: PSQL History not working Dominic Mitchell <dom@happygiraffe.net>
  2004-12-01 15:40 ` Re: PSQL History not working Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: Pradeepkumar, Pyatalo (IE10) @ 2004-12-01 13:25 UTC (permalink / raw)
  To: pgsql-admin


Hi all,

I am using Postgresql 7.4.3. Everythings working fine except for the psql
history. I did go through the documentation, but did not get much
information about it. The psql doesn't remember the previous commands. There
is no .psql_history file under the $HOME/ and there is no .psqlrc file also.
Its real pain to retype the same command all the time.

Could anyone help me in configuring the .psql_history file.

Thanx in advance.

Regs,
Pradeep

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PSQL History not working
  2004-12-01 13:25 PSQL History not working Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
@ 2004-12-01 15:38 ` Dominic Mitchell <dom@happygiraffe.net>
  1 sibling, 0 replies; 3+ messages in thread

From: dom@happygiraffe.net @ 2004-12-01 15:38 UTC (permalink / raw)
  To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>; +Cc: pgsql-admin

On Wed, Dec 01, 2004 at 06:25:47AM -0700, Pradeepkumar, Pyatalo (IE10) wrote:
> I am using Postgresql 7.4.3. Everythings working fine except for the psql
> history. I did go through the documentation, but did not get much
> information about it. The psql doesn't remember the previous commands. There
> is no .psql_history file under the $HOME/ and there is no .psqlrc file also.
> Its real pain to retype the same command all the time.
> 
> Could anyone help me in configuring the .psql_history file.

It sounds like your version of postgres was built without readline
support.  I see this output on my FreeBSD box:

    % psql -V
    psql (PostgreSQL) 7.4.6
    contains support for command-line editing

Unless your output contains that, you'll probably have to rebuild
PostgreSQL.

If you don't want to rebuild PostgreSQL, you might want to look at
something like rlwrap[1] which will do the same sort of thing.

-Dom

[1] http://utopia.knoware.nl/~hlub/uck/rlwrap/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PSQL History not working
  2004-12-01 13:25 PSQL History not working Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
@ 2004-12-01 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-12-01 15:40 UTC (permalink / raw)
  To: Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>; +Cc: pgsql-admin

"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com> writes:
> I am using Postgresql 7.4.3. Everythings working fine except for the psql
> history. I did go through the documentation, but did not get much
> information about it. The psql doesn't remember the previous commands. There
> is no .psql_history file under the $HOME/ and there is no .psqlrc file also.

It sounds to me like you have a build without the readline library.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-12-01 15:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-01 13:25 PSQL History not working Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com>
2004-12-01 15:38 ` Dominic Mitchell <dom@happygiraffe.net>
2004-12-01 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>

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