Thread

1. Reload of database with escaped data.

   Michael J. Rogan <mrogan@fpelectronics.com> — 1998-02-28T15:43:49Z

   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 *
   
   

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

   Michael J. Rogan <mrogan@fpelectronics.com> — 1998-02-28T16:13:01Z

    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 *