PSQL History not working
am 01.12.2004 14:25:47 von Pradeepkumar.Pyatalo
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4D7A9.44DFBD18
Content-Type: text/plain
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
------_=_NextPart_001_01C4D7A9.44DFBD18
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
charset=3DUS-ASCII">
5.5.2658.2">
PSQL History not working
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,
Antiqua">Pradeep
------_=_NextPart_001_01C4D7A9.44DFBD18--
Re: PSQL History not working
am 01.12.2004 16:38:29 von Dom
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/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Re: PSQL History not working
am 01.12.2004 16:40:41 von Tom Lane
"Pradeepkumar, Pyatalo (IE10)" 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend