Postgres Pro
Downloads
Home   >   mailing lists

Cleaning up a text import - Mailing list pgsql-general

From Bob Pawley
Subject Cleaning up a text import
Date
Msg-id 51CDBB9C.6000500@shaw.ca
Whole thread Raw
Responses Re: Cleaning up a text import
List pgsql-general
Tree view
Hi

I imported some text using the Quantum GIS dxf2postgis which 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: AFTER triggers and constraints
Next
From: Simon Riggs
Date:
Subject: Re: AFTER triggers and constraints