Skip site navigation (1) Skip section navigation (2)

Re: Command-line client sometimes misinterprets tabs for

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Casey Allen Shobe <cshobe(at)secureworks(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Command-line client sometimes misinterprets tabs for
Date: 2002-08-27 03:57:19
Message-ID: 1030420639.33213.24.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The problem is that most items in postgresql are tab completed.

Cut and past your text into a bash or zsh prompt.  It injects a bunch of
filenames into your data, as per tab completion.

Annoying, but for the benefits it's livable.

Perhaps a toggle could be created to disable tab completion?

On Mon, 2002-08-26 at 23:36, Casey Allen Shobe wrote:
> Let's say I have typed a nice formatted SQL statement like so:
> select		b1.blah,
> 		b1.blah2,
> 		b2.blah3
> from		blah_table as b1
> inner join only	blah_table2 as b2
> on		b1.blah = b2.blah;
> ...using tabs as the indenting medium.  Now I copy that from my editor into 
> psql, and most of the tabs are converted to nulls, resulting in an error like 
> "Unknown value fromblah_table".  Tabs should paste; they're normal 
> characters.
> -- 
> Casey Allen Shobe / Network Security Analyst & PHP Developer
> SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
> cshobe(at)secureworks(dot)net /
> Content is my own and does not necessarily represent my company.
> "Diagoras the Atheist once visited Samothrace and a friend there said to him, 
> 'You think the gods have no care for humans?  Why, you can see from all these 
> votive pictures here how many people have escaped the fury of storms at sea 
> by praying to the gods, who have brought them safe to harbour.'  'Yes, 
> indeed,' said Diagoras, 'but where are the pictures of all those who suffered 
> shipwreck and perished in the waves?'  On another occasion he was on a voyage 
> and the crew became anxious about the bad weather and began to mutter that it 
> served them right for taking an atheist on board.  Diagoras just pointed out 
> to them a number of other ships on the same course which were in equal 
> difficulties and asked them whether they thought that there was a Diagoras on 
> the passenger-list of every one of them.  The fact is that a man's character 
> or way of life makes no difference at all to his good luck or bad."
> - Cicero
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-08-27 05:48:33
Subject: Re: Command-line client sometimes misinterprets tabs for nulls
Previous:From: Casey Allen ShobeDate: 2002-08-27 03:36:15
Subject: Command-line client sometimes misinterprets tabs for nulls

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group