Re: BUG #10991: psql -c ignores my pager settings in ~/.psqlrc

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: andrew(dot)pennebaker(at)gmail(dot)com, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #10991: psql -c ignores my pager settings in ~/.psqlrc
Date: 2014-07-18 20:17:42
Message-ID: CAJghg4+2DQGCJY0O4NcsiLdoj-gH3FFR9U+f_TnLLY5p10+L3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jul 18, 2014 at 2:36 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:

> > This works for psql -f <script>.psql. However, when I run one-off
> commands
> > with psql -c <command>, the pager pops up again, making psql -c really
> hard
> > to use in my Emacs workflow.
>
> .psqlrc file is ignored with -c option. This behavior is documented.
> http://www.postgresql.org/docs/devel/static/app-psql.html#R1-APP-PSQL-3

A nice workaround is:

$ echo "YOUR COMMANDS HERE" | psql

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2014-07-20 05:57:55 Re: BUG #10989: log_statement = ddl does not log ddl statements from stored functions
Previous Message Arthur O'Dwyer 2014-07-18 18:58:49 Re: BUG #10976: Two memory leaks in regcomp cleanup