| From: | Ewald Geschwinde <webmaster(at)geschwinde(dot)net> |
|---|---|
| To: | "Molenda, Mark P" <mark(dot)molenda(at)eds(dot)com> |
| Cc: | "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: running from a script |
| Date: | 2002-06-27 14:40:58 |
| Message-ID: | 3D1B23FA.9030703@geschwinde.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Molenda, Mark P wrote:
>I've read through most of Bruce Momjian's book on PostgresSQL and I have not
>seen anything that shows how to run SQL commands from a script. I'm trying
>to emulate some of the work I've done with Oracle in the past where I was
>able to write either a DEC DCL script or a UNIX shell script to run SQL
>commands
>out of cron or another scheduler. Any help of snipits on how to get started
>would be appreciated. -Mark
>
>Mark P. Molenda <<...OLE_Obj...>>
>Senior Information Specialist
>NYSC
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>
>
psql -d database -U user < sqlfile
Is that what you mean ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2002-06-27 14:54:43 | Re: running from a script |
| Previous Message | Molenda, Mark P | 2002-06-27 12:16:15 | running from a script |