[SQL] Help
Hi, I am a user of postgresql. I want to know that it is possible to call a jsp file in postgre command.Please help me to know how to call a jsp file. Thank you Ebrahim __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] Help
Hi, I am a user postgresql. I want to update a table automatically when we reach monthend. i.e i want to update some table on 31 of every month automatically without any user attention. I want to know how to do this. If anyone knows how to do this please mail me. i will be ever thankfull to him Thank you Ebrahim __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] requesting help
Hi I am an user of postgresql. I want to do some manipulation on table and i want to do some java stuff after inserting a row into table(i.e like sending email). I want to fire the trigger to do this after the insertion took place. I know how to insert into the table but i want to know that it is possible to java stuff after inserting rows each time. Please help me in this stuff. I will be thankful to you. Thank you Ebrahim __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] Help
Hi, Thanks for your valuable information. I tried the cron. i typed cron -e and entereed into the input area. but i don't know how to save the cron file. I pressed ctrl+z and came out from cron. but i edit the cron file i found nothing on it.(i.e using pico filename.) Please tell me some description how to save the file in cron and to achive this. I will be thankful to you. Ebrahim > I am a user postgresql. I want to update a table > automatically when we reach monthend. i.e i want to > update some table on 31 of every month automatically > without any user attention. I want to know how to do > this. If anyone knows how to do this please mail me. >i > will be ever thankfull to him. >Joe wrote: > >Probably the easiest way to do this is to write a >script and run it >from >cron. For example, if your update query is in a file >called >$HOME/bin/monthend.sql: > >insert into mymonthendtable(f1, f2, f3) >values(123,'03/31/2001',12345.67); > >your script (call it $HOME/bin/monthend.sh) might >look like: > >#!/bin/sh >psql -U postgres mydatabasename < >$HOME/bin/monthend.sql > >then run (see "man 5 crontab" for more on cron) >crontab -e > >and add an entry like > ># run at 2:15 AM on the 30th of every month >15 2 30 * * $HOME/bin/monthend.sh > >Hope this helps, > >Joe > __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
