Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA01075; Sun, 23 Feb 92 21:33:06 -0800
Date: Sun, 23 Feb 92 21:33:06 -0800
Message-Id: <9202240533.AA01075@postgres.Berkeley.EDU>
From: postgres@jdsds1.ir.miami.edu (Raymond D. Frost)
Subject: newlines
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

I would like to store blocks of text with hard carriage returns.
The following seems to work for interactive appends from the 
keyboard.  How would I achieve the same result reading the text
from a file using the "copy from" command?  I've tried several
variations but am unable to get the newline characters read in
properly.

* create para (fill = text[]) \g

* append para (fill = "{line one \\n line two \\n line three}") \g

* retrieve (para.fill) \g

Query sent to backend is "retrieve (para.fill) "
---------------
| fill        |
---------------
| {"line one 
 line two 
 line three"}|
---------------

Raymond Frost
University of Miami