Re: Annoying messages when copy sql code to psql terminal

On Fri, Jun 6, 2008 at 6:12 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Fri, Jun 6, 2008 at 12:39 AM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> wrote:
>> On Fri, Jun 6, 2008 at 7:58 AM, Merlin Moncure <mmoncure(at)gmail(dot)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.