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.
>
>
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. |