| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike White | 2000-10-13 02:15:47 | starting postmaster problems |
| Previous Message | Jerome Macaranas | 2000-10-13 01:38:00 | Automation |