Re: Issue with psqlrc with command line.

From: saurabh shelar <saurabhshelar5(at)gmail(dot)com>
To: david(dot)g(dot)johnston(at)gmail(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Issue with psqlrc with command line.
Date: 2018-08-29 15:18:26
Message-ID: CALBKi8am25N=8W6ejtnxShemjuu1Rds-+gbDe=648P0Dgy0JTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi David,

Thank you for the swift response.

However, could you please confirm if the below scenario is expected.

- included the alias in the file.
- And passed the file with psql and it worked.

*-bash-4.2$ cat test *
*:testing*

*-bash-4.2$ /opt/PostgreSQL/9.6/bin/psql -f test *
* id *
*----*
* 1*

On Wed, Aug 29, 2018 at 8:44 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wednesday, August 29, 2018, saurabh shelar <saurabhshelar5(at)gmail(dot)com>
> wrote:
>>
>> As per the document from PG-9.6 it is possible.
>>
>
> You cannot use psql variables with -c
>
> “ command must be either a command string that is completely parsable by
> the server (i.e., it contains no psql-specific features), or a single
> backslash command.”
>
> https://www.postgresql.org/docs/10/static/app-psql.html
>
> David J.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-08-29 15:24:01 Re: Issue with psqlrc with command line.
Previous Message David G. Johnston 2018-08-29 15:13:58 Re: Issue with psqlrc with command line.