Re: Annoying messages when copy sql code to psql terminal

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Annoying messages when copy sql code to psql terminal
Дата
Msg-id b42b73150806060512k707d11f5hfa07fce5014e773d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Annoying messages when copy sql code to psql terminal  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Ответы Re: Annoying messages when copy sql code to psql terminal  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Viktor Rosenfeld
Дата:
Сообщение: Questions about index usage
Следующее
От: Alexandr Popov
Дата:
Сообщение: Problems with pg_dump ?