On 03/06/2011 03:38 PM, Andrey Luiz wrote:
Ooow, ok.
Undertood.
But, How I can do, where I type a text field data type, to insert it in a correct format, with the "\n".

I included an example of that already:

insert into test values (E'first line\nsecond line');

If your user-provided data is coming from a <textarea> HTML element then it likely already has "\n" characters embedded in it, so you probably won't need to do any sort of formatting. See also:

http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS-ESCAPE

Lance

--
You received this message because you are subscribed to the Google Groups 
"web.py" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/webpy?hl=en.

Reply via email to