Skip site navigation (1) Skip section navigation (2)

Re: Automation

From: ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca
To: Jerome Macaranas <macky(at)edsamail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Automation
Date: 2000-10-13 01:49:52
Message-ID: Pine.A41.3.95.1001012194416.42162B-100000@freenet.edmonton.ab.ca (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, 13 Oct 2000, Jerome Macaranas wrote:

> I need to create reports every month for the marketing people...
> 
> I need suggestion on how to automate that... 
>  
> I thought of querying  but it will make the mail server slow and cause it to hang.... 
> 
> Hope you can help me...  Thanks is adance.. 

Pick a language which has a libpq interface (C, C++, perl, ...)
and write your queries with that program/interface to
PostgreSQL.  Have the results of the queries either 
sent to the appropriate printer or mailed from within
the program.  You can have cron execute the program/script 
(as a particular user if needed) whenever you want.
Every 4th sunday at 3:03 am, whatever.  Perl has
modules for talking to PostgreSQL and mail, which
takes a lot of work out of it, but any language
will do.  As far as when it executes, see the man page on
how to set up cron for your purposes.

Gord

Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (cell)



In response to

  • Automation at 2000-10-13 01:38:00 from Jerome Macaranas

pgsql-novice by date

Next:From: Mike WhiteDate: 2000-10-13 02:15:47
Subject: starting postmaster problems
Previous:From: Jerome MacaranasDate: 2000-10-13 01:38:00
Subject: Automation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group