Re: postgres via shell scripts - Mailing list pgsql-general

From bmccoy@chapelperilous.net
Subject Re: postgres via shell scripts
Date
Msg-id Pine.LNX.4.10.10010061113260.5786-100000@chapelperilous.net
Whole thread Raw
In response to postgres via shell scripts  (Mike Sears <msears@vianet.ca>)
Responses Re: postgres via shell scripts  (Jim Mercer <jim@reptiles.org>)
List pgsql-general
On Fri, 6 Oct 2000, Mike Sears wrote:

> Is there away to access a postgres database using a shell script, like bash
> or korn?

You can use

psql -c <query>

or

psql -f <filename>

to do command-line stuff inside of a script.  But then you have to figure
out how to parse the result.  You're probably better off going the next
step and using Perl.

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
Imagination is more important than knowledge.
        -- Albert Einstein



pgsql-general by date:

Previous
From: Mike Sears
Date:
Subject: postgres via shell scripts
Next
From: Jim Mercer
Date:
Subject: Re: postgres via shell scripts