
Hello

What is the best way to deal with ' " \ in a char/varchar/text fields?

I have escaped them with \ which works and pg_dump dumps them correctly 
however psql does not accept them.  Is there a way to tell psql to pass 
all commands it does not understand?

I need \\ \' \" passed through to the database or do I have to write my 
own reload program or modify psql myself?

Michael

* Michael J. Rogan,  Network Administrator,   905-624-3020 *
* Mark IV Industries, F-P Electronics & I.V.H.S. Divisions *
* mrogan@fpelectronics.com                 mrogan@ivhs.com *

Sat, 28 Feb 1998 15:43:49 +0000
"Michael J. Rogan" <mrogan@fpelectronics.com>
Reload of database with escaped data.
 Hello

Looking at the psql.c file it looks like it already checks to see if it is 
in a quoted string so it seems that it is broken.
Could someone check the latest tree?

Michael

> 
> What is the best way to deal with ' " psql.c in a char/varchar/text fields?
> 
> I have escaped them with \ which works and pg_dump dumps them correctly 
> however psql does not accept them.  Is there a way to tell psql to pass 
> all commands it does not understand?
> 
> I need \\ \' \" passed through to the database or do I have to write my 
> own reload program or modify psql myself?
> 
> Michael
> 
> * Michael J. Rogan,  Network Administrator,   905-624-3020 *
> * Mark IV Industries, F-P Electronics & I.V.H.S. Divisions *
> * mrogan@fpelectronics.com                 mrogan@ivhs.com *
> 
> 

* Michael J. Rogan,  Network Administrator,   905-624-3020 *
* Mark IV Industries, F-P Electronics & I.V.H.S. Divisions *
* mrogan@fpelectronics.com                 mrogan@ivhs.com *

Sat, 28 Feb 1998 16:13:01 +0000
"Michael J. Rogan" <mrogan@fpelectronics.com>
Re: [HACKERS] Reload of database with escaped data.