Обсуждение: lack in psql console
Hello
I have a problem in my psql console (psql 8.2.5 on Mac 10.5.6), the problem is, when I write a sentence and then I use the up and down key to see the previous sentences the sentence is loaded above the previous sentences and I should use the left and rigth keys to go to the begining of the sentences and then go to the end to be able to see the complete sentence.
Welcome to psql 8.2.5 (server 8.2.9), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
=> select * from table_name;
In this sentence I was use the up key to load the previous sentece and this is what I see.
=> select * from \d summary_table;
The sentense start after "=> select * from" I don't know why this is happend.
Thanks for all help you can provide me!
Best regard,
--
Life may only be understood backwards.... but it must be lived forwards
I have a problem in my psql console (psql 8.2.5 on Mac 10.5.6), the problem is, when I write a sentence and then I use the up and down key to see the previous sentences the sentence is loaded above the previous sentences and I should use the left and rigth keys to go to the begining of the sentences and then go to the end to be able to see the complete sentence.
Welcome to psql 8.2.5 (server 8.2.9), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
=> select * from table_name;
In this sentence I was use the up key to load the previous sentece and this is what I see.
=> select * from \d summary_table;
The sentense start after "=> select * from" I don't know why this is happend.
Thanks for all help you can provide me!
Best regard,
--
Life may only be understood backwards.... but it must be lived forwards
Hello
I have a problem in my psql console (psql 8.2.5 on Mac 10.5.6), the problem is, when I write a sentence and then I use the up and down key to see the previous sentences the sentence is loaded above the previous sentences and I should use the left and rigth keys to go to the begining of the sentences and then go to the end to be able to see the complete sentence.
Welcome to psql 8.2.5 (server 8.2.9), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
=> select * from table_name;
In this sentence I was use the up key to load the previous sentence and this is what I see.
=> select * from \d summary_table;
The sentense start after "=> select * from" I don't know why this is happen.
Thanks for all help you can provide me!
Best regard,
--
Life may only be understood backwards.... but it must be lived forwards
I have a problem in my psql console (psql 8.2.5 on Mac 10.5.6), the problem is, when I write a sentence and then I use the up and down key to see the previous sentences the sentence is loaded above the previous sentences and I should use the left and rigth keys to go to the begining of the sentences and then go to the end to be able to see the complete sentence.
Welcome to psql 8.2.5 (server 8.2.9), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
=> select * from table_name;
In this sentence I was use the up key to load the previous sentence and this is what I see.
=> select * from \d summary_table;
The sentense start after "=> select * from" I don't know why this is happen.
Thanks for all help you can provide me!
Best regard,
--
Life may only be understood backwards.... but it must be lived forwards
Juan Camilo Marín wrote: > => select * from \d summary_table; > > The sentense start after "=> select * from" I don't know why this is > happen. Probably a terminal emulation issue. Readline will be sending the wrong escape sequences to control your terminal or your terminal will be misbehaving somehow. A common cause of readline issues is resizing your terminal window. Try testing in a terminal window that's the default size. If that works OK, try resizing it while it's still running the shell, THEN start psql. -- Craig Ringer
Hello Craig.
Thanks for your answer. I did what you say (use the default size of the terminal) but the problem persist, the psql still start to write the new senteces above the old one, it is to weird.
Best regards,
--
Life may only be understood backwards.... but it must be lived forwards
Thanks for your answer. I did what you say (use the default size of the terminal) but the problem persist, the psql still start to write the new senteces above the old one, it is to weird.
Best regards,
2009/5/10 Craig Ringer <craig@postnewspapers.com.au>
Juan Camilo Marín wrote:Probably a terminal emulation issue. Readline will be sending the wrong
> => select * from \d summary_table;
>
> The sentense start after "=> select * from" I don't know why this is
> happen.
escape sequences to control your terminal or your terminal will be
misbehaving somehow.
A common cause of readline issues is resizing your terminal window. Try
testing in a terminal window that's the default size. If that works OK,
try resizing it while it's still running the shell, THEN start psql.
--
Craig Ringer
--
Life may only be understood backwards.... but it must be lived forwards
in the psql prompt try this: \! stty sane Ing. Edmundo Robles Lopez. Analista Programador. -- -----Original Message----- From: pgsql-general-owner@postgresql.org on behalf of Juan Camilo Marín Sent: Wed 5/13/2009 12:58 PM To: Craig Ringer Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] lack in psql console Hello Craig. Thanks for your answer. I did what you say (use the default size of the terminal) but the problem persist, the psql still start to write the new senteces above the old one, it is to weird. Best regards, 2009/5/10 Craig Ringer <craig@postnewspapers.com.au> > Juan Camilo Marín wrote: > > > => select * from \d summary_table; > > > > The sentense start after "=> select * from" I don't know why this is > > happen. > > Probably a terminal emulation issue. Readline will be sending the wrong > escape sequences to control your terminal or your terminal will be > misbehaving somehow. > > A common cause of readline issues is resizing your terminal window. Try > testing in a terminal window that's the default size. If that works OK, > try resizing it while it's still running the shell, THEN start psql. > > -- > Craig Ringer > -- Life may only be understood backwards.... but it must be lived forwards
Hello .
The problem was fix it , it was a PROMPT1 issue, I was using color in the prompt ..
#\set PROMPT1 '%[%033[1;33;40m%]%n@%/%R%[%033[0m%#%] '
and I changed by
#\set PROMPT1 '%n@%/%R%[%033[0m%#%]'
and the problem was fixed :D
Thx to all!
--
Life may only be understood backwards.... but it must be lived forwards
The problem was fix it , it was a PROMPT1 issue, I was using color in the prompt ..
#\set PROMPT1 '%[%033[1;33;40m%]%n@%/%R%[%033[0m%#%] '
and I changed by
#\set PROMPT1 '%n@%/%R%[%033[0m%#%]'
and the problem was fixed :D
Thx to all!
On Wed, May 13, 2009 at 8:27 PM, Edmundo Robles L. <erobles@sensacd.com.mx> wrote:
in the psql prompt try this:
\! stty sane
Ing. Edmundo Robles Lopez.
Analista Programador.
----
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Juan Camilo Marín
Sent: Wed 5/13/2009 12:58 PM
To: Craig Ringer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] lack in psql console
Hello Craig.
Thanks for your answer. I did what you say (use the default size of the
terminal) but the problem persist, the psql still start to write the new
senteces above the old one, it is to weird.
Best regards,
2009/5/10 Craig Ringer <craig@postnewspapers.com.au>
> Juan Camilo Marín wrote:
>
> > => select * from \d summary_table;
> >
> > The sentense start after "=> select * from" I don't know why this is
> > happen.
>
> Probably a terminal emulation issue. Readline will be sending the wrong
> escape sequences to control your terminal or your terminal will be
> misbehaving somehow.
>
> A common cause of readline issues is resizing your terminal window. Try
> testing in a terminal window that's the default size. If that works OK,
> try resizing it while it's still running the shell, THEN start psql.
>
> --
> Craig Ringer
>
--
Life may only be understood backwards.... but it must be lived forwards
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Life may only be understood backwards.... but it must be lived forwards