Re: shell scripting - Mailing list pgsql-general

From Björn Lundin
Subject Re: shell scripting
Date
Msg-id amii81$2j1a$1@news.hub.org
Whole thread Raw
In response to shell scripting  (Marc Tardif <intmktg@CAM.ORG>)
List pgsql-general
Frank wrote:

> Hello,
>
> I am a PostgreSQL newbie stuck with the following question; can I write a
> unix shell script with sql statements and execute this in postgresql? In
> other databases one can use "@ /tmp/script.sql" or "start
> /path-to-script/script.sql". How can this be done in postgresql?
>
> tia,
>
> Frank
man psql

       -c, --command query
              Specifies that psql is to execute one query string,
              query,  and  then  exit.  This  is  useful in shell
              scripts.

/Björn

pgsql-general by date:

Previous
From: patrick
Date:
Subject: PostgreSQL consultanting oportiunity
Next
From: Lee Harr
Date:
Subject: Re: executing sql statements from file