Re: Annoying messages when copy sql code to psql terminal

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
Cc: "A B" <gentosaker(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Annoying messages when copy sql code to psql terminal
Date: 2008-06-06 12:12:18
Message-ID: b42b73150806060512k707d11f5hfa07fce5014e773d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexandr Popov 2008-06-06 13:25:44 Problems with pg_dump ?
Previous Message Tim Tassonis 2008-06-06 10:35:41 Re: Temporary Tables and Web Application