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

From Merlin Moncure
Subject Re: Annoying messages when copy sql code to psql terminal
Date
Msg-id b42b73150806060512k707d11f5hfa07fce5014e773d@mail.gmail.com
Whole thread Raw
In response to Re: Annoying messages when copy sql code to psql terminal  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Re: Annoying messages when copy sql code to psql terminal
List pgsql-general
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.

merlin

pgsql-general by date:

Previous
From: Viktor Rosenfeld
Date:
Subject: Questions about index usage
Next
From: Alexandr Popov
Date:
Subject: Problems with pg_dump ?