Cleaning up a text import

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Cleaning up a text import
Date: 2013-06-28 16:36:44
Message-ID: 51CDBB9C.6000500@shaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I imported some text using the Quantum GIS dxf2postgiswhich somehow
became distorted through the import.

What should have been imported was TK-208.

What I got was %%UTK-208%%U.

Perhaps I did something wrong while using dxf2postgis?

Otherwise, I can trim the text using - select trim (both '% U' from
'%%UTK-208%%U') .

However I would need to know what it is that needs to be trimmed from
future imports, which isn't always possible.

I would appreciate any suggestions on how to resolve this.

Many thanks in advance.

Bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2013-06-28 16:57:41 Re: AFTER triggers and constraints
Previous Message Tom Lane 2013-06-28 16:17:31 Re: AFTER triggers and constraints