|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Pgagent help
Hi
I'm new on postgresql and we had implemnted pgagent. We can scheduled jobs, but we cannot find where outcomes data are placed, how to feed external table or place data to external flat file ? Thank in advance for your help cheers /Kristoff |
|
#2
|
||||
|
||||
|
Can't you just schedule a query that sends it's output to a flat file? You can also schedule a batch job (here )
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Last edited by pabloj : March 28th, 2008 at 04:15 AM. |
|
#3
|
|||
|
|||
|
Thanks, got it now, despite I think pgagent doc is somehow poor, especially for me newbie...I'll learn
![]() See ya |
|
#4
|
||||
|
||||
|
You are right, there should be a basic tutorial.
|
![]() |
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Pgagent help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|