Problem saving emails to database. - Mailing list pgsql-general

From Andre Lopes
Subject Problem saving emails to database.
Date
Msg-id n2g18f98e681004251031r94e05c6cmadcd72989cd6e259@mail.gmail.com
Whole thread Raw
Responses Re: Problem saving emails to database.  (Raymond O'Donnell <rod@iol.ie>)
List 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,

pgsql-general by date:

Previous
From: "dario.ber@libero.it"
Date:
Subject: R: Catch exception from plpy
Next
From: "Little, Douglas"
Date:
Subject: ALTER Bigserial error