Re: psql & unix env variables

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: psql & unix env variables
Date: 2012-08-30 23:19:26
Message-ID: CAPTjJmrJMvsMga9YFh8C9BzceVDFLW-NdAe8G8J2j=-E14mpsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 30, 2012 at 4:42 PM, Achilleas Mantzios
<achill(at)smadev(dot)internal(dot)net> wrote:
> I have found useful the use of variable assignment in psql, e.g.
>
> #!/bin/sh
>
> # lets say you have some var with a value, or even populate some var with a value from
> # psql as shown below
> somevar=`psql -P pager=off -q -t -c "SELECT foo from bar" | head -1 | sed -e 's/ //g'`
>
> # now use that variable in psql, (what you want to achieve), but in more tight manner
> # than simple shell substitution (see -v switch and : notation)
>
> psql -P pager=off -q -v somevar=$somevar -c "select foo2 from bar2 where var=:somevar"

At this point, I have to ask: Why not switch to a language with actual
Postgres bindings? Try Python, or Pike, or something; I'm sure it's
going to be easier than doing everything through shell scripts.

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-08-30 23:27:01 Re: psql & unix env variables
Previous Message Mike Orr 2012-08-30 23:15:48 Re: Baseline configurations