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@secureworks.net / http://www.secureworks.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@postgresql.org)
>