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 > [EMAIL PROTECTED] / 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 [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
