Problem saving emails to database.

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Problem saving emails to database.
Date: 2010-04-25 17:31:12
Message-ID: n2g18f98e681004251031r94e05c6cmadcd72989cd6e259@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

It is the first time that I store emails in a database to send them later...

Let me explain the problem... I'am sending text emails, and to break the
lines of the message I use "\n". The first problem was to stores the "\". To
INSERT "\n" I need to write "\\n". When I do a SELECT I see "\n" but when I
dump the database in the INSERTS I see "\\n".

The problem with this is that when I send an email the "\n" that I see in
the SELECT returns simply "n" in the email and does not break the line.

This problem have solution?

Best Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Little, Douglas 2010-04-25 17:45:48 ALTER Bigserial error
Previous Message dario.ber@libero.it 2010-04-25 15:59:12 R: Catch exception from plpy