Re: running from a script

On Thu, 2002-06-27 at 07:16, 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

So, you're trying to get from Unix what you got in The World's Greatest
Operating System?  You'll never totally emulate it.  <sigh>  And Rdb
_is_ still the greatest...

> commands
> out of cron or another scheduler.  Any help of snipits on how to get started
> would be appreciated. -Mark

Is this what you want?

psql -d test2 -c "vacuum verbose analyze t_lane_tx;"

--
+-------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net         |
| Jefferson, LA  USA      http://ronandheather.dhs.org:81     |
|                                                             |
| "Object-oriented programming is an exceptionally bad idea   |
|  which could only have originated in California."           |
|  --Edsger Dijkstra                                          |
+-------------------------------------------------------------+