Thread: Reload of database with escaped data.

Reload of database with escaped data.

From
"Michael J. Rogan"
Date:
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 *

Re: [HACKERS] Reload of database with escaped data.

From
"Michael J. Rogan"
Date:
 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 *