Re: [SQL] bash & postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: [SQL] bash & postgres
Date
Msg-id 8330.1237817102@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] bash & postgres  (Erik Jones <ejones@engineyard.com>)
Responses Re: [SQL] bash & postgres  (Erik Jones <ejones@engineyard.com>)
List pgsql-general
Erik Jones <ejones@engineyard.com> writes:
> On Mar 22, 2009, at 9:03 PM, Greenhorn wrote:
>> How do I use \c (or any other psql commands beginning with a "\") in a
>> bash script?

> For multi-line input to a psql call in a bash (or any decent shell)
> script, I'd use a here document:

Or echo/cat the script into psql's stdin, if you prefer that type of
notation.  The reason you have to do this is that psql doesn't recognize
backslash commands in a -c string.  There's a school of thought that
doesn't want us to allow multiple commands in a -c string, even.

            regards, tom lane

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: debugging in pgadmin
Next
From: jrufener
Date:
Subject: problem with at proramn