On 01/13/2012 05:11 AM, Alexander Farber wrote:
Hello!
I'm using PostgreSQL 8.4.9 on CentOS 6.2 and with bash.
The following cronjob works well for me
(trying to send a mail to myself - for moderation):
6 6 * * * psql -c "select
'http://mysite/user.php?id=' ||id, about from pref_rep where
length(about)> 1 and last_rated> now() - interval '1 day'"
but I can't figure out how to append a newline to the
1st value (because otherwise the line is too long
and I have to scroll right in my mail reader):
What I've tried sofar:
# history
1001 psql -c "select 'http://mysite/user.php?id=' ||id||'\n', about from
.....
1002 psql -c "select 'http://mysite/user.php?id=' ||id||'\\n', about
from .....
1003 psql -c "select 'http://mysite/user.php?id=' ||id|| "\\n",
about from .....
1004 psql -c "select 'http://mysite/user.php?id=' ||id|| \"\\n\",
about from .....
1005 psql -c "select 'http://mysite/user.php?id=' ||id|| \"\n\",
about from .....
1006 psql -c "select 'http://mysite/user.php?id=' ||id|| \'\n\',
about from .....
Thank you
Alex
Given that it's a constant, I would just drop the http header :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general