Thread: Psql 9.4 with server 9.4 doesn't auto complete table names
Hi on 9.1 the psql did auto complete for tables. I've removed 9.1 and installed 9.4 and the auto complete doesn't work.
Any idea what I need to check?
How did you install it? Did you configure and compile it yourself, locally? If so, what did your ./configure look like? If not, how did you do it? Perhaps it was configured with the --without-readline switch set. I found that, on 9.3.5, that if I start psql normally (no switches), then a <tab> does the table completion (as normal). But if I do "psql -n" to turn off readline, then a <tab> just puts in a tab. I hope this might be of some help, though I don't really see how.
On Mon, Jan 26, 2015 at 10:21 AM, amihay gonen <agonenil@gmail.com> wrote:
Hi on 9.1 the psql did auto complete for tables. I've removed 9.1 and installed 9.4 and the auto complete doesn't work.
Any idea what I need to check?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
John McKown
I've use this link http://tecadmin.net/install-postgresql-server-on-ubuntu/ it bascily offical postgres repo.
On Mon Jan 26 2015 at 6:51:52 PM John McKown <john.archie.mckown@gmail.com> wrote:
How did you install it? Did you configure and compile it yourself, locally? If so, what did your ./configure look like? If not, how did you do it? Perhaps it was configured with the --without-readline switch set. I found that, on 9.3.5, that if I start psql normally (no switches), then a <tab> does the table completion (as normal). But if I do "psql -n" to turn off readline, then a <tab> just puts in a tab. I hope this might be of some help, though I don't really see how.On Mon, Jan 26, 2015 at 10:21 AM, amihay gonen <agonenil@gmail.com> wrote:Hi on 9.1 the psql did auto complete for tables. I've removed 9.1 and installed 9.4 and the auto complete doesn't work.
Any idea what I need to check?
--He's about as useful as a wax frying pan.10 to the 12th power microphones = 1 MegaphoneMaranatha! <><
John McKown
On 01/26/2015 12:29 PM, amihay gonen wrote: > I've use this link > http://tecadmin.net/install-postgresql-server-on-ubuntu/ it bascily > offical postgres repo. Well if you followed the above exactly, I do not see where it downloads postgresql-client, which provides psql. Best guess is you are using the 9.1 version of psql to connect to a 9.4 server. I would apt-get install postgresql-client and see if that helps. > > > On Mon Jan 26 2015 at 6:51:52 PM John McKown > <john.archie.mckown@gmail.com <mailto:john.archie.mckown@gmail.com>> wrote: > > How did you install it? Did you configure and compile it yourself, > locally? If so, what did your ./configure look like? If not, how did > you do it? Perhaps it was configured with the --without-readline > switch set. I found that, on 9.3.5, that if I start psql normally > (no switches), then a <tab> does the table completion (as normal). > But if I do "psql -n" to turn off readline, then a <tab> just puts > in a tab. I hope this might be of some help, though I don't really > see how. > > On Mon, Jan 26, 2015 at 10:21 AM, amihay gonen <agonenil@gmail.com > <mailto:agonenil@gmail.com>> wrote: > > Hi on 9.1 the psql did auto complete for tables. I've > removed 9.1 and installed 9.4 and the auto complete doesn't work. > > Any idea what I need to check? > > > > > -- > He's about as useful as a wax frying pan. > > 10 to the 12th power microphones = 1 Megaphone > > Maranatha! <>< > John McKown > -- Adrian Klaver adrian.klaver@aklaver.com