Postgres Pro
Downloads
Home   >   mailing lists

Reload of database with escaped data. - Mailing list pgsql-hackers

From Michael J. Rogan
Subject Reload of database with escaped data.
Date
Msg-id 199802282150.QAA26490@amperes.fpelectronics.com
Whole thread Raw
Responses Re: [HACKERS] Reload of database with escaped data.  ("Michael J. Rogan" <mrogan@fpelectronics.com>)
List pgsql-hackers
Tree view 
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 *

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Is "CREATE DOMAIN" in 6.3 ??
Next
From: "Michael J. Rogan"
Date:
Subject: Re: [HACKERS] Reload of database with escaped data.