pg_dump's octal strings -> oracle data load

From: Thomas Good <tomg(at)sqlclinic(dot)net>
To: PostgreSQL SQL List <pgsql-sql(at)postgreSQL(dot)org>
Subject: pg_dump's octal strings -> oracle data load
Date: 2002-08-13 18:00:13
Message-ID: Pine.LNX.4.33.0208131359250.9475-100000@q8.nrnet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I am working on the oracle port of my pg application and my data load
script contains \012 characters generated by pg.

Anyone have any ideas on what to change these to so that:

1) oracle doesn't barf during the load (^M causes this...
I'm loading from a -D flagged pg_dump sql script not
sql loader)
2) I get clean line breaks in perl generated html (^L does not
do this.)

?

Obviously <br> would do it but I'm hoping there is a better candidate
for search and replace.

Thanks!
-----------------------------------------------------------------------
Thomas Good e-mail: tomg(at)sqlclinic(dot)net
Programmer/Analyst phone: (+1) 718.818.5528
Residential Services fax: (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359
-- --
SQL Clinic - An Open Source Clinical Record www.sqlclinic.net
------------------------------------------------------------------------

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Held 2002-08-13 18:45:42 Re: update on a large table
Previous Message Peter Atkins 2002-08-13 17:29:43 Delete function without knowing the elements