Re: [GENERAL] Appending a newline to a column value - in a psql cronjob

2012-01-18 Thread Jasen Betts
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='

Re: [GENERAL] Appending a newline to a column value - in a psql cronjob

2012-01-13 Thread David Johnston
... || 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

Re: [GENERAL] Appending a newline to a column value - in a psql cronjob

2012-01-13 Thread Rob Sargentg
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,

[GENERAL] Appending a newline to a column value - in a psql cronjob

2012-01-13 Thread Alexander Farber
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