Re: psql variables

From: George Essig <george(dot)essig(at)gmail(dot)com>
To: Paul Cunningham <paul(at)blueseacommunications(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql variables
Date: 2005-03-21 15:39:58
Message-ID: 6744b38505032107393b19cba4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 14 Mar 2005 11:06:32 -0500, Paul Cunningham
<paul(at)blueseacommunications(dot)com> wrote:
> I use a bash script (similar to following example) to update tables.
>
> psql -v passed_in_var=\'some_value\' -f script_name ....
>
> Is it possible to pass a value back from psql to the bash script?

You can use '\! [ command ]' to execute shell commands within psql.
This may not be what you want though.

George Essig

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Asger Petersen 2005-03-21 15:44:48 Extremely slow queries
Previous Message Hrishikesh Deshmukh 2005-03-21 15:29:51 Time Stamp