On 2012-01-13, 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 || E'\n' ...
To enable the backslash escape you prefix the literal with the letter E
David J.
On Jan 13, 2012, at 7:11, 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
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,
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 la