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
------------------------------------------------------------------------
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 |