Re: Annoying messages when copy sql code to psql terminal - Mailing list pgsql-general

From Reece Hart
Subject Re: Annoying messages when copy sql code to psql terminal
Date
Msg-id 1212772433.7018.12.camel@snafu
Whole thread Raw
In response to Re: Annoying messages when copy sql code to psql terminal  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Annoying messages when copy sql code to psql terminal
Next
From: Gary Fu
Date:
Subject: Re: how to clean up temporary schemas (how to sync the system table with pg_dump)