Re: Annoying messages when copy sql code to psql terminal

On Thu, 2008-06-05 at 22:28 -0400, Merlin Moncure wrote:

As others have noted, you have tabs in your sql source.  I'd advise if
possible, not to use the tab character in sql, for this and other
reasons.

Tabs in SQL are a problem only if you copy-paste. If your editor and psql can see the same files (i.e., are running on the same machine or you're saving to a network fs), it's more reliable to save the file and read it in psql with \i or with psql -f. (\i and -f won't try to do tab completion, of course.)

-Reece

-- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0