Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15922; Mon, 21 Oct 91 21:28:57 -0700
From: Rod Rebello -- CAD Development <rrebello@titan>
Subject: embedding new lines in text strings?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
From: Rod Rebello -- CAD Development <rrebello@titan>
To: postgres@postgres.berkeley.edu
Date: 	Mon, 21 Oct 1991 17:35:54 -0700
X-Mailer: ELM [version 2.3 PL11]
Message-Id: <91Oct21.172325mst.63108@titan>

I want to store text strings in the the database which may contain new line
characters.  Postgres (actually the scanner) complains that there is an
"Unterminated char/string constant".  I can't easily escape the new line
chars (if this would work) because the text is coming from a user typing into
a tty.  I just grab the buffer and try to save it.  To escape the new lines,
I would actually have to scan the buffer and modify it (yech).  

Is there an easy way around this problem?  Can the scanner safely be modified 
to ignore new lines just in strings of type text?  

Or am I all wet and just don't know what I'm doing?


-- 
Rod Rebello
titan!rrebello@asuvax.eas.asu.edu
Microchip Technology Inc., Chandler, AZ