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

From Gurjeet Singh
Subject Re: Annoying messages when copy sql code to psql terminal
Date
Msg-id 65937bea0806052139i1f6b9613qd07166bfe30c031d@mail.gmail.com
Whole thread Raw
In response to Re: Annoying messages when copy sql code to psql terminal  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: Annoying messages when copy sql code to psql terminal  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
On Tue, May 27, 2008 at 9:24 AM, A B <gentosaker@gmail.com> wrote:
> Whenever I use copy-paste to run code in a terminal window that is
> running psql, and the code contains a row like
>
> IF FOUND THEN
>
> then I get the words
>
> ABORT        CHECKPOINT   COMMIT       DECLARE      EXECUTE

[...]

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.

Can you please elaborate on other reasons? I have never encountered any _other_ reason!!

And 'using psql' is not reason enough to not indent your SQL code.

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Extracting data from deprecated MONEY fields
Next
From: "Brent Wood"
Date:
Subject: Re: Temporary Tables and Web Application