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

From Scott Marlowe
Subject Re: Annoying messages when copy sql code to psql terminal
Date
Msg-id dcc563d10806061005r72c424d8xa375350e8345a450@mail.gmail.com
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 Fri, Jun 6, 2008 at 6:12 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Fri, Jun 6, 2008 at 12:39 AM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
>> On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <mmoncure@gmail.com> 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.
>>
>> 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.
>
> For example, another reason tabs are annoying are how your function
> sources show up in '\df+' (escaped).  iirc you can get around this
> with '\x', but why bother with that?  Also, I am not suggesting not to
> indent your sql, just not to use the tab character.

Almost every decent text editor has the option to use spaces in place
of tabs.  Even Nano can do it.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: when to reindex?
Next
From: Reece Hart
Date:
Subject: Re: Annoying messages when copy sql code to psql terminal